Excel + PPT for Consulting

$500.00

Most good things in life come in pairs, right? Our Excel and PowerPoint for Consulting courses are no different.

Courses Include:

  • 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

Module 1: How PowerPoint is Used in Consulting
  • How PowerPoint is Used in Consulting
  • Foundations of Powerful PowerPoint
  • PowerPoint for Consulting 101
Module 2: Structure – The Foundation of a Successful Deck
  • PowerPoint Structure
  • Story Planning
  • Workstreams from a Manager’s Perspective
  • Slide Deck Best Practices
  • Pyramid Principle Background
  • Pyramid Principle…Principles
  • Pyramid Principle Application
  • MECE
Module 3: PowerPoint Format – Making a Great Looking Deck
  • PowerPoint Format
  • Elements of Consulting Slides
  • Navigating around PowerPoint
Module 4: Data Visualization
  • Consulting Insights
  • 3 Types of Consulting Visuals
  • Data Slide Deep Dive
  • Emphasis for Storytelling
  • Finalizing Client-Ready Decks
Module 5: Developing Presentation Mastery
  • Presenting to Executives
  • Solo vs Group Presentations
  • 3 Tips for Advanced Presentation Technique
  • 6 Tips for Presentation Success
Module 6: Firm Specific Presentation Styles
  • 6 Differences in Firm Presentation Styles
  • McKinsey Style Presentations
  • BCG Style Presentations
  • Bain Style Presentations
  • Deloitte Style Presentations
  • Assimilating to Firm Style
  • Developing Presentation Mastery
Module 7: Solving the Written Case Interview
  • Written Case Overview
  • Expert Video 1 – Electric Bus Co. Case Overview
  • Expert Video 2 – Creating Structure for the Presentation
  • Expert Video 3 – Tackling the Data Analysis
  • Expert Video 4 – Developing the Story
  • Presenting a Written Case
  • Expert Video 5 – Practicing and Modifying the Presentation (Bain-style)
  • Expert Video 6 – Presenting the Electric Bus Co. Deck
Module 8: Additional Resources for PowerPoint

  • The Electric Bus Company Presentation
  • PowerPoint for Consulting shortcuts (PC & Mac)

You also get to see us build and present a consulting slide deck off of a real case.

SKU: EXCEL+PPT Category:

Description

Use Excel (scenario analysis) and PowerPoint (executive/persuasive presentation) the way consultants do. 2 of our most popular courses in 1 low-price bundle.