FastTrack (Excel + PPT for Consulting)

The FastTrack bundle includes the following to help you accelerate your consulting career:

• 82 total lessons
• 17 total modules
• 30+ hours of total video teaching
• Downloadable resources

After completing these courses, you’ll be well on your way to utilizing Excel and PowerPoint the way consultants do! See below for a detailed breakdown of each course.

Excel for Consulting

Module 1: Intro to Excel

• Lesson 1: How Excel is Used in Consulting
• Lesson 2: Intro to the Course

Module 2: 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)

Module 3: 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

Module 4: Market Sizing Models

• Lesson 19: Market Sizing Model Theory
• Lesson 20: Market Sizing Model (Expert)

Module 5: 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)

Module 6: 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)

Module 7: 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)

Module 8: 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

Module 9: Graphs and Charts in Excel

• Lesson 41: Chart Theory
• Lesson 42: Creating Charts (Expert)

Module 10: Conclusion and Next Steps

• Lesson 43: Macros Intro and Advanced Excel
• Lesson 44: Summary and Conclusion

Additional Resources

• Excel shortcut and formula cheat sheet download

Level 2 Prompts

• Fortune 1000 Analysis
• Fortune 500 Political Affiliations
• Refrigeration Market Sizing
• Refrigeration Pricing Model
• Refrigeration Target Customers
• Refrigeration Valuation Model

There are 10 modules made up of 44 total lessons. 16 of these lessons are expert videos where you see us work on screen. In addition, there are 6 “Level 2” lessons that are real-world prompts. You receive initial data sets to download so you can work along with us, as well as our final data sets to download as well. You also receive an Excel shortcut and formula cheat sheet to download.

PowerPoint for Consulting

You also get to see us build and present a consulting slide deck off of a real case. You receive a certificate of completion at the end!