Excel Shortcuts for Management Consultants

Excel Shortcuts for Management Consultants

What is the aim of this course?

As a Business Analysts 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, applying certain rules in analysis. The rest: 40% is coming from applying Excel shortcuts that drastically changes 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, business analysts, 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 Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried or supervised over 90 different performance improvement projects in different industries that generated in total 2 billion of additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are 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 124 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 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 in order 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 most likelihood, you will spend more time with Excel than with your girlfriend or boyfriend. An important part of proficiency in Excel, 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 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, people working in investment banking, private equity.       

In what way will you benefit from this course?   

The course is a practical, step-by-step guide loaded with tones of tips, tricks, hints that will significantly improve the speed and efficiency of your analysis in Excel. There is little theory – mainly examples, 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 you should learn by heart   

• What other rules are worth following   

• How does analysis done using Excel shortcuts look like    

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

How the course is organized?  

The course is divided currently 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 on a daily basis   

• 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 analysis performed using Excel shortcuts   

  You will be able also 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

A practical guide on how to work fast in Excel during Management Consulting projects

Url: View Details

What you will learn

• Work 2-5x faster thanks to the shortcuts you will learn in the course
• Spend less time on repetitive things
• Use the right Excel shortcuts to create a killer business analysis in Excel

Rating: 4.5

Level: Beginner Level

Duration: 1 hour

Instructor: Asen Gyczew