Part 1: Explaining Excel fundamentals. Getting started with spreadsheets ; Carrying out basic calculations ; Formatting cells and worksheets ; Sifting through data ; Tackling tables
Part 2: Mastering formulas and functions. Leveraging lookup formulas ; Transforming text and numbers ; Harnessing logic functions ; Carving data with dynamic arrays ; Tracing and debugging formulas
Part 3: Expanding beyond the basics. Navigating through worksheets and workbooks ; Visualizing and summarizing data ; Contemplating conditional formatting ; User-proofing Excel spreadsheets
Part 4: Automating analysis. Accessing artificial intelligence ; Recording macros
Part 5: The part of tens. Ten timesaving keyboard shortcuts ; Ten disaster recovery techniques.
