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