Hone your advanced Excel 2016 skills. And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 2016 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 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

Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel Microsoft Excel offers unsurpassed functionality and accessibility for data exploration and analysis to millions of users around the world. And learning to unlock its full potential is easier than you can imagine with help from Excel All-in-One For Dummies. Follow along with Excel expert and veteran author Paul McFedries as he walks you through every feature and technique you need to know to get the most out of this powerful software. You'll learn how to design worksheets, use formulas and functions, collaborate with colleagues and review their work, create charts and graphics, manage and analyze data, and create macros. Plus, you'll discover all the capabilities Microsoft has included in the newest versions of Excel, including dark mode and accessibility features. This indispensable reference allows you to: Get a firm grasp of Excel basics with the book's step-by-step guides before moving on to more advanced topics, like data analysis Access up-to-date information on all the new versions of Excel, including the ones bundled with Microsoft 365, Office 2021, and the LTSC/Enterprise Edition Enjoy the convenience of a single, comprehensive resource detailing everything you need to know about Excel Perfect for people coming to Excel for the very first time, Excel All-in-One For Dummies, Office 2021 Edition is also a must-read resource for anyone looking for a refresher on foundational or advanced Excel techniques.

Cut the cable television cord and cut your monthly bills Are you one of those people who have 500 television channels to choose from and you can never find anything to watch? Maybe it's time to cut the cable cord and take full control of what's on your television. All you need to get started with this popular money saving strategy is an Internet connection, a device to stream to, and the advice in this book. With Cord Cutting For Dummies, you go from evaluating if cord cutting is the right choice for your budget to acquiring the technology to get the programming you actually want. You'll discover the technology you need for streaming, select the service or services that fit your needs, and make the components of your setup work together--all within your budget. Cord Cutting For Dummies offers the steps to going from wired to wireless, including: Deciding if you need to upgrade your Wi-Fi equipment and service. Evaluating your current devices. Adding a smart TV to the mix. Choosing the best streaming services for you--including some free options When you're ready to untether yourself from the cable or satellite, Cord Cutting For Dummies shows you, step by step, how to break free. Pick up a copy and you'll be watching your favorite movie or TV show in no time!

A fast-paced, useful, and easy introduction to Microsoft 365 For 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 images Ideal 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.

Learn Zoom in a flash with step-by-step instructions and clear, full-size screenshots For 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 upgrades Perfect 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.

Make your every wish Alexa's command with this in-depth guide to the wildly popular Amazon smart speaker You might be thinking, "All I have to do is plug in my Echo device and start using it!" And you'd be right. But if you really want to explore what that compact little device can do, then Alexa For Dummies is your go-to resource. This book shows you how to customize your device to respond to your requests and enhance your life. Alexa For Dummies takes you on a tour of all things Alexa: its capabilities, tools, settings, and skills. Go beyond the basics of playing music, calling friends, reading the news, and checking the weather. You'll learn how to make Alexa private and secure, connect it to your smart home devices, and even make it sound like Samuel L. Jackson, if you feel like it. You can also extend its capabilities by adding new skills. Customize your device to respond to your voice Troubleshoot when a light is signaling something's wrong Add skills to play music and audiobooks Create routines to turn on lights, adjust the thermostat, set your security alarm, and lock your doors Sync your smart devices throughout your home Use Alexa to connect to a Zoom meeting or phone call with your friends or family No matter which device you have--Echo, Echo Dot, Echo Show, Echo Studio, Echo Flex, Echo Loop, Echo Buds, or Echo Frames--Alexa For Dummies is the perfect companion. Ready to get started? Say "Hey, Alexa, order Alexa For Dummies!"

