1 What’s New in Excel 2016 (and 2013)
8 Using Everyday Functions: Math, Date and Time, and Text Functions
9 Using Powerful Functions: Logical, Lookup, Web, and Database Functions
11 Connecting Worksheets and Workbooks
12 Array Formulas and Names in Excel
14 Summarizing Data Using Subtotals or Filter
15 Using Pivot Tables to Analyze Data
16 Using Slicers and Filtering a Pivot Table
17 Mashing Up Data with Power Pivot
18 Using What-If, Scenario Manager, Goal Seek, and Solver
19 Automating Repetitive Functions Using VBA Macros
20 More Tips and Tricks for Excel 2016
22 Using Data Visualizations and Conditional Formatting