Tweak It and Freak It A Killer Guide to Making Windows Run Your Way Hundreds of millions of people use Windows every day, and it’s a safe bet that some of them would not describe themselves as happy campers. Regardless of skill level, most people have something they dislike about Windows, and they often have a whole laundry list of Windows gripes. “Why can’t Windows do this rather than that?” “Why does Windows do X instead of Y?” “Wouldn’t it be great if Windows could do Z?” Most people think Windows is set in stone, but it isn’t! Strip off that veneer and a whole world comes into view, one that’s hackable, moddable, tweakable, customizable, and personalizable. This book shows you the tools and technologies that anyone can use to hack almost every aspect of Windows, from startup to shutdown, from the interface to the Internet, from security to scripting. • Speed up your tired PC with a fistful of easy-to-do, but oh so powerful tweaks! • Tired of looking at the same old Windows day in and day out? So are we! That’s why we show you how to give Windows a makeover! • Want to be more productive at work or home? This book is full of productivity tweaks that not only make Windows more fun to use, but also save you tons of time. • Create custom backup routines that safeguard your precious data. • Tighten the security of your PC and your network to stop would-be thieves in their tracks. • Dual-boot Windows XP and Vista on the same machine, or dare we say it, run MacOS on your PC! We won’t tell. Paul McFedries is a passionate computer tinkerer and Windows expert. He is the author of more than 60 computer books that have sold more than 3 million copies worldwide. His recent titles include the Sams Publishing books Windows Vista Unleashed, Second Edition, and Windows Home Server Unleashed, and the Que Publishing books Build It. Fix It. Own It. : Networking with Windows Vista, Formulas and Functions with Microsoft Excel 2007, Tricks of the Microsoft Office 2007 Gurus, and Microsoft Access 2007 Forms, Reports, and Queries. Paul is also the proprietor of Word Spy (www.wordspy.com), a website devoted to tracking new words and phrases as they enter the English language. CATEGORY: Windows Operating System COVERS: Windows Vista and XP USER LEVEL: Beginning-Intermediate

Covers the newest version of WHS! This is the most comprehensive, practical, and useful guide to the brand-new version of Windows Home Server 2011. Paul McFedries doesn’t just cover all facets of running Windows Home Server: He shows how to use it to simplify everything from file sharing to media streaming, backup to security. With real-world examples, McFedries guides you through using new features ranging from the Dashboard and Launchpad to Remote Web Access and Alert Viewer. You’ll find network configurations and step-by-step solutions you can easily understand and use, even if you have no server experience. Then, when you’re ready, McFedries reveals how Home Server’s hidden business-class features can help you save more time and get even better performance. Packed with exclusive tips and tricks, this go-to guide will help you every step of the way...as you create a home network that does more and runs perfectly! Quickly set up networks, user accounts, devices, and storage Add any computer to your network: Windows 7, Vista, XP, Mac, or Linux Efficiently share folders, files, and digital media Set up passwords and users and protect your sensitive information Reliably automate backups, so you never lose an important file Centrally manage all your storage, so you never have to buy more than you need Stream and share your digital images, audio, and video--even on your Xbox 360 or other devices Use Home Server’s built-in web server to create powerful, flexible websites Use Windows SharePoint Foundation to help everyone coordinate their busy lives Automatically apply up-to-date security fixes to all your Windows computers Remotely access your content from any Internet-connected computer–safely and securely Use Home Server power tools, including Local Group Policy Editor, Computer Management snap-ins, and scripting Efficiently monitor, maintain, tune, and troubleshoot Windows Home Server

Get comfortable with the newest way to use Microsoft Office 2010. Don’t just read about it: See it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the free Web Edition that comes with every USING book. For the price of the book you get online access anywhere with a web connection—no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you’ll ever need...where you want, when you want! Learn fast, learn easy, using web, video, and audio Show Me video walks through tasks you’ve just got to see—including bonus advanced techniques Tell Me More audio delivers practical insights straight from the experts UNLOCK THE FREE WEB EDITION—To register your USING book, visit quepublishing.com/using.

