Excel Shortcuts for Management Consultants
.MP4 | Video: 1280×720, 30 fps(r) | Audio: AAC, 44100 Hz, 2ch | 518 MB
Duration: 1 hours | Genre: eLearning | Language: English
Practical guide how to work fast in Excel during Management Consulting projects
What you’ll 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
Have more time to progress faster at your work
Basic or intermediate Excel
Basic knowledge of economics
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 the 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 of 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. From this course will greatly benefit anybody, who uses Excel 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 analyses that also looks great
What other rules will make your life easier when it comes to Excel and Power Point
The course is based on my 14 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement and turn-arounds in biggest companies from Retail, FMCG, SMG, B2B and services sector that I worked for. On the basis of what you will find in this course I have trained over 100 consultants, business analysts and managers who are now CEO, COO, Directors of Sales, Production, Investment Directors in PE funds, Directors in Consulting Companies, Board Members etc. On top of that over 28 000 students have taken my courses on Udemy.
I teach through cases, so for every shortcuts 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 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 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 the 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 work.
To sum it up, I believe that if you want to want to become top Management Consultant / Business Analysts you should master 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 in 4 sections and I will be adding new sections to address other important issues. Currently you will find the following sections:
Introduction. We begin with little intro into the course as well as some general info on production
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 daily basis
Useful rules that will make your life easier. In this section I will discuss other useful tool for Excel as well as Power Point 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 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
Who this course is for:
Students that are considering becoming management consultants
People who use Excel for at least 1-2 hours a day