Books by Paul McFedries

Excel is the most sophisticated spreadsheet program available, making it easy for you to create a variety of analyses and calculations for personal and professional use. However, this program is much more than just an electronic version of an accountant's green sheet, and mastering even the most basic functions can be a challenge.

Master core Excel tools for building powerful, reliable spreadsheets with Excel 2019 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel core features to solve problems and get the answers you need. Using real-world examples, McFedries helps readers get the absolute most out of features and improvements ranging from AutoFill to ExcelGÇÖs newest functions. Along the way, students will 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! Students will find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. GÇó Quickly create powerful spreadsheets with range names and array formulas GÇó Use conditional formatting to instantly reveal anomalies, problems, or opportunities GÇó Analyze your data with standard tables and PivotTables GÇó Use complex criteria to filter data in lists GÇó Understand correlations between data GÇó Perform sophisticated what-if analyses GÇó Use regression to track trends and make forecasts GÇó Build loan, investment, and discount formulas GÇó Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets

A fast-paced, useful, and easy introduction to Microsoft 365For those who need the show as well as the tell, Teach Yourself VISUALLY Microsoft 365 is the visual walkthrough to Microsoft's latest suite of office products that will get you up-to-speed faster than any other resource on the market. This book offers image- and screenshot-rich tutorials alongside step-by-step instructions so you can see what you need to do to make the most of Microsoft 365.From getting a grip on the most basic Microsoft 365 functions to the advanced, new features known only by power users, the book provides you with the tools you need to make your work more streamlined and efficient. You'll also get:* Up to date--and visually supported--guidance on the major Office apps that are part of Microsoft 365: Word, Excel, PowerPoint, Outlook, and Access* Full-color, two-page tutorials that get you up and running fast* Easy-to-read instructions and stepwise advice to accompany the informative and crystal-clear imagesIdeal for people using Microsoft 365 for the very first time, Teach Yourself VISUALLY Microsoft 365 is also a can't-miss resource for long-time users of the software suite who need an introduction to the latest version and Office veterans seeking a refresher on what Microsoft 365 is capable of.

Collaborate with colleagues in real timeThrough Google's single sign-in suite of products, students, employees, and businesses can work seamlessly in G Suite's cloud-based office productivity apps: Gmail, Calendar, Docs and Sheets, Drive, Hangouts, Meet, and more. G Suite offers many benefits including security, reliability, and compatibility with other products. Three simple pricing plans are available to meet the usage and storage needs of large and small groups of collaborators.

Excel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY seriesIn Teach Yourself VISUALLY: Excel 365, veteran tech educator and writer Paul McFedries delivers a practical, step-by-step guide to using the latest version of the world's most popular spreadsheet app. The book is filled with easy two-page lessons containing large-size screenshots and walkthroughs demonstrating common and useful tasks in Excel 365. You'll learn how to present, analyze, visualize, and organize your data, as well as how to:* Create and fill spreadsheets, charts, tables, and PivotTables* Filter and sort your data, use and create formulas, and organize your information* Visualize your data with a variety of effective charts, graphs, and moreA can't-miss handbook perfect for anyone looking for straightforward and easy-to-follow tutorials on basic and advanced Excel techniques, Teach Yourself VISUALLY: Excel 365 offers users of previous Excel versions--and complete Excel newbies--a clear roadmap to mastering Excel.

Learn Windows 11 quickly, easily, and with expert help from a tech education masterWindows 11 Simplified is your from-scratch beginner's guide to the ins and outs of the latest version of Windows. It's fully updated to include all the coolest new features of Windows 11 and offers a highly visual roadmap - complete with tons of screenshots and illustrations - to Windows 11 mastery. You'll get up to speed on the basic, and not-so-basic, features of Windows 11 with plain-English instructions and step-by-step screenshots that walk you through every technique you need to know to make Windows 11 do what you want it to do.You'll learn to navigate the user interface, work with and manage files, create user accounts, and practice using the tools that make Windows 11 the most user-friendly and powerful version of the famous operating system yet. You'll also discover how to:* Master the basics, as well as a bunch of power-user tools, with easy-to-follow instructions* Learn your way around the interface, File Explorer, the Settings app, and more* Navigate the web, send emails, access online media, and chat with friends and family* Customize windows to look and feel exactly the way you want it toWith the right help, learning a new operating system can be fun, straightforward, and exciting. This book is perfect for everyone from those with no Windows experience at all to users of previous versions who just need a heads-up on the latest features. If you're ready to become a Windows 11 master, Windows 11 Simplified is the easiest and fastest way to do it.

Learn Zoom in a flash with step-by-step instructions and clear, full-size screenshotsFor anyone looking for a fast and easy way to learn the most popular videoconferencing software on the market today, Teach Yourself VISUALLY Zoom is your secret weapon. This hands-on guide skips the long-winded explanations and actually shows you how to do what you need to do in Zoom with full-size, color pictures and screenshots.Whether you're a total newbie to Zoom or you just need to brush up on some of the finer points of this practical software, you'll be up and running in no time at all. From joining and hosting Zoom meetings to protecting your privacy and security while you're online, Teach Yourself VISUALLY Zoom hits all the key features that make online meetings a breeze. You'll also learn to:* Integrate Zoom with other apps and share screens and PowerPoints with other meeting attendees* Schedule, record, and replay your meetings so you never miss out on the important stuff* Update your Zoom installation to ensure you're using the latest security patches and upgradesPerfect for anyone expected to use Zoom at school or at work, Teach Yourself VISUALLY Zoom is the most useful and simplest Zoom handbook currently available.

