Learn Excel 2016 for OS X

Microsoft Excel 2016 for Mac OS X is a powerful application, but many of its most impressive features can be difficult to find. Learn Excel 2016 for OS X by Guy Hart-Davis is a practical, hands-on approach to learning all of the details of Excel 2016 in order to get work done efficiently on OS X. From using formulas and functions to creating databases, from analyzing data to automating tasks, you’ll learn everything you need to know to put this powerful application to use for a variety of tasks.

Table of Contents

Part I: Becoming Proficient with Excel for Mac
Chapter 1: Learning the Secrets of the Excel for Mac Interface
Chapter 2: Configuring Excel to Suit the Way You Work
Chapter 3: Creating Effective Workbooks and Templates
Chapter 4: Formatting Your Worksheets Quickly and Efficiently

Part II: Performing Calculations and Presenting Data
Chapter 5: Performing Custom Calculations with Formulas
Chapter 6: Using Excel’s Built-In Functions
Chapter 7: Creating Clear and Persuasive Charts
Chapter 8: Using Data Bars, Color Scales, Icon Sets, and Sparklines
Chapter 9: Illustrating Your Worksheets with Pictures, SmartArt, and More

Part III: Analyzing Data and Sharing and Automating Workbooks
Chapter 10: Creating Databases Using Tables
Chapter 11: Solving Business Questions with What-If Analysis, Goal Seek, and Solver
Chapter 12: Analyzing Data with PivotTables
Chapter 13: Collaborating and Sharing with Macs and Windows PCs