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