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
Level 2 Prompts
Fortune 500 Political Affiliations
You don’t have access to this lesson
Please register or sign in to access the course content.
Take course
Sign in
Previous
Next
Save your cart?
x