If your aim is to tinker with some of Excel's not-so-common features, then this book is ideal for you and you won't be disappointed. It follows a step-by-step, handheld approach to coach you into using the software; at the end of your study and practice, you should feel confident in handling the software with some expertise. ... the book follows an easy-to-comprehend style. It is written from the perspective of a learner ... . (Amit Rudra, Computing Reviews, computingreviews.com, June, 2016)
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 DataChapter 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 WorkbooksChapter 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