The McKinsey Way Of Excel Hacking and Dynamic Charting
3.2 (120 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.
17,160 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The McKinsey Way Of Excel Hacking and Dynamic Charting to your Wishlist.

Add to Wishlist

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.2 (120 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.
17,160 students enrolled
Last updated 7/2013
English
English [Auto-generated]
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • Excel 2003, 2007, 2010, 2011, 2013, 2015 or 2016
  • Capability to follow the step-by-step instructions of this training
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!

Who is the target audience?
  • Beginner & intermediate Excel users
  • Skilled office workers who want to advance their career
Compare to Other Excel Courses
Curriculum For This Course
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
01:44
+
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
10:55

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
02:20
+
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
11:26

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
14:10

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
05:28

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
07:24

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

Count Formulas - How To Count Anything In Excel
02:29

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
13:01

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
06:39
+
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
03:01

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
04:52

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
05:50

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
04:35

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
05:25
+
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
02:27

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

Sorting & Filtering Secrets Revealed
02:41

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
02:54
+
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
09:19

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
04:34
+
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
03:06

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
16:03

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
06:50

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!
03:41

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!
03:50
+
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
08:21

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)
05:30

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)
07:40
+
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!

Congratulations!
06:52

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
About the Instructor
Matthias Bellmann
3.4 Average rating
154 Reviews
19,784 Students
2 Courses
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.

Sandor Kiss
4.3 Average rating
8,949 Reviews
143,968 Students
74 Courses
Teaching 140,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