Get fast answers to your G Suite questions with this friendly resource G Suite For Dummies is the fun guide to the productivity suite that's quickly winning over professional and personal users. This book shares the steps on how to collaborate in the cloud, create documents and spreadsheets, build presentations, and connect with chat or video. Written in the easy-to-follow For Dummies style, G Suite For Dummies covers the essential components of Google's popular software, including: Google Docs for word processing Gmail for email Google Calendar for scheduling and day planning Google Sheets for spreadsheet functionality Google Drive for data storage Google Hangouts and Google Meet for videoconferencing and calling capability The book helps navigate the G Suite payment plans and subscription options as well as settings that ensure your own privacy and security while operating in the cloud. Perfect for anyone hoping to get things done with this tool, G Suite For Dummies belongs on the bookshelf of every G Suite user who needs help from time to time.

Increase your iPad IQ with this genius-level guide to the Apple iPad If you want to squeeze every last bit of incredible from your Apple iPad we've got you covered with this newly revised iPad Portable Genius. Want to learn how to connect to a network? How to configure your tablet? How to surf the web more comfortably? All while keeping your identity and accounts private and secure? With the iPad Portable Genius as your guide, you'll unlock the full potential of your iPad in no time at all. You'll learn how to: Get the most out of sending and receiving your email Have fun with your images and take crystal-clear photos every time Shoot and edit video right on your iPad Manage your busy schedule with calendars Perfect for anyone looking to save time and reveal the true power and flexibility of their iPad, the iPad Portable Genius, Fourth Edition contains all the new, engaging, and extensively illustrated info you need to master your tablet.

Turn jumbles of numbers into graphics, insights, and answers with Excel With Microsoft Excel, you can, well, excel at data analysis. And Excel Data Analysis For Dummies can help, with clear and easy explanations of the mountain of features for creating, visualizing, and analyzing data. PivotTables, charts, what-if analysis, statistical functions--it's all in here, with examples and ideas for Excel users of all skill levels. This latest edition covers the most recent updates to Excel and Microsoft 365. You'll beef up your data skills and learn powerful techniques for turning numbers into knowledge. For students, researchers, and business professionals, Excel is the spreadsheet and data application of choice--and Dummies is the best choice for learning how to make those numbers sing. Learn how to use Excel's built-in data analysis features and write your own functions to explore patterns in your data Create striking charts and visualizations, and discover multiple ways to tell the stories hidden in the numbers Clean up large datasets and identify statistical operations that will answer your questions Perform financial calculations, database operations, and more--without leaving Excel Excel Data Analysis For Dummies is the go-to resource for Excel users who are looking for better ways to crunch the numbers.

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 pro Conquer the world of Fire TV with one easy-to-understand book. Soon you'll be discovering the latest popcorn-worthy shows.

Get practical walkthroughs for the most useful Excel features Looking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? Excel Workbook For Dummies is the hands-on tutorial you've been waiting for. This step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program. Work through the book from start to finish or, if you'd prefer, jump right to the section that's giving you trouble, whether that's data visualization, macros, analysis, or anything else. You can also: Brush up on and practice time-saving keyboard shortcuts for popular commands and actions Get a handle on multi-functional and practical pivot tables with intuitive practice exercises Learn to secure your data with spreadsheet password protections Perfect for new users of Excel, Excel Workbook For Dummies is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features of this powerful program.

Learn the in-demand skills that let you turn lines of code into websites and apps Web Coding & Development All-in-One For Dummies is a one-stop resource for would-be developers who need guidance on the languages and steps used to build websites and applications. Learn the coding ropes and expand your existing skillset with this easy-to-understand guide. In these complete mini-books, you'll walk through the basics of web development, structuring a page, building and processing web forms, and beyond. Learn how to build a website or create your very own app with the advice of web coding and development experts. This edition expands JavaScript and CSS coverage while providing new content on server-side coding and the development stack. Get essential knowledge of how web development works--even if you've never written a line of code in your life Learn HTML, CSS, JavaScript, and other languages essential for building websites and apps Discover how to make optimize your sites and apps for mobile devices Expand on what you already know and improve your employability This Dummies All-in-One is great for you if want to develop coding skills but don't have a programming background. It's also perfect for professionals looking to brush up on their web development skills and get up to date on the latest trends and standards.