Master core Excel 2013 tools for building powerful, reliable spreadsheets! Excel expert Paul McFedries shows how to use Excel 2013’s core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from FlashFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation. Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.. • Quickly create powerful spreadsheets with FlashFill • Use conditional formatting to instantly reveal anomalies, problems, or opportunities • Analyze your data with standard tables and PivotTables • Use complex criteria to filter data in lists • Understand correlations between data • Perform sophisticated what-if analyses • Use regression to track trends and make forecasts • Build loan, investment, and discount formulas • Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will • Dramatically increase your productivity—saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make CATEGORY: Spreadsheets COVERS: Microsoft Office Excel 2013

Microsoft® Windows 7 Unleashed gives IT professionals, serious power users, and true geeks the powerhouse Windows 7 tweaks, hacks, techniques, and insights they need: knowledge that simply can’t be found anywhere else. Top Windows expert Paul McFedries dives deep into Windows 7, returning with the most powerful ways to handle everything from networking to administration, security to scripting. McFedries begins with advanced customization, covering everything from startup/shutdown to the file system. He introduces new ways to tune Windows 7 performance, police Windows via Group Policies, tweak the Registry, make the most of Windows 7s management tools, and control Windows 7 from the command line. You’ll find thorough coverage of securing Windows 7, including detailed guidance on web and email security and hardening both wireless and wired networks. You’ll also discover better ways to troubleshoot devices, networks, and startup; add Macs to Windows networks; and automate Windows administration with state-of-the-art scripting techniques. This book is packed with expert tips, tricks, and troubleshooting techniques drawn from McFedries’ unsurpassed Windows experience. If you want maximum value and performance from your Windows 7 PCs, you won’t find a more valuable resource. Customize everything about Windows 7: IE8, startup/shutdown, file systems, the Start menu, Taskbar, and more Systematically monitor, tune, and optimize Windows performance–including practical techniques for accelerating startup Set up an easy, automated 9-Step maintenance schedule for any Windows 7 PC Unleash Windows 7s power user tools, including Group Policies, the Registry, MMC, and the command line Secure Windows 7 with security settings: auto-lock, Windows Firewall, Windows Defender, parental controls, BitLocker encryption, and more Protect your web privacy with Windows 7s new InPrivate Browsing Solve problems with Windows 7, startup, networking, and hardware Set up reliable Windows 7 networks, and manage them efficiently Safely provide remote access and VPN connectivity Use Windows 7 as a Web server Program the Windows Scripting Host and Windows PowerShell ON THE WEB: Free Online Edition! When Microsoft releases the final product, you can get an updated edition of this book absolutely free! All examples and source code presented in this book

Advice and techniques that you need to get the job done. Looking for ways to streamline your work so that you can focus on maximizing your time? In Depth provides specific, tested, and proven solutions to the problems you run into every day–things other books ignore or oversimplify. This is the one book that you can rely on to answer all the questions you have now and will have in the future. In Depth offers: Comprehensive coverage with detailed solutions Breakthrough techniques and shortcuts that are unavailable elsewhere Practical, real-world examples with nothing glossed over or left out Troubleshooting help for tough problems you can’t fix on your own Outstanding authors recognized worldwide for their expertise and teaching style Quick information via sidebars, tips, reminders, notes, and warnings In Depth is the only tool you need to get more done in less time! CATEGORY: Macintosh Operating System COVERS: Mac OS X 10.6 Snow Leopard

Get comfortable with iPhone 4, the latest version of the iPhone. Don’t just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the price of the book, you get online access anywhere with a we connection—no books to carry, content is updated, and the benefit of video and audio learning. Way more than just a book, this is all the help you’ll ever need… Where you want, when you want! Learn fast, learn easy, using web, video, and audio Show Me video walks through tasks you’ve just got to see–including bonus advanced techniques Tell Me More audio delivers practical insights straight from the experts UNLOCK THE FREE WEB EDITION—To register your USING book, visit quepublishing.com/using. Covers: Apple iPhone Category: Apple Digital Media User Level: Beginner