Your step-by-step guide to iPhone masteryiPhone Portable Genius delivers a practical and simple guide to quickly learning everything you need to know about the iPhone. Whether you're a novice user with Apple products or a seasoned pro, you'll find a wealth of info designed to show you how to configure your iPhone, set up accounts, manage your contacts and appointments, take stunning pictures, and surf the web. All while keeping your identity and accounts private and secure.Before you know it, you'll be:* Mastering the touchscreen* Setting up your iPhone to suit the way you work and play* Connecting your iPhone to Wi-Fi and setting up your phone as an internet hub* Solving the most common iPhone problems* Getting the most out of emailWith straightforward and step-by-step instructions in a portable and convenient package and engaging illustrations, iPhone Portable Genius is the ideal resource for owners and users of one of the world's most popular phones.

Your no-fluff, fast-paced guide to everything Windows 10This handy, jargon-free guide is designed to help you quickly learn whatever you need to know about Windows 10. Perfect for novices and experienced users alike, you'll get tips, tricks, and savvy advice on 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 email account, and much, much more.* Shows how to perform more than 150 Windows 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 staying safe onlineWith concise, easy-to-follow instructions, and its small, portable size, this is the ideal, on-the-go guide for Windows 10 users everywhere.

Designed to help students practice and prepare for Microsoft Office Specialist (MOS): Word 2019 Expert certification, this official Study Guide delivers: In-depth exam prep for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to apply skills learned Practice and review questions Ready-made practice files Solution files for the practice tasks Sharpen the skills measured by these MOS objectives: Manage document options and settings Design advanced documents Create advanced references Create custom word elements Use advanced editing and formatting featuresAbout MOSA Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams.

Hone your advanced Excel 2019 skills. And earn the credential that proves it!Demonstrate your expertise with Microsoft Excel! Designed to help students practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 2019 certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you've learned Ready-made practice files Solution files for the practice tasks 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 Pivot Tables

Enjoy more entertainment with this friendly user guide to making the most of Amazon Fire TV!Find and watch more of the shows you enjoy with Amazon Fire TV For Dummies. This book guides you through Fire TV connections and setup and then shows you how to get the most out of your device. This guide is the convenient way to access quick viewing tips, so there's no need to search online for information or feel frustrated. With this book by your side, you'll quickly feel right at home with your streaming device.Content today can be complicated. You want to watch shows on a variety of sources, such as Hulu, Amazon Prime, Netflix, and the top premium channels. Amazon's media device organizes the streaming of today's popular content services. It lets you use a single interface to connect to the entertainment you can't wait to watch. This book helps you navigate your Fire TV to find the content you really want. It will show you how to see your favorite movies, watch binge-worthy TV shows, and even play games on Fire TV.* Get the information you need to set up and start using Fire TV.* Understand the basics of how to use the device* Explore an array of useful features and streaming opportunities* Learn techniques to become a streaming proConquer the world of Fire TV with one easy-to-understand book. Soon you'll be discovering the latest popcorn-worthy shows.

Teach yourself VISUALLY(TM) Are you a visual learner? Do you prefer instructions that show you how to do something--and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 160 macOS High Sierra tasks. Each task-based spread covers a single technique, sure to help you get up and running on macOS High Sierra in no time. You'll learn to: Set default zoom for websites Install and use a content blocker Connect through FaceTime(R) Publish photo albums to Facebook Customize Siri(R), mouse, and trackpad Designed for visual learners Two-page lessons break big topics into bite-sized modules Succinct explanations walk you through step by step Full-color screen shots demonstrate each task Helpful sidebars offer practical tips and tricks

You're one of the legions of fans who enjoy the ease and simplicity of the Mac. But some functions still elude you. How do you synch your Mac with other devices? What are the best ways to organize your life and files with your Mac? Can you get more from your Mac hardware or upgrade it? The Portable Genius is here to help.

Understand and solve many different kinds of iPhone and iPad problems. This book covers both general troubleshooting techniques applicable in a wide variety of situations as well as specific fixes for topics such as networking, apps, photos, the battery, and syncing.Glitches, hiccups, and crashes just aren't supposed to happen with iOS, but alas, all too often they do. It is these non-obvious fixes, workarounds, and preventative measures that form the core of iOS Troubleshooting. With clear, straightforward prose, this book will take the reader through hundreds of iOS problems, explain the reasons for them, and provide easy to understand solutions to get the device (and you) back in business.    What you'll learn:Fix cellular and networking connectionsIncorporate accessories effectivelySolve battery and charging issuesClear up syncing and iCloud glitches Who this book is for:Any person who uses an iOS device.

A practical guide for visual learners eager to get started with Windows 8. 1 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.1.