Your no-fluff, fast-paced guide to everything Windows 10 This 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 online With concise, easy-to-follow instructions, and its small, portable size, this is the ideal, on-the-go guide for Windows 10 users everywhere.

Your step-by-step guide to iPhone mastery iPhone 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 email With 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.

A thorough and helpful reference for aspiring website builders.

Looking to start an exciting new career in front-end web building and design? Or maybe you just want to develop a new skill and create websites for fun. Whatever your reasons, it’s never been easier to start learning how to build websites from scratch than with help from HTML, CSS, & JavaScript All-in-One For Dummies. This book has the essentials you need to wrap your head around the key ingredients of website design and creation.

You’ll learn to build attractive, useful, and easy-to-navigate websites by combining HTML, CSS, and JavaScript into fun and practical creations. Using the 6 books compiled within this comprehensive collection, you’ll discover how to make static and dynamic websites, complete with intuitive layouts and cool animations.

The book also includes:

• Incorporate the latest approaches to HTML, CSS, and JavaScript, including those involving new markup, page styles, interactivity, and more
• Step-by-step instructions for new site creators explaining the very basics of page layouts and animations
• Easy-to-follow advice for adjusting page color and background, adding widgets to a site, and getting rid of all the bugs that affect site performance

Web development is a fun, interesting, and challenging skill that can lead to a lucrative career (if you’re so inclined). And with the right help, almost anyone can learn to create engaging websites from scratch. So, grab a copy of HTML, CSS, & JavaScript All-in-One For Dummies and you’ll be designing and building before you know it!

Excel-erate your Excel 365 knowledge with the celebrated Teach Yourself VISUALLY series In 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 more A 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.

Everything you need to know about Windows 11 in a single, visual book Teach Yourself VISUALLY Windows 11 collects all the resources you need to master the day-to-day use of Microsoft's new operating system and delivers them in a single resource. Fully illustrated, step-by-step instructions are combined with crystal-clear screenshots to walk you through the basic and advanced functions of Windows 11. Teach Yourself VISUALLY Windows 11 offers the best visual learning techniques with comprehensive source material about the interface and substance of Windows 11, as well as: Stepwise guidance on working with files, digital pictures, and media Instructions for customizing Windows 11 and sharing your computer with family members Tutorials on installing and repairing applications, system maintenance, and computer security The fastest, easiest way for visual learners to get a grip on Windows 11, Teach Yourself VISUALLY Windows 11 is the best way to go from newbie to expert in no time at all.

Learn Windows 11 quickly, easily, and with expert help from a tech education master Windows 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 to With 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.

Master Windows 10 by reading only one book Teach Yourself Visually Windows 10, 3rd Edition brings together all of the necessary resources to make you an expert in the use of the latest version of Windows. Using highly visual techniques to maximize learner retention and memory, Teach Yourself Visually Windows 10 will have you breezing through the most popular operating system in the world in no time. The book includes hundreds of step-by-step and illustrated sets of instructions to teach you both the basics and the complexities of Windows 10 operation. Lessons include: Installing and repairing applications System maintenance Setting up password-protection Downloading photos Managing media files And more Teach Yourself Visually Windows 10 combines the best of visual learning techniques with comprehensive source material about the interface and substance of Windows 10 to leave you with encyclopedic knowledge of the operating system. Perfect for beginners and intermediate users alike, this book will turn your Windows-using experience from a slow slog into a lighting-fast masterclass of efficiency.

Use Excel 365 and Excel 2021 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 recent improvements ranging from dynamic arrays to XLOOKUP and LET. 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 Use modern lookups to make your formulas more powerful and flexible Simplify complex calculations with dynamic arrays in Excel 365 and Excel 2021 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 NPV and IRR Sort, filter, and analyze any tabular data, from customers to inventory Easily analyze huge datasets with PivotTable calculations Perform sophisticated what-if analyses, scenario planning, and forecasting Optimize profit, cost, or operational efficiency with Solver 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

The huge reference guide you need to use the full power of your Mac Macs All-in-One For Dummies truly covers it all. This compete reference guide contains five books in one, so you can learn all your Mac is capable of. You'll get a complete understanding of your computer, so you can use it for pleasure or business, become a multimedia master, surf the web like a pro, troubleshoot problems as they arise, and so much besides. This latest edition is updated for the newest version of macOS, the hottest apps, and the just-released Macs. Running an older Mac? Don't worry, this book won't leave you behind. Everything you need to do on your Mac can be learned with the help of Macs All-in-One For Dummies. Learn your way around your Mac and customize all the macOS features Discover the newest features (and the returning classics) so you can make the most of your machine Beef up your security, stay safe while surfing the web, and figure it out when things go wrong Use your computer to work, play, create videos, keep in touch, and everything else Computer users who are switching to a Mac for the first time, as well as previous Mac users who are upgrading to the newest model, need a guide for getting the most out of their powerful computer. This is that guide.

Enter the Web Design Playground and start experimenting with all aspects of creating a web page--from design, to development, to publishing--in an easy-to-use free online workspace. This exciting second edition of Web Design Playground is fully updated with new technologies and thoughtful approaches for building modern websites. Discover timeless HTML and CSS techniques, and dive into their cool new tags and features, including Flexbox and CSS Grid. Four serious projects put your skills to the test and give you useful, real-world pages for your portfolio. Don't worry about setting up your own servers and domain names--the book comes with a free online "playground" to experiment with and get creative. You can concentrate on core skills like page layout and adding images and video, as well as learning typography, responsive design, and the other modern web design techniques. Before you know it, you'll be ready to create gorgeous pages that reflect your creativity and style. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

Take Excel to the next level Excel is the world's leading spreadsheet application. It's a key module in Microsoft Office--the number-one productivity suite--and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format. Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, you'll discover how to mine and analyze critical data in order to make more informed business decisions. Work with external databases, PivotTables, and Pivot Charts Use Excel for statistical and financial functions and data sharing Get familiar with Solver Use the Small Business Finance Manager If you're familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.

See your way to Excel spreadsheet stardom with this visual guide 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.

Take a guided tour of macOS High Sierra and discover just how much your Mac can do Teach Yourself VISUALLY macOS High Sierra is the perfect introduction to Apple's operating system. With clear, step-by-step instructions and plenty of rich visuals, it walks you through the new macOS High Sierra and demonstrates the essential tasks you need to know. You'll learn how to manipulate Preferences to customize your experience, make the most of your digital media, and streamline your workflow while having a little fun. You'll tour Photos, Messages, and Notifications, and get acquainted with Mission Control, the App Store, and Siri. New Mac users will appreciate the straightforward instruction, while veteran users will enjoy getting up to speed on the latest features introduced or upgraded in macOS High Sierra. macOS High Sierra is the latest incarnation of Apple's macOS, boasting elegant new visuals, several new features, and more seamless integration of Mac and iOS devices. If you use a Mac, you're going to want a guided tour that shows you just what macOS can do for you. Teach Yourself VISUALLY macOS High Sierra is your go-to guide, from the fundamentals to the neat little tricks that make the Mac experience something far beyond computing. - Edit and enhance photos with the powerful new tools on the Photos app - Browse the web safely with Safari's new privacy features - Share files quickly and easily using iCloud Drive - Use Siri to accomplish more in less time Like any computer, your Mac is a tool. And like any tool, the more you know about it, the more you get out of it. Discover the beauty, simplicity, and sheer functionality that millions already enjoy--and get ready to master your Mac with Teach Yourself VISUALLY macOS High Sierra.