142 Results for 'drill'

Product

2nd Degree Black Belt

80% of Black Belts land at least 1 offer, compared to 3% of applicants industry-wide. This is for those who go the extra mile (or 2) to become the best of the best. If you are aiming to be the #1 recruit in your region and have your pick of offices, you'll have to be better than very good - you'll have to be great. We'll help you get there, with:
  • 20 Hours of 1:1 Interview Prep with an MBB coach
  • 2 Rounds of Edits each on 1 Resume and 1 Cover Letter
  • The Consulting Case Library (600+ cases)
  • Access to peers for additional case practice
  • 9 online video courses
    • The Consulting Case Interview Bootcamp
    • The Consulting Fit Interview Bootcamp
    • Mental Math for Consulting Bootcamp
    • Business Basics for Consulting Bootcamp
    • PowerPoint for Consulting Bootcamp
    • Excel for Consulting Bootcamp
    • Consulting Resume & Cover Letter Bootcamp
    • Networking for Consulting Bootcamp
    • The MC Starter Pack (industry overview)
  • 5 e-books
  • 18 chatbot cases
  • 10,000+ case math, exhibit and structure drills
  • Free session recordings
  • 1 Year Membership to MC Community
  • Email support from dedicated Black Belt concierge
Many of you will only have one shot to break into consulting - take full advantage by becoming a 2nd Degree Black Belt.
View Product
Product

MC All Access Pass

Access to our self-paced consulting prep curriculum. The best part? You get lifetime access to 120+ hours of content and can track your progress through each course:
  • 9 video courses
    • Case Interview Bootcamp - 32 lessons walking you through our revolutionary case solving system
    • Fit Interview Bootcamp - Teaching and examples to help you crush behavioral/fit interviews
    • Mental Math for Consulting Bootcamp - Video lessons to help you be fast and accurate in your case interview math
    • Business Basics for Consulting Bootcamp - A breakdown of the business concepts you need to know for case interviews
    • PowerPoint for Consulting Bootcamp - 38 video lessons on how to drive executive action through PPT
    • Excel for Consulting Bootcamp - 44 video lessons and examples teaching you how to build scenario-based models
    • Networking for Consulting Bootcamp - 38 video lessons guiding you through the networking process (including templates!)
    • Resume and Cover Letter Bootcamp - Our proven method to help your resume & cover letter stand out (including templates!)
    • MC Starter Pack (industry overview) - Your guide to the industry: the main players, types of consulting, life on the job and more
  • MC Case Library (600+ practice cases)
  • 200+ video-based framework/brainstorming/math drills
  • 100+ chart/graph and market sizing drills
  • Unlimited web-based mental math and framework drills
  • 12 Industry Primers
  • 18 Chatbot Cases
View Product
Post

Market Study: Case Interview Frameworks

To continue our series on case interview frameworks, we bring you our personal favorite – and the most versatile – the Market Study case interview framework. This is the third article in our series on Frameworks! In the first article of the series, we gave you a brief introduction to frameworks before exploring Market Sizing…
View Post
Product

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

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. You receive a certificate of completion at the end!
View Product
Product

Excel for Consulting

Intro to Excel
  • Lesson 1: How Excel is Used in Consulting
  • Lesson 2: Intro to the Course
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)
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
Market Sizing Models
  • Lesson 19: Market Sizing Model Theory
  • Lesson 20: Market Sizing Model (Expert)
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)
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)
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)
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
Graphs and Charts in Excel
  • Lesson 41: Chart Theory
  • Lesson 42: Creating Charts (Expert)
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. 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. In addition, there are 6 “Level 2” lessons that are real-world prompts. You receive a certificate of completion at the end! ------------------------------------------------------------------------------------------------------------------------------------------------------------------- There's a level of freedom reserved only for top performers. A level where Partners want you on their projects, instead of being stuck with you. It's time for you to take that leap into the world of consulting top performers. From Day 1 as a consultant, you'll be up to your eyeballs in Excel. Excel will either become your best friend and make your life 1,000% easier, or it will become your worst enemy. I was not prepared for this. I was prepared for flying first class, meeting clients, and eating nice dinners. If Excel was part of the equation, well, I was familiar with it, so I'd be fine. I couldn't have been more wrong. Here's what using Excel is not about: getting lost in a haystack of data. Here's what it is about: using your analytical skills to break down data, see trends, come up with solutions, and most important: drive toward key insights for the client. To make it really clear: learning how to use Excel like a consultant will ensure you are the whole package and in the top performer category. The earlier you can show you are an all-star caliber performer, the greater likelihood you have of putting yourself on the fast track to success. First impressions matter. I got there eventually, but had to make up for lost time and work twice as hard to get there. This is why we've revamped Excel for Consulting. We've taken the original course and improved every facet of it:
  • You don't just learn how to build certain models, but the business rationale that underpins them
  • Hear more real-life anecdotes to help you apply the learnings to your world
  • Special format and shortcut drills to help you speed up your navigation
Get started today on your journey to being a top performer.
View Product
Product

Mental Math for Consulting

