Chapter 1
What’s New in Excel 2019
Chapter 2
Using the Excel Interface
Chapter 5
Understanding Formulas
Chapter 7
Understanding Functions
Chapter 8
Using Everyday Functions: Math, Date and Time, and Text Functions
Chapter 9
Using Powerful Functions: Logical, Lookup, and Database Functions
Chapter 11
Connecting Worksheets and Workbooks
Chapter 12
Array Formulas and Names in Excel
Part III
Data Analysis with Excel
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 Power Pivot
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 2019
Chapter 21
Formatting Worksheets
Chapter 22
Using Data Visualizations and Conditional Formatting
Chapter 23
Graphing Data Using Excel Charts
Chapter 26
Formatting Spreadsheets for Presentation
Chapter 28
Sharing Dashboards with Power BI