- Chapter 1 What’s New in Excel 2016 (and 2013)
-
Chapter 2 Using the Excel Interface
-
Chapter 3 Customizing Excel
-
Chapter 4 Keyboard Shortcuts
-
Chapter 5 Understanding Formulas
-
Chapter 6 Controlling Formulas
-
Chapter 7 Understanding Functions
-
Chapter 8 Using Everyday Functions: Math, Date and Time, and Text Functions
-
Chapter 9 Using Powerful Functions: Logical, Lookup, Web, and Database Functions
-
Chapter 10 Other Functions
-
Chapter 11 Connecting Worksheets and Workbooks
-
Chapter 12 Array Formulas and Names in Excel
-
Chapter 13 Transforming Data
-
Chapter 14 Summarizing Data Using Subtotals or Filter
-
Chapter 15 Using Pivot Tables to Analyze Data
-
Chapter 16 Using Slicers and Filtering a Pivot Table
-
Chapter 17 Mashing Up Data with PowerPivot
-
Chapter 18 Using What-If, Scenario Manager, Goal Seek, and Solver
-
Chapter 19 Automating Repetitive Functions Using VBA Macros
-
Chapter 20 More Tips and Tricks for Excel 2016
-
Part IV Excel Visuals
-
Chapter 21 Formatting Worksheets
-
Chapter 22 Using Data Visualizations and Conditional Formatting
-
Chapter 23 Graphing Data Using Excel Charts
-
Chapter 24 Using 3D Maps
-
Chapter 25 Using Sparklines
-
Chapter 26 Decorating Spreadsheets
-
Chapter 27 Printing
-
Chapter 28 Excel Online
