The McKinsey Way Of Excel Hacking and Dynamic Charting
3.3 (483 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
35,213 students enrolled

The McKinsey Way Of Excel Hacking and Dynamic Charting

Former Top Strategy Consultant Reveals How To Master the #1 Skill Every Employer Wants Almost Overnight
3.3 (483 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
35,213 students enrolled
Last updated 7/2013
English [Auto]
Current price: $129.99 Original price: $199.99 Discount: 35% off
13 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 36 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • The McKinsey way of Excel hacking and dynamic charting: from beginner to advanced in less than 7 days
  • Discover insider tips & tricks from McKinsey consultants that other people will never know about...
  • Relieve the pain Excel is causing in your stomach: I’ll show you how to become a more confident and skilful Excel user
  • Why mastering Excel is not a matter of talent, but nothing more than a skill you can learn: manage and manipulate data without the need for complex mathematical knowledge
  • Stop Excel controlling you: how to take Excel by the horns and make it do whatever you want, whenever you want
  • Excel concepts, techniques, functions and data analysis techniques that you can deploy in real-life spreadsheet situations instantly
  • No theory, but 100% job-focused knowledge of Excel, coupled with lots of practical examples and shortcuts
  • Acquire 5 Excel skills only McKinsey consultants know (imagine for a moment you could deliver the work your boss would have to pay thousands of dollars for…)
  • Shortcut strategies that are uncommon in the everyday workplace, yet incredibly useful and powerful
  • Stand out from the crowd: produce professional work like a McKinsey consultant Excel strategies you won’t find in any book
  • Become comfortable with day-to-day operations and dominate common Excel hurdles instantly
  • Become dramatically more productive, avoid serious mistakes and simplify your daily workflow by learning simple shortcut strategies to tackle virtually every Excel problem
  • … and much more
  • Excel 2003, 2007, 2010, 2011, 2013, 2015 or 2016
  • Capability to follow the step-by-step instructions of this training

What if I told you that you can master Excel, the #1 career skill every employer wants, in less than 7 days?

Here’s why you can only win by mastering Excel:

FACT: The prestigious Wall Street Journal reports that high proficiency in software like Microsoft Excel is increasingly helpful in landing people new jobs:

  • 6.3 million open job positions in the U.S. require Microsoft Excel
  • 80% of middle-skilled jobs require Excel proficiency
  • Positions that require basic digital skills tend to pay up to 38% higher wages than jobs that require no digital proficiency

If you struggle with Excel, know that you're not alone. Even though Excel is designed to make your life easier, 82% of users report that Excel causes them additional stress.

This course is for you if you’ve:

  • Struggled to find online tutorials that make using Excel easy
  • Made mistakes in Excel and felt disappointed with the results
  • Wasted countless hours on Excel problems that could have been solved easily

Take The Best Seats In The House & Discover How To Succeed At The Modern Workplace With Excel:

  • Dominate Excel: from beginner to advanced in less than 7 days… right from the comfort of your own desk!
  • Deploy Excel insider strategies: discover little known strategies from a former top strategy consultant who was called the “Picasso of Excel”
  • Advance your career: become the indispensable Excel point of reference in your company and boost your pay by up to 38%
  • Impress your boss or colleagues: handle advanced Excel tasks no one can handle, and get the recognition, attention & respect you deserve
  • Gain a competitive advantage: acquire a new skill, become eminently more hireable and land a new better job instantly!

Content & Overview

First, we’ll cover the foundations of Excel, which includes an overview of navigation, formatting, tables, pivot tables, and charting. I’ll explain how I’ll turn you into an Excel hacker, why you can master every Excel version available, and how Excel will help you to become more efficient at your job.

In section 2, I’ll show you how to handle worksheets, which is the key element to building massive spreadsheets effectively. We’ll also cover shortcuts and auto-fill tricks that will make your co-workers jealous.

Next, we’ll dive deep into formulas. I’ll show you how to calculate anything with Excel. I’ll walk you through conditional formulas, date and time formula, VLOOKUP and HLOOKUP, count formulas and text formulas. It’s time to stop the pain and get data in the format you need!

In section 4 of this class, you’ll discover how to format cells and data like a McKinsey consultant. I’ll explain 8 Excel cell formats, providing practical examples and how to effectively navigate large data sheets.

Then, we’ll cover tips and tricks to effectively work with tables and how to supercharge your data with pivot tables.

Last but not least, I’ll explain different charting strategies, best practices and examples to deliver professional work every single time you work with Excel.

By the time you complete this class, you’ll completely dominate Excel and master one of the most useful skills that every employer wants to see on a resume.

In fact, I am making my 14 years’ of experience, plus everything I learned about Excel at Roland Berger (the #1 German Strategy Consultancy), and from my McKinsey mentor, available to YOU!

Upon successful completion of the course, you’ll also receive an internationally recognized certificate in Excel that will earn you both status and recognition as an advanced Excel user!

Join the tribe of Excel hackers today!

Who this course is for:
  • Beginner & intermediate Excel users
  • Skilled office workers who want to advance their career
Course content
Expand all 33 lectures 03:14:49
+ Intro To Excel Hacking - Become An Excel Hacker
3 lectures 09:26

Welcome to this training, I really appreciate your presence! In this training, you’ll learn 100% job-focused Excel secrets to master Excel like top consultants! In particular, we’ll cover navigation, formulas, formatting, pivot tables, and charting!

Preview 05:27

In this lesson, I’ll provide insights to an Excel model with pivot tables and VBA that saved Volkswagen $1 Billion a year. Let’s go!

Preview 02:15

Microsoft is re-released every other year a new Excel version, but this is nothing you should care about. Let me explain why you should stay cool when the next version is launched.

Excel 2007, 2010, 2011, 2013, 2015 or 2016 - Why You’ll Master Any Excel Version
+ Navigation Secrets - Learn How To Become A Worksheet Wiz
2 lectures 13:15

In this lesson, you’ll discover how to handle worksheets, including the quick access toolbar, important settings, and the name manager.

Worksheet Handling - The Key Element To Build Massive Excel Spreadsheets

Did you know that Excel can automatically format row widths and fill in formulas for you? Here’s how to do it!

Shortcuts and Auto-Fill Tricks - The Origin Of Speed
+ Formulas - Learn The Key Formulas Used By Top Consultants
7 lectures 01:00:37

Excel provides a wide range of math formulas. Let me show you the essential formulas used by top consultants: + - / *, SUM, AVERAGE, ROUND, SUMPRODUCT, MIN, MAX & RANK.

How To Calculate Anything With Excel Formulas

Do you know what conditional formulas are? That’s what you’ll discover in this lesson.

Conditional Formulas - Learn To Use IF-Formulas To Make Conditional Calculations

In this lesson, you’ll learn a smart McKinsey’s way to track due dates in project management.

Date And Time Formulas - Track Due Dates And Rock Project Management

Did you ever search for information in a huge table and didn’t find immediately what you were looking for? Learn how to use LOOKUP formulas to make your life easier.

VLOOKUP And HLOOKUP - Get The Data You Need From Massive Tables Automatically

Sometimes you need to count items. There are two simple formulas to make counting super straightforward.

Count Formulas - How To Count Anything In Excel

Tired of never getting data in the format you need it? In this lecture, you will learn how to separate full names to first and last name among dozens of other secrets. We split full names to first and last name with LEFT / RIGHT / TRIM / LEN / FIND / MID / CONCATENATE.

Text Formulas - Learn To Format Data In The Format You Need

Did you ever get stuck with a circular reference; had no clue what to do and where it comes from? In this lecture, you will learn how to find and solve the errors with trace dependents for circular references and ISERROR for Div 0 and #Value.

Troubleshooting Helps - How To Solve Errors Easily
+ Formatting - McKinsey Cell And Data Formatting Secrets
5 lectures 23:43

Learn how to work with freeze panes and split windows. I have included a best practice tutorial on how to freeze panes and split windows vertically and horizontally.

Freeze Panes Vs. Split Windows - Never Lose Overview On Your Data

Are you ready for McKinsey Cell and Data Formatting Secrets? In this lesson, you’ll learn 8 Excel cell formats explained with practical examples to make your data easily understandable.

Cell Formatting Secrets

Are you ready to learn conditional formatting secrets? Here’s how to do it including data bars, color scales, icon sets (directional, shapes, indicators, ratings), and a tutorial to create custom rules by using the conditional formatting rules manager.

Conditional Formatting Secrets

I’d like to show you my best practice tutorial on hiding, unhiding and grouping data.

Hiding, Unhiding, Grouping - How To Only Show Key Data

In this lecture, I want to share my best practice tutorial on how to work with data validations, a.k.a. drop down menus.

Drop Down Menus - Let Others Only Fill In Data You Want
+ Tables - Secrets To Work With Tables Effectively
3 lectures 08:02

In this lesson, you’ll discover how to make a table out of our data. Let’s go!

Create Tables - Use These Simple Steps To Supercharge Your Data

Learn the most effective way to sort and filter your data to only see what is relevant for your work.

Sorting & Filtering Secrets Revealed

Learn about table formulas and how to use them to work faster than everybody else.

Table Formulas - Use This Trick To Automatically Apply A Formula
+ Pivot - Top Consultant Secrets To Work With Pivot Tables And Charts
2 lectures 13:53

In this lesson, you’ll discover how to work with pivot tables in the most efficient way. Let’s go!

Pivot Tables - Use These Simple Steps To Supercharge Your Data With Pivot Tables

Learn the most effective way to work with pivot charts in the same way top consultants do.

Pivot Charts - Learn To Automatically Visualize Your Data
+ Charting - McKinsey Chart Formatting Secrets
5 lectures 33:30

In this lesson, you’ll discover McKinsey’s most used chart types and learn how to build them.

Chart Types

EXPOSED: Are you ready to dramatically improve Excels standard charts? Here’s how to do it in a comprehensive step-by-step guide with files to build a dynamic chart the McKinsey way: including the use of secondary axis and invisible point label diagrams.

Chart Formatting And Design Essentials

EXPOSED: I’d like to show you McKinsey Chart Formatting Secrets that will help you to build amazing charts that almost no one else can replicate by combining stacked column chart with normal column charts to enable McKinsey data labeling techniques.

McKinsey Chart Formatting Secrets

Did you ever wonder how to put an Excel chart into PowerPoint so that it looks good and is still linked to Excel? Here is how top consultants do it!

Pasting Charts in PowerPoint - The Real Way To Do It!

Have you ever heard about the Excel Camera? Probably not. It’s a hidden feature that allows you to visualize charts that will literally impress everybody else.

Excel Camera - The Deeply Hidden Super Power Feature Nobody Knows About!
+ Best Practices And Examples
4 lectures 24:37

Did you ever take 12 attempts printing weird looking pages that make no sense to actually just get a simple sheet printed out? In this section, you will learn how to really print your tables. Let’s go!

Preview 03:06

Would you like to buy a home and don’t want to make a wrong decision? Learn how Excel can help you to make the right investment decision by mastering discounted cash flow calculations (DCF) and working with CAGR.

Loan And Investment Calculations - How To Make Smart Investment Decisions

Building a business without a proper P&L? Hell no! Check this lecture to learn building a profit loss statement in Excel.

Building A Profit & Loss Statement (P&L)

Templates save you time and help you to find the right structure for your data. In this lecture, you will learn how and where to get the right Excel templates.

Getting Templates (Invoice Templates, Expense forms)
+ Conclusion And Outlook - I Am Here To Help And Make You Successful
2 lectures 07:46

Congratulations, you made it until the end of this training! Now it’s important that you don’t sit on what you just learned. Take action today!


In this course, I want to make sure that I help you in 100% with your Excel issues. If something was not covered, please let me know and I will add it to the course. Also, if you have any specific issues with an Excel file you are currently working on, feel free to share your problem in the discussion section.

Preview 00:54