Table of Contents
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
