Excel for Consulting
0 of 51 lessons complete (0%)
Exit Course
Intro to Excel
Lesson 1: How Excel is Used in Consulting
Lesson 2: Intro to the Course
2 lessons
Intro to Excel Shortcuts
Lesson 3: Navigating around Excel
Lesson 4: Navigating around Excel (Expert)
Lesson 5: Moving in Excel (Shortcut Drills)
Lesson 6: Selecting in Excel (Shortcut Drills)
Lesson 7: Copy/Pasting in Excel (Shortcut Drills)
Lesson 8: Formatting in Excel
Lesson 9: Formatting in Excel (Expert)
Lesson 10: Overall Set-Up (Format Drills)
Lesson 11: Filters (Format Drills)
Lesson 12: Top Shortcuts (Format Drills)
Lesson 13: Cell Menu (Format Drills)
11 lessons
Excel Foundation and Formulas
Lesson 14: Using Formulas for Excel
Lesson 15: Anchoring (Format Drills)
Lesson 16: Data Cleaning in Excel
Lesson 17: Entering Data in Excel (Expert)
Lesson 18: Model Types and Model Theory
5 lessons
Market Sizing Models
Lesson 19: Market Sizing Model Theory
Lesson 20: Market Sizing Model (Expert)
2 lessons
Profitability Models
Lesson 21: Profitability Model Theory
Lesson 22: Creating a Revenue Model (Expert)
Lesson 23: Total Fixed Cost Allocation
Lesson 24: Creating a Cost Model (Expert)
Lesson 25: Creating a Profit Model (Expert)
5 lessons
Market Study Models
Lesson 26: Market Study Model Theory
Lesson 27: Customer Model (Expert)
Lesson 28: Competitor Model (Expert)
Lesson 29: Market Entry Model (Expert)
4 lessons
M&A Models
Lesson 30: M&A Model Theory
Lesson 31: DCF Model Theory
Lesson 32: Building a Simple DCF
Lesson 33: Creating an M&A Model – DCF (Expert)
4 lessons
Data Analysis
Lesson 34: Data Analysis Overview
Lesson 35: Math and Conditional Math (Expert)
Lesson 36: Data Analysis via Data Discovery
Lesson 37: Data Discovery (Expert)
Lesson 38: Reference Functions (Expert)
Lesson 39: Pivot Tables (Expert)
Lesson 40: Regressions and Advanced Analysis
7 lessons
Graphs and Charts in Excel
Lesson 41: Chart Theory
Lesson 42: Creating Charts (Expert)
2 lessons
Conclusion and Next Steps
Lesson 43: Macros Intro and Advanced Excel
Lesson 44: Summary and Conclusion
2 lessons
Additional Resources
Additional Resources
1 lesson
Level 2 Prompts
Fortune 1000 Analysis
Fortune 500 Political Affiliations
Refrigeration Market Sizing
Refrigeration Pricing Model
Refrigeration Target Customers
Refrigeration Valuation Model
6 lessons
Conclusion and Next Steps
Lesson 43: Macros Intro and Advanced Excel
You don’t have access to this lesson
Please register or sign in to access the course content.
Take course
Sign in
Previous
Next