Our updated mental math course, Mental Math for Consulting, is just what you need if you're getting ready to face the toughest case interview of your life. Chock full of advanced math tips, tricks, strategies, and practice problems, with videos showing how we lay our math out on paper. Lessons:
  • Lesson 1: Having the Right Expectations for Consulting
  • Lesson 2: Left to Right Addition for Consulting
  • Lesson 3: Subtraction for AdditionLesson 4: Right to Left Addition
  • Lesson 5: Jenny Rae’s Chunk It Out Method
  • Lesson 6: Left to Right Subtraction
  • Lesson 7: Addition for Subtraction
  • Lesson 8: Left To Right Multiplication
  • Lesson 9: Subtraction for Multiplication
  • Lesson 10: Factoring for Multiplication
  • Lesson 11: Criss Cross Multiplication
  • Lesson 12: Left to Right Division
  • Lesson 13: Breakup Division Method
  • Lesson 14: Common Factors for Division
  • Lesson 15: First Multiply Division
  • Lesson 16: Common Factor Tips
  • Lesson 17: Building Blocks for Percentages
  • Lesson 18: Multiplication for Percentages
  • Lesson 19: Rule of 72, 70 & 69.3
  • Lesson 20: Growth Rates
  • Lesson 21: Market Growth
  • Lesson 22: Squaring Two or Three Digits
  • Lesson 23: Weighted Averages
  • Lesson 24: Return on Investment (ROI)
  • Lesson 25: Breakeven
  • Lesson 26: Payback Period
  • Lesson 27: Putting It All Together
  • Lesson 28: Profit (Addition & Subtraction)
  • Lesson 29: Margins (Percentages)
  • Lesson 30: Market (Multiply, Interest & Percentages)
  • Lesson 31: M&A (DCF & NPV)
  • Lesson 32: Conclusion
Additional Mental Math Expert Videos
  • Automotive Costs – Addition for Consulting
  • Jimmy’s Used Car Lot – Subtraction for Consulting
  • Tokyo Airport Terminal – Multiplication for Consulting
  • Big Boats – Division for Consulting
  • Beauty Accessory Manufacturer – Percentages for Consulting
  • Building Liquidation – Interest for Consulting
  • Amazon Teeth Whitening Seller – Squaring for Consulting
  • Beachfront Hotel – Key Equations for Consulting
  • Materials Manufacturer – Profit for Consulting
Overall, you get:
  • 9 Modules
  • 32 Video Lessons
  • 9 Expert Videos - see us do the math on paper!
  • 6 Hours of video
  • 100's of practice problems
  • 30 Quizzes
  • 1 Final Test
  • 10K+ video and web-based math drills, including exhibit drills
  • Get your math skills up to speed with tricks used by top consultants
  • Learn how to answer any questions that you could face in an interview
  • Never worry about calculating tips at restaurants again!
View Product
Post

Breaking into McKinsey: PhD

If you are an Advanced Degree candidate in one of 7 categories, you should apply at McKinsey for a full-time position: PhDs Postdocs Non-MBA Master's Medical students Interns Residents Fellows For most aspiring consultants, McKinsey is the gold standard. The mecca. The ultimate prize. Okay, okay, we know you get it. But the problem with…
View Post
Post

Job Hub: Chick-Fil-A Jobs and Culture

Today we highlight tremendous business analyst and post-consulting leadership jobs at Chick-Fil-A. Chick-Fil-A is the Georgia-based privately held and family owned company credited with pioneering the establishment of restaurants in shopping malls. Since its inception, this company - with over 1,850 locations in 41 states and Washington, D.C. - has grown to be the largest quick-service chicken…
View Post
Post

Market Sizing Questions – Breaking Down Case Interview Frameworks

Welcome back to our case interview frameworks series, giving you a step-by-step approach to solve any case that’s set before you. If you haven’t read our first article yet, we encourage you to go back and read it before continuing. Think of this as your Market Sizing Cheat Sheet, as well as your guide for…
View Post
Post

Alvarez and Marsal

Alvarez and Marsal originally made waves for the high profile, high quality work it did in the midst of the banking crisis. We're sure most of you heard about Lehman Brothers filing for the biggest bankruptcy in U.S. history. But can you guess which firm was hired as their bankruptcy consultants? Or who was appointed…
View Post
Post

Job Hub: Tesla Motors Jobs and Culture

Today we highlight tremendous business analyst and post-consulting leadership jobs at Tesla Motors. Tesla Motors is an American company that has made waves in the car industry, so much so that General Motors then-Vice Chairman Robert Lutz said in 2007 that this company's car inspired him to push GM to develop the Chevrolet Volt.  In an August 2009 edition…
View Post
Post

Job Hub: Virgin Group Jobs and Culture

Today we highlight tremendous business analyst and post-consulting leadership jobs at Virgin Group. Virgin Group, a leading international group, is one of the most recognized and respected brands in the world. This group has a startling 300 companies in its portfolio in sectors ranging from travel, telecommunications, health, financial services, leisure, music, space travel, and renewable energy.…
View Post