Part I The Excel interface

Chapter 1 What's new in Microsoft 365 Excel

Chapter 2 Using the Excel interface

Chapter 3 Customizing Excel

Chapter 4 Keyboard shortcuts

Part II Calculating with Excel

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, and database functions

Chapter 10 Using names, LET, LAMBDA, and Data Types in Excel

Chapter 11 Connecting worksheets and workbooks

Chapter 12 Dynamic array formulas and names in Excel

Part III Data analysis with Excel

Chapter 13 Transforming data with Power Query

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

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 Formatting spreadsheets for presentation

Chapter 27 Printing

Chapter 28 Collaborating in Excel

Part V Appendixes

Appendix A Excel functions

Appendix B Excel functions with DAX or Power Query equivalents

Appendix C Adding functionality to Excel with add-ins

Index