Excel Shortcuts for Management Consultants (Udemy.com)

What is the aim of this course?

As a Business Analyst or Management Consultant, you will be spending 3-5 hours a day crunching data in Excel and doing analysis. That is why you should become a Master of Excel and be able to do fast analysis. In this way, you will have a chance to have a life outside your time-consuming work. People trained by me are able to do business analysis in Excel 10x faster than most business analysts and management consultants working in top consulting firms. 60% of the effect comes from knowing the right formulas and applying certain rules in analysis. The rest: 40% is coming from applying Excel shortcuts that drastically change the speed at which you are able to produce analysis in Excel. In this course, I will concentrate on teaching you the essential Excel shortcuts that will make your life much easier.  

This course will help you drastically improve your speed of preparing business analysis in Excel, thanks to Excel shortcuts. It is designed for people who want to become or are management consultants and business analysts, who work in consulting, private equity, or investment banking. This course will greatly benefit anybody who uses Excel for at least 1-2 hours a day. In the course, you will learn 3 things:   

• How to work fast with Excel using shortcuts  

• How shortcuts can be applied to create a killer analysis that also looks great   

• What other rules will make your life easier when it comes to Excel and PowerPoint?   

This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from the Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in additional EBITDA. Based on what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who are now Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that, my courses on Udemy were already taken by more than 355 000 students, including people working in EY, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.

I teach through cases, so for every shortcut, I will show you how to apply it. At the end of every lecture, there will be a short overview of the shortcuts covered. I am using Excel under Windows / PC (non-Mac), but in the overview, I will also show the shortcuts for the Mac / Apple version of Excel. If you are already working in Management Consulting, this course will give you an advantage over your colleagues and will help you get promoted faster to a Project Manager position.     

Why have I decided to create this course?   

The speed of analysis is critical to survive the first 1-3 years in Management Consulting and thrive. This cannot be achieved if you do not master Excel, as it will be one of the two main tools with which you will work. In all likelihood, you will spend more time with Excel than with your girlfriend or boyfriend. An important part of proficiency in Excel, and doing the analysis fast, is using Excel shortcuts.    

There are plenty of Excel shortcuts that you can use. In this course, I will show you the essential ones that will help you 2-5x your speed of analysis in Excel. I will also show you how to look for other useful shortcuts.    

Thanks to this course, you will be doing the analysis much faster. This will give you time to learn new things, progress faster at work, deliver ahead of deadlines, and have a normal life outside the workplace.   

To sum it up, I believe that if you want to become a top Management Consultant / Business Analyst, you should master the Excel shortcuts presented in this course. That is why I highly recommend this course to consultants, business analysts, and people working in investment banking and private equity.       

In what way will you benefit from this course?   

The course is a practical, step-by-step guide loaded with tons of tips, tricks, and hints that will significantly improve the speed and efficiency of your analysis in Excel. There is little theory – mainly examples, and a lot of tips from my own experience. Our intention is that, thanks to the course, you will learn:   

• How to work fast in Excel using shortcuts   

• Which Excel Shortcuts should you learn by heart   

• What other rules are worth following   

• How does the analysis done using Excel shortcuts look    

You can also ask me any questions either through the discussion field or by messaging me directly.   

How is the course organized?  

The course is currently divided into the following sections:  

• Introduction. We begin with a little intro into the course, as well as some general info on the course

• Essential shortcuts. In the second section, I will discuss essential shortcuts that you have to learn by heart to prepare fast analysis.   

• More advanced shortcuts. In this section, I will discuss more advanced shortcuts that I also find extremely useful. I will also show you      how to find new shortcuts for the specific tasks that you repeat daily   

• Useful rules that will make your life easier. In this section, I will discuss other useful tools for Excel as well as PowerPoint that I recommend instilling in your daily routine to even further boost your efficiency   

• Example of analysis done using shortcuts. In the last section, I will show you an example of an analysis performed using Excel shortcuts   

You will also be able to download many additional resources   

• Excels with analyses shown in the course   

• A list of Excel Shortcuts – PDF presentation.   

• Links to additional presentations and movies

• Links to books worth reading