Participant Resources
Your step-by-step guides, cheat sheets, and tutorials for concepts covered through Days 1 to 5.
Exhaustive shortcuts for navigation, selection, data formatting, and Windows Alt accelerator keys.
Syntax guides and examples for Text operations, VLOOKUP/XLOOKUP, and logical COUNTIFS/SUMIFS.
Detailed tutorials on using Goal Seek, 1-Variable/2-Variable Data Tables, and Solver Add-in optimization.
Detailed guide on summarizing datasets, using Slicers for interactive reports, and creating dynamic charts.
Learn VBA editor workflow and how to write prompts to get ChatGPT to write Excel macros for you.