The McKinsey Way Of Excel Hacking and Dynamic Charting Udemy
Price: USD 200
  • Duration: Flexible

Course details

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

Heres 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 youve:

  • 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, well cover the foundations of Excel, which includes an overview of navigation, formatting, tables, pivot tables, and charting. Ill explain how Ill 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, Ill show you how to handle worksheets, which is the key element to building massive spreadsheets effectively. Well also cover shortcuts and auto-fill tricks that will make your co-workers jealous.

Next, well dive deep into formulas. Ill show you how to calculate anything with Excel. Ill walk you through conditional formulas, date and time formula, VLOOKUP and HLOOKUP, count formulas and text formulas. Its time to stop the pain and get data in the format you need!

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

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

Last but not least, Ill 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, youll 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, youll 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!

Updated on 17 January, 2019
Courses you can instantly connect with... Do an online course on Microsoft Dynamics starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or