Sale!

Excel and PowerPoint for Consulting

$490.00 $395.00

Two of our most popular courses combined in one package! Geared toward future and current consultants, these courses will take you through the way consultants use Excel and PowerPoint, and pinpoint key models and slides you must know how to build. Downloadable cheat sheets included!

Description

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

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

and more, 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:

  • Navigating around Excel
  • Formatting in Excel
  • Using formulas (including VLOOKUPS)
  • Data cleaning
  • Model types and theory
  • Market Sizing, Profitability, Revenue, Total Fixed Cost Allocation, Cost, Market Study, Competitor, Customer, Market Entry, and M&A models (teaching videos and expert videos where you see us building them on screen)
  • DCF
  • Data Analysis
  • Conditional Math
  • Reference functions
  • Pivot Tables
  • Regressions and Advanced Analysis
  • Creating Charts
  • Intro to Macros
  • 6 Level 2 models (2 Internal and one mega-model)
  • Real world prompts you’d receive on the job, that YOU have to solve and defend
  • 15 hours of assignments for you to put the skills you’ve learned to good use

There are 9 modules made up of 38 total lessons. 16 lessons are teaching lessons and 16 are expert videos where you see us work on screen. The other 6 lessons are the 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:

  • Consulting PowerPoint Theory
  • Elements of Consulting Slides
  • Navigation, shortcuts, and formatting
  • Drawing Consulting Insights in Presentations
  • Consulting Visuals
  • Story Planning
  • Workstreams
  • Data Slides
  • Slide Deck best practices
  • A breakdown of different firm presentation styles (McKinsey, Bain, BCG, Deloitte, etc.)
  • How to deliver a slide deck

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

Reviews

There are no reviews yet.

Be the first to review “Excel and PowerPoint for Consulting”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.