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
4.2 (78 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
13,408 students enrolled
$200
Take This Course
  • Lectures 33
  • Contents Video: 3.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2013 English

Course Description

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!

What are the requirements?

  • Excel 2003, 2007, 2010, 2011, 2013, 2015 or 2016
  • Capability to follow the step-by-step instructions of this training

What am I going to get from this course?

  • 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

What is the target audience?

  • Beginner & intermediate Excel users
  • Skilled office workers who want to advance their career

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Intro To Excel Hacking - Become An Excel Hacker
05:27

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!

02:15

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!

01:44

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.

Section 2: Navigation Secrets - Learn How To Become A Worksheet Wiz
10:55

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

02:20

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

Section 3: Formulas - Learn The Key Formulas Used By Top Consultants
11:26

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.

14:10

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

05:28

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

07:24

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.

02:29

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

13:01

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.

06:39

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.

Section 4: Formatting - McKinsey Cell And Data Formatting Secrets
03:01

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.

04:52

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.

05:50

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.

04:35

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

05:25

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

Section 5: Tables - Secrets To Work With Tables Effectively
02:27

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

02:41

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

02:54

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

Section 6: Pivot - Top Consultant Secrets To Work With Pivot Tables And Charts
09:19

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

04:34

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

Section 7: Charting - McKinsey Chart Formatting Secrets
03:06

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

16:03

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.

06:50

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.

03:41

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!

03:50

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.

Section 8: Best Practices And Examples
03:06

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!

08:21

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.

05:30

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

07:40

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.

Section 9: Conclusion And Outlook - I Am Here To Help And Make You Successful
06:52

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!

00:54

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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Matthias Bellmann, Start-up generalist and former consultant

Hi, I’m Matthias!

I am an entrepreneur, former top strategy consultant, Excel nerd, and web developer.

Let me tell you my story:

After graduating from university in Germany and Sweden, I worked for Roland Berger Strategy Consultants, a leading German Strategy Consultancy. Following my experience with Roland Berger, I worked for Volkswagen Consulting, where I was mentored by a McKinsey partner and delivered Excel trainings to hundreds of employees company-wide, ultimately becoming known as “Mr. Excel.”

Over the last eight years, I have gained valuable experience in founding and scaling Internet businesses in Europe. Today, I consult startups and corporations to help them achieve operational excellence through the use of effective, data-driven, and comprehensible communications – starting with simple and easy to access tools such as Excel.

My Excel specialties include the creation of comprehensible reports and presentations, all built the McKinsey way. Having founded three Internet companies in the last few years, I have raised several million in funds from investors with my Excel models.

Another passion of mine is Coding. When I first started to learn about web development, I built ten websites over the course of a few weeks. I discovered that most people could realize their ideas and dreams easily if they would be just a little bit more confident and walk the first steps in web development. I also realized the second hardest part of learning web development is having the motivation to stick with it.

From this experience sprang the idea of teaching others how to achieve their dreams through building actual websites from from day 1 while learning the basics of web development at the same time. All the course requires is a commitment of three weeks and not more than 30 minutes of your time a day. By the end of the course, you’ll be building your dream website yourself without any of my help.

Instructor Biography

Sandor Kiss, Teaching 88,000+ Students, Performance Marketer

Hi, I'm Sandor!

I am passionate entrepreneur and performance marketer with ten thousands happy students.

Let me tell you my story...

At the age of 16, I founded my first online business. After being a full-time CPA marketer for more than 5 years, I decided to shift gears and use my skills to build companies.

Ever since, I have been lucky enough to do what I love the most: entrepreneurship, travelling the world, pushing my comfort zone and discovering things that I couldn't learn in the classroom.

One year ago, I decided to take the next step and share my knowledge with those who are ready to start their own business. This decision brought me to Udemy, where I am able to combine my biggest talents: entrepreneurship, marketing and teaching.

My teaching philosophy on Udemy is simple: I am crafting trainings that I wish I had available to me when I started my first company.

My courses serve a very important goal: helping you to transform your life and becoming a successful entrepreneur and marketer.

I've seen the impact a solid business can have on someone's life. That's why I can only encourage you not to miss out on this opportunity.

As of today, I've sold more than 250,000 trainings, established multiple successful online businesses and coached hundreds of students.

So, that's my story. But now, I just want to ask you a simple question.

Do you want some help?

Do you want to establish your own business, become an entrepreneur or simply generate more revenue from your current business?

Great, because I am sure I am going to be able to help you. Feel free to check out my course portfolio and let's see if we can work together.

Best Regards,

Sandor Kiss

Ready to start learning?
Take This Course