Excel For Consulting Bootcamp
Master the Excel skills used by consultants. This bootcamp combines video lessons on core concepts with shortcut and formatting drills, plus demo videos to help you work faster and more efficiently in Excel.
Assessment
How Excel is Used in Consulting
AI Expectations for Excel
Intro to the Course
Quiz: How Excel is Used in Consulting
Navigating around Excel
Moving in Excel (Shortcut Drills)
Selecting in Excel (Shortcut Drills)
Copy/Pasting in Excel (Shortcut Drills)
Formatting in Excel
Overall Set-Up (Format Drills)
Filters (Format Drills)
Top Shortcuts (Format Drills)
Cell Menu (Format Drills)
Quiz: Excel Shortcuts
Using Formulas for Excel
Anchoring (Format Drills)
Data Cleaning in Excel
Entering Data in Excel (Expert)
Model Types and Model Theory
Quiz: Excel Foundation and Formulas
Market Sizing Model Theory
Market Sizing Model (Expert)
Quiz: Market Sizing
Profitability Model Theory
Creating a Revenue Model (Expert)
Total Fixed Cost Allocation
Creating a Cost Model (Expert)
Creating a Profit Model (Expert)
Quiz: Profitability