*** This USING the iPhone book is enhanced with 1 hour of FREE step-by-step VIDEO TUTORIALS and AUDIO SIDEBARS! *** The iPhone is an all-in-one mobile device for talk, text, email, music, video and more. USING the iPhone is a media-rich learning experience designed to help new users master the iPhone quickly, and get the most out of it, fast! EVERY chapter has multiple video and audio files integrated into the learning material which creates interactive content that works together to teach everything mainstream the iPhone users need to know. You’ll Learn How to: - Get to Know Your Phone and the Phone Basics - Place and Receive Calls - Surf the Web on the iPhone - Send and Receive Email Messages - Manage Music and Contacts - Track Appointments and Events - Navigate Your World with Maps - Take and View Photos or Record and Play Videos - Work with Apps and the App Store - Customize the iPhone Examples of Topics Covered in VIDEO TUTORIALS, which Walk You Through Tasks You’ve Just Got to See! - Creating App Folders - Copy/Paste Text to iPhone - Editing iPhone Videos Examples of Topics Covered in AUDIO SIDEBARS, which Deliver Insights Straight From the Experts! - Understanding Cellular & Wireless Networks - Understanding POP and IMAP Email Accounts - Protecting Your iPhone Please note that due to the incredibly rich media included in your Enhanced eBook, you may experience longer download times. Please be patient while your product is delivered. This Enhanced eBook has been developed to match the Apple Enhanced eBook specifications for the iPad and may not render well on older iPhones or iPods or perform on other devices or reader applications.

Windows 8 In Depth Do more in less time! Experienced with Windows? Don’t let Windows 8 make you feel like a beginner again! This book is packed with intensely useful Windows 8 knowledge you won’t find anywhere else. Full of new tips and shortcuts, it’s the fastest, best way to master Windows 8’s full power, get comfortable with its radically different interface, and leverage its new tools for everything from business to video, security to social networking! • Take a quick guided tour of everything that’s new in Windows 8 • Survive without the Start menu • Navigate the new Windows 8 interface (and customize it to make yourself more comfortable) • Learn hidden shortcuts you’d never find on your own • Quickly locate and use files, media, apps, websites, and management tools • Set up your Web connection, and discover Internet Explorer 10’s latest improvements • Get comfortable with Windows 8’s built-in apps, from Calendar and Finance to Weather and Windows Store • Save time by monitoring Facebook, Twitter, and LinkedIn through one unified app • Make the most of Windows 8’s supercharged media and imaging tools • Profit from Windows 8’s built-in support for business presentations • Maximize the performance and efficiency of hardware, storage, and software • Protect yourself from viruses, spyware, data theft, fraud, spam, hackers, and snoops • Use SkyDrive to access your data from anywhere—and use Remote Desktop to access your computer, too • Get even more power with Windows 8’s command-line interface • Use Hyper-V to run other operating systems alongside Windows 8 • Troubleshoot the most common Windows 8 problems—and the toughest ones In Depth offers: • Comprehensive coverage, with detailed solutions • Breakthrough techniques and shortcuts that are unavailable elsewhere • Practical, real-world examples with nothing glossed over or left out • Troubleshooting help for tough problems you can’t fix on your own • Outstanding authors recognized worldwide for their expertise and teaching style • Quick information via sidebars, tips, reminders, notes, and warnings In Depth is the only tool you need to get more done in less time! CATEGORY: Windows Operating System COVERS: Microsoft® Windows 8

This is the most comprehensive, practical, and useful guide to Windows Home Server, including Microsoft’s major updates in PowerPacks 1, 2, and 3. Top Windows expert Paul McFedries brings together tips, techniques, and shortcuts available nowhere else and presents them all in plain English for every Windows Home Server user. McFedries covers all facets of running Windows Home Server: configuration, file/folder sharing, networking, media streaming and sharing, backup/restore, monitoring, Web and SharePoint site deployment, performance optimization, maintenance, and customization. He thoroughly addresses Windows Home Server’s new Windows 7 support, as well as major improvements in areas ranging from remote access to storing TV recordings. This edition presents comprehensive, up-to-the-minute guidance on Windows Home Server security, plus a full section of advanced solutions utilizing Microsoft’s power tools, the command line, and automated scripting. Throughout, McFedries demonstrates key techniques through real-world examples and presents practical configurations you can easily use in your own home. Detailed information on how to… Set up Windows Home Server networks, user accounts, devices, and storage Integrate with Windows 7’s new file libraries, backup/recovery tools, and Windows Search 4.0 Efficiently share folders, files, and digital media Ensure security for both local and remote users Automatically back up and restore all the computers on your home network Quickly set up web and SharePoint sites Tune, maintain, and troubleshoot Windows Home Server Use the new Remote Access Configuration and Repair Wizards