The McKinsey Way Of Excel Hacking and Dynamic Charting
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:
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:
Take The Best Seats In The House & Discover How To Succeed At The Modern Workplace With Excel:
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!