Teach Yourself VISUALLY Windows 10 is the visual learner's guide to the latest Windows upgrade. Completely updated to cover all the latest features, this book walks you step-by-step through over 150 essential Windows tasks. Using full color screen shots and clear instruction, you'll learn your way around the interface, set up user accounts, play media files, download photos from your camera, go online, set up email, and much more. You'll even learn how to customize Windows 10 to suit the way you work best, troubleshoot and repair common issues, and optimize system performance to take advantage of everything the operating system has to offer.
This guide has everything you need to know so you can take advantage of all Windows 10 has to offer.Learn essential Windows tasks with step-by-step instructions Customize Windows and optimize performance with simple tricks Troubleshoot and repair applications, and perform basic system maintenance Protect your files, manage media, create user accounts, and much more
If you are a visual learner, this guide is the easiest way to get up and running quickly. Patient pacing, plain-English instruction, and easy-to-follow screen shot-based tutorials show you everything you need to know every step of the way. If you want to get the most out of the latest Windows offering, Teach Yourself VISUALLY Windows 10 is the guide you need.
In addition, this book is part of Que’s exciting new Content Update Program. As Microsoft updates features of Windows 10, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP.
This massive book includes detailed step-by-step procedures, which you through even the most complex configuration and management tasks. Whether you have a traditional PC or a souped-up tablet with a touchscreen, Windows 10 In Depth is just the guide you need. It will get you through the learning curve to become a Windows 10 expert. The authors have scaled the steepest part of the learning curve for you. From the first page to the last, and from your first hour with Windows 10, Brian Knittel and Paul McFedries share their 50+ years of combined Windows, networking, and security experience with you.
Do more in less time!
Experienced with Windows? Don’t let Windows 10 make you feel like a beginner again! This book is packed with intensely useful knowledge, tips, and shortcuts you just won’t find anywhere else. It’s the fastest, best way to master Windows 10’s full power, revamped interface, and new tools—from the reconfigured Start menu to the Cortana personal assistant. This friendly, expert guide will make Windows 10 way more productive, painless, and fun, whether you’re running it on a computer or a tablet…at home, at work, on the road, anywhere!
· Take a quick guided tour of everything that’s new in Windows 10
· Get the most out of Edge, Microsoft’s modern web browser
· Navigate the Windows 10 interface (and customize it to make yourself more comfortable)
· Discover hidden shortcuts and timesavers you’d never find on your own
· Quickly locate and use files, media, apps, websites, and management tools
· Connect reliably and safely to networks, the Internet, and Wi-Fi hotspots
· Increase your efficiency by taking advantage of Windows 10’s virtual desktops
· Maximize the performance and reliability of your hardware and storage devices
· Set up a safe and effective network for your home or office
· Systematically protect yourself from viruses, spyware, snoops, fraud, and spam
· Use the most convenient and efficient interface for every task: keyboard, touch, pen, or voice
· Discover tweaks and customizations that are actually worth the effort
· Get more out of your Windows 10 laptop or tablet on the road
· Remotely use your Windows 10 computer and data from anywhere on earth
· Access even more power with Windows 10’s command-line utilities
· Use Hyper-V, the subsystem for Linux, and Windows containers to run other operating systems alongside Windows
· Troubleshoot the most common Windows 10 problems—and the toughest ones
This book is part of Que's Content Update Program (CUP), which provides content updates to certain books for major technology changes.
As Microsoft® makes significant updates to Windows 10, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via the free Web Edition of this book. For more information, go to informit.com/cup.
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
COVERS: Microsoft Office Excel 2013
Who knew how simple fixing your computer could be?
This is the easiest, most practical beginner’s guide to fixing your own computer… simple, reliable instructions and crystal-clear pictures that show you exactly how to do it yourself! Here’s a small sample of what you’ll learn:
•¿¿ Maintain your computer so it’s less likely to break in the first place
•¿¿ Perform simple “ounce of prevention” tasks now, so it’s easier to fix problems later
•¿¿ Learn simple troubleshooting techniques for figuring out what’s wrong
•¿¿ Find the right tools (you might already have them!)
•¿¿ Buy the right parts without spending more than you have to
•¿¿ Fix aggravating Windows startup problems
•¿¿ Smoothly recover from PC crashes
•¿¿ Perform basic hardware repairs or upgrades at home, often in minutes
•¿¿ Install a new hard disk, CD/DVD drive, or Blu-ray drive
•¿¿ Speed up your computer by adding memory or upgrading its processor
•¿¿ Troubleshoot and fix network and Internet connection problems
•¿¿ And much more…
Paul McFedries is a full-time technical writer and passionate computer tinkerer. He has authored more than 80 computer books that have sold more than 4 million copies. His recent titles include My Office 2013 RT, Windows 8 In Depth, Microsoft Windows 7 Unleashed, Microsoft Home Server 2011 Unleashed, and Tweak It and Freak It: A Killer Guide to Making Windows Run Your Way. He is also proprietor of Word Spy (www.wordspy.com), a website that tracks new words and phrases as they enter the English language.
Windows 10 Simplified is your absolute beginner's guide to the ins and outs of Windows. Fully updated to cover Windows 10, this highly visual guide covers all the new features in addition to the basics, giving you a one-stop resource for complete Windows 10 mastery. Every page features step-by-step screen shots and plain-English instructions that walk you through everything you need to know, no matter how new you are to Windows. You'll master the basics as you learn how to navigate the user interface, work with files, create user accounts, and practice using the tools that make Windows 10 the most efficient Windows upgrade yet.
This guide gets you up to speed quickly, with step-by-step screen shots that help you follow along with the clear, patient instruction.Shed your beginner status with easy-to-follow instructions Master the basics of the interface, files, and accounts Browse the web, use media features, and send and receive email Customize Windows to look and work the way you want
Learning new computer skills can be intimidating, but it doesn't have to be. Even if you have no Windows experience at all, this visually rich guide demonstrates everything you need to know, starting from the very beginning. If you're ready to become fluent in Windows, Windows 10 Simplified is the easiest, fastest way to learn.
If you learn more quickly when you can see how things are done, this Visual guide is the easiest way to get up and running on Windows 8. It covers more than 150 essential Windows tasks, using full-color screen shots and step-by-step instructions to show you just what to do. Learn your way around the interface and how to install programs, set up user accounts, play music and other media files, download photos from your digital camera, go online, set up and secure an e-mail account, and much more.The tried-and-true format for visual learners, using step-by-step instructions illustrated with full-color screen shots to show exactly how things are done More than 600,000 copies of previous Teach Yourself VISUALLY books on Windows have been sold Shows how to perform more than 150 Windows 8 tasks, including working with files, digital images, and media; customizing Windows; optimizing performance; and sharing a computer with multiple users Covers installing and repairing applications, system maintenance, setting up password-protected accounts, downloading photos to your computer, and managing media files
Teach Yourself VISUALLY Windows 8 is the fastest, easiest way for visual learners to get going with the newest version of Windows.
This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book.
Hone your advanced Excel 2016 skills. And earn the credential that proves it!
Sharpen the skills measured by these objectives:
Create and Manage Workbooks Apply Custom Formatting and Layouts Create Advanced Formulas Perform Data Analysis Create Advanced Charts and PivotTables
A Beginner’s Guide to Building and Upgrading a PC
Build It. Fix It. Own It. is the ultimate beginner’s guide to building and fixing your own PC. With a friendly, knowledgeable tone, this book shows the beginning PC builder everything he or she needs to know to build a computer or upgrade an existing one.
We step you through the parts that lurk inside a PC, from the motherboard and power supply to the CPU, memory, hard drive, video card, sound card, and networking hardware. In each case, you will learn how the hardware works, what it does, what types of hardware are available, and what to look for when buying the hardware.
Then we walk you step-by-step though a series of PC building projects. We show you how to build five different types of PC: a basic business PC, a home theater PC, a high-performance PC, a killer gaming PC, and a budget PC. And if building a new PC from scratch isn’t in your budget, we show you how to resurrect an old PC by swapping out a few key components.
When you have your PC built and running, we show you how to set up a wireless network and the BIOS and maintain your new rig.
Build It. Fix It. Own It. is the ultimate PC builder’s guide, even if you’ve never ventured inside a PC case before!
Paul McFedries is one of the industry’s most well known and respected technical writers and is a passionate computer tinkerer. He is the author of more than 70 computer books that have sold more than three million copies worldwide. His recent titles include the Sams Publishing books Windows Vista Unleashed and Windows Home Server Unleashed and the Que Publishing books Networking with Microsoft 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 also is the proprietor of Word Spy (www.wordspy.com), a website devoted to tracking new words and phrases as they enter the English language.
Covers PC Hardware
User Level Beginner—Intermediate
Excel expert Paul McFedries shows how to use Excel 2010’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 breakthrough Excel 2010 improvements–from Sparklines to the brand-new version of Solver. Along the way, you’ll 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.Create more powerful formulas 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 Troubleshoot problems with formulas, ranges, and functions
About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excelskills, and presents focused tasks and examples for performing them rapidly and effectively. Selectedby 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
If you're always hearing about the cool things Excel can do, here's your chance to see how to do them!Teach Yourself Visually Excel offers you a straightforward visual approach to working with the newest version of the world's leading spreadsheet program. Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time!
Excel can seem daunting, but with Teach Yourself Visually Excel, you'll quickly and painlessly learn how to perform dozens of tasks, including creating spreadsheets and charts, filtering and sorting data, working with PivotTables, and so much more. Covering the latest additions and changes to the newest version of Excel, a series of easy-to-follow, full-color tutorials helps you to excel at working with Excel!Tutorials and step-by-step screenshots make lessons easy to follow and understand Helps you grasp the basic functions of Excel—and beyond Walks you through Excel s new features Clearly demonstrates how to organize, present, analyze, and chart data with Excel
Whether you've never used Excel or just need to brush up on its new features, Teach Yourself Visually Excel will be the dog-eared resource you'll turn to again and again.
Excel can be complicated, but this Visual guide shows you exactly how to tackle every essential task with full-color screen shots and step-by-step instructions. You'll see exactly what each step should look like as you learn to use all the new tools in this latest release of the world's most popular spreadsheet program. In easy two-page lessons, author Paul McFedries shows you how to organize, present, analyze, and chart data, over the web or on a network.The Visual learning system is perfect for teaching Excel; previous editions of this book have sold more than 230,000 copies Covers common Excel 2013 tasks such as creating spreadsheets and charts, filtering and sorting data, and working with PivotTables Provides step-by-step instructions for each task Each step is illustrated with full-color screenshots
Teach Yourself VISUALLY Excel 2013 offers visual learners the ideal way to master this popular but complex spreadsheet program.
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
The Complete Idiot's Guide® to Google Chrome OS presents readers with a clear overview of Google's free operating system-targeting users of netbook computers and allowing them to work primarily on the web - including how to send e-mail, work with pictures, save and manage files, use common office applications as well as more specialized programs, and deal with problems.
?Available day-and-date with the software
?Chrome OS will be free, making it very competitive with Windows 7
?Google boasts that Chrome OS will start up and get the user onto the web in a few seconds, without having to contend with viruses, malware, and security updates
Use Excel 2019 and Office 365 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including the latest improvements to arrays, formula error handling, and statistics. McFedries’ step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate- to advanced-level formula construction, and help you leverage Excel’s most useful functions in your everyday work. Becoming an Excel expert has never been easier!
By reading this book, you will:
• Improve business analyses by adding intelligence and knowledge to your models
• Replace cumbersome formulas with convenient predefined functions
• Radically simplify complex calculations with Office 365’s new dynamic arrays
• Use conditional formatting to reveal anomalies, problems, or opportunities
• Calculate loan payments, interest costs, terms, and amortization schedules
• Project the future value of investments, and plan to achieve investment goals
• Master essential discounting and cash-flow analysis tools, including net present value and internal rate of return
• Sort, filter, and analyze tabular data, from customers to inventory
• Easily analyze huge data sets with PivotTable calculations
About This Book
• For everyone who wants to get more done with Microsoft Excel in less time• For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
–Charles Carr, Reviews Editor, ComputorEdge Magazine
Create Forms for Business
Ensure Data Entry Accuracy
Build Elegant Form Interfaces
Collect Data Via Email
Design Effective Business Reports
Make an Invoice Report
Create Mailing Labels
Work with Multiple Tables
Develop your Microsoft Access expertise instantly with proven techniques
Let’s face it: Microsoft Access is a large, intimidating program. Most people never progress beyond creating simple tables and using wizards to build basic forms and reports. At the same time, you need information and you know that what you seek is embedded somewhere in your Access database. Without a more sophisticated knowledge of how to extract and present that data, you’re forced to rely on office gurus and overworked IT people to provide canned reports or one-size-fits-all solutions.
This book changes all that by giving you the skills to build efficient front-ends for data (forms), publish the results in an attractive and easy-to-read format (reports), and extract the data you need (queries). This book shuns the big Access picture and instead focuses intently on forms, reports, and queries. This in-depth approach will give you the knowledge and understanding you need to get at the data and prove the old saw that knowledge is power.
· Focuses on the three technologies that you must master to get the most out of Access: forms, reports, and queries.
· Avoids database theory in favor of practical know-how that you can put to use right away.
· Packed full of real-world examples and techniques to help you learn and understand the importance of each section.
· Covers what’s new and changed in Microsoft Access 2007.
Part I: Creating Forms
Chapter 1 Creating and Using a Form
Chapter 2 Working with Form Controls
Chapter 3 Designing Forms for Efficient and Accurate Data Entry
Chapter 4 Designing Forms for Business Use
Chapter 5 Creating Specialized Forms
Part II: Designing and Customizing Reports
Chapter 6 Creating and Publishing a Report
Chapter 7 Designing Effective Business Reports
Chapter 8 Designing Advanced Reports
Chapter 9 Creating Specialized Reports
Part III: Creating Powerful Queries
Chapter 10 Creating a Basic Query
Chapter 11 Building Criteria Expressions
Chapter 12 Working with Multiple-Table Queries
Chapter 13 Creating Advanced Queries
Chapter 14 Creating PivotTable Queries
Chapter 15 Querying with SQL Statements
The popular Simplified series makes visual learning easier than ever, and with more than 360,000 copies sold, previous Windows editions are among the bestselling Visual books. This guide goes straight to the point with easy-to-follow, two-page tutorials for each task. With full-color screen shots and step-by-step directions, it gets beginners up and running on the newest version of Windows right away. Learn to work with the new interface and improved Internet Explorer, manage files, share your computer, and much more.Perfect for the absolute beginner, with easy-to-follow instructions and colorful illustrations that show what's happening on the screen Covers Windows basics, navigating the interface, creating accounts to share a computer, customizing Windows, and working with files Demonstrates how to browse the web with the new version of Internet Explorer, how to use media features, and much more The bestselling Simplified series is designed to make it easy for visual learners to start using new technologies right away
Windows 8 Simplified gives visual learners confidence as they start using the new version of Windows quickly and easily.
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
Part of the Office 2013 productivity suite, Access enables you to organize, present, analyze, and share data on a network or over the web. With this Visual guide to show you how, you'll master the fundamentals of this robust database application in no time. Clear, step-by-step instructions are illustrated with full-color screen shots that show exactly what you should see on your screen. Learn to enter new records; create, edit, and design tables and forms; develop queries that generate specific reports; add smart tags to your tables; and much more.While it is the most widely used database application, Access is not particularly intuitive; the Visual system's two-page lessons and full-color screen shots make this complex software easier to learn Concise, step-by-step instructions and clear illustrations show you exactly what to expect Covers scores of tasks, including entering and setting up new records, organizing and sharing data, designing tables and forms, and generating reports Shows how to perform more complex operations, such as finding dependencies between database objects and adding smart tags to tables
Teach Yourself VISUALLY Access 2013 uses clear steps and high-resolution screen images to get you up and running with this popular database program.