Part I: The Excel interface. 1. What's new in Microsoft 365 Excel ; 2. Using the Excel interface ; 3. Customizing Excel ; 4. Keyboard shortcuts
Part II: Calculating with Excel. 5. Understanding formulas ; 6. Controlling formulas ; 7. Understanding functions ; 8. Using everyday functions: math, date and time, and text functions ; 9. Using powerful functions: logical, lookup, and database functions ; 10. Using names, LET, LAMBDA, and data types in Excel ; 11. Connecting worksheets and workbooks ; 12. Dynamic array formulast and names in Excel
Part III: Data analysis with Excel. 13. Transforming data with Power Query ; 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
Part IV: Excel visuals. 21. Formatting worksheets ; 22. Using data visualizations and conditional formatting ; 23. Graphing data using Excel charts ; 24. Using 3D Maps ; 25. Using sparklines ; 26. Formatting spreadsheets for presentation ; 27. Printing ; 28. Collaborating in Excel
Part V: Appendixes. Excel functions ; Excel functions with DAX or Power Query equivalents ; Adding functionality to Excel with add-ins.
