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!
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!
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!
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.
In this lesson, you’ll discover how to handle worksheets, including the quick access toolbar, important settings, and the name manager.
Did you know that Excel can automatically format row widths and fill in formulas for you? Here’s how to do it!
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.
Do you know what conditional formulas are? That’s what you’ll discover in this lesson.
In this lesson, you’ll learn a smart McKinsey’s way to track due dates in 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.
Sometimes you need to count items. There are two simple formulas to make counting super straightforward.
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.
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.
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.
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.
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.
I’d like to show you my best practice tutorial on hiding, unhiding and grouping 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.
In this lesson, you’ll discover how to make a table out of our data. Let’s go!
Learn the most effective way to sort and filter your data to only see what is relevant for your work.
Learn about table formulas and how to use them to work faster than everybody else.
In this lesson, you’ll discover how to work with pivot tables in the most efficient way. Let’s go!
Learn the most effective way to work with pivot charts in the same way top consultants do.
In this lesson, you’ll discover McKinsey’s most used chart types and learn how to build them.
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.
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.
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!
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.
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!
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.
Building a business without a proper P&L? Hell no! Check this lecture to learn building a profit loss statement in Excel.
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.
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.
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.
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.