Learn Excel 2016 for OS X

strongGuy Hart-Davis/strong is the author of more than 50 computer books, including emHow to Do Everything with Microsoft Excel 2007/em and emHow to Do Everything with Microsoft Word 2007./em

Part 1: 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 2: Perforating 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 3: Analyzing Data and Sharing and Automating Workbooks Chapter 10: Creating Databases Using Tables Chapter 11: Solving Business Questions with What-It Analysis, Goal Seek, and Solver Chapter 12: Analyzing Data with PivotTables Chapter 13: Collaborating and Sharing with Macs and Windows PCs