Excel 2016 All-in-One For Dummies

8 BOOKS IN 1 Excel Basics Worksheet Design Formulas and Functions Worksheet Collaboration and Review Charts and Graphics Data Management Data Analysis Macros and VBA Get up to speed right away with the all-new, all-powerful Excel 2016 Excel, the #1 spreadsheet tool used by millions, has undergone a massive makeover. Each of the self-contained minibooks in this easy-to-follow guide covers one important area of Excel 2016. Find out how to make the most of your worksheets, create eye-popping charts, analyze data like a pro, and even customize Excel with VBA programming! Start here ? if you're new to Excel, Book I covers all the essentials Worksheet 101 ? learn to enter data and build, format, print, and manage worksheets in Book II Getting functional ? Book III shows you how to build formulas to calculate just about anything Let's team up ? see how to share spreadsheets safely with other people and programs in Book IV Charts and graphs ? in Book V, find out how to choose and create the ideal visual representation for your data What to do with it ? discover in Book VI how to maintain, filter, query, and manage volumes of data Analyze everything ? Book VII shows you amazing ways to analyze data and summarize it with pivot tables Macro mania ? learn to automate common tasks with macros and create custom user-defined functions in Book VIII Open the book and find: Tips for using Excel on a touchscreen device How to customize the Ribbon and the Quick Access toolbar Advice on editing spreadsheets Ways to find and eliminate formula errors Secrets of sharing on OneDrive® Steps for querying your data All about Office and Excel Add-ins