Ebooks

This new edition covers the Fall Creators Update to Windows 10.


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.



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

Fix your own computer—without becoming a technical expert! This book is the fastest way to save money on computer repairs, avoid unnecessary frustration, and keep using perfectly good equipment instead of throwing it away! Even if you’re completely non-technical, you’ll learn how to get the job done, one incredibly clear and easy step at a time. Computer repair and maintenance has never, ever been this simple!

¿

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.

¿

Book + Content Update Program

Master core Excel 2016 tools for building powerful, reliable spreadsheets with Excel 2016 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel 2016’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 AutoFill 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 range names and array 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
• Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets

In addition, this book is part of Que’s exciting Content Update Program. As Microsoft updates features of Excel 2016, 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.

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

BUILD IT. FIX it. OWN IT.

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!

Author Bio

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.

Category Hardware

Covers PC Hardware

User Level Beginner—Intermediate

MASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS!

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
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
Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets.

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
“Everything you need to master Access 2007 forms, reports, and queries.”

–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

Extract Data

Work with Multiple Tables

Calculate Discounts

Analyze Data

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.

Introduction

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

Index

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
©2020 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.