Excel Shortcuts for Management Consultants
4.2 (53 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,901 students enrolled

Excel Shortcuts for Management Consultants

Practical guide how to work fast in Excel during Management Consulting projects
4.2 (53 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,901 students enrolled
Created by Asen Gyczew
Last updated 11/2019
English
English [Auto]
Current price: $53.99 Original price: $89.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 1 article
  • 34 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Requirements
  • Basic or intermediate Excel
  • Basic knowledge of economics
Description

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
  • Management Consultants
  • Business Analysts
  • Controllers
  • People who use Excel for at least 1-2 hours a day
Course content
Expand all 29 lectures 01:09:53
+ Introduction
3 lectures 04:23

In this lecture I will show you what you can learn in this course.

Preview 01:48

A few words about your humble teacher

Preview 01:51

In this lecture I will show you how I organized this course and what you can expect in each and every section

Preview 00:44
+ Essential shortcuts
13 lectures 28:50

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

Preview 01:52

In this lecture I will explain you why you should not use the mouse

Preview 01:27

In this lecture I will show you how to format cells using shortcuts using shortcuts

Preview 01:45

In this lecture I will show you how to format cells using shortcuts using shortcuts

Preview 02:37

In this lecture I will show you how to format cells using shortcuts using shortcuts

Preview 03:11

In this lecture I will show you how to copy of cells with shortcuts using shortcuts

Copying of cells with shortcuts
02:31

In this lecture I will show you how to select rows and selecting columns using shortcuts

Preview 02:38

In this lecture I will show you how to add and removing rows and columns with shortcuts

Adding and removing rows and columns
02:17

In this lecture I will show you how to group rows and columns using shortcuts

Preview 03:12

In this lecture I will show you how to preserve your results or go back to previous ones  using shortcuts 

How to preserve your results or go back to previous ones
02:39

In this lecture I will show you how to go fast around the Excel with shortcuts

Going fast around the Excel with shortcuts
02:19

In this lecture I will show you how to selecting different areas with shortcuts

Selecting area with shortcuts
01:22

In this lecture I will show you how to search and replace data using shortcuts

Search and replace data
01:00
Shortcuts test
10 questions
+ More advanced shortcuts
6 lectures 09:10

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

Preview 00:51

In this lecture I will show you how to use shortcuts hidden in Functional Keyboards

Shortcuts hidden in Functional Keyboards
02:13

In this lecture I will show you how to insert hyperlinks using shortcuts

Hyperlinks
01:59

In this lecture I will show you how work with data in a table using shortcuts

Working with data in a table
01:26

In this lecture I will show you how to see underlying formulas using shortcuts

How to see formulas
00:59

In this lecture I will show you how to reach the menu with shortcut

How to reach the menu with shortcut
01:42

Here we will test whether you have managed to master the shortcuts discussed in this section

Shortcut Test 2
8 questions
+ Useful rules that will make your life easier
3 lectures 10:43

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

Useful rules that will make your life easier – Introduction
00:34

Here I show basic rules for Excel that you should follow

Rules for Excel
04:22

Power Pointe presentation is the second most important tools to be used by Business Analyst in his work. After all it is not only important to analyse data and draw conclusions but also to show them in a nice manner to decision makers. Here you will learn basic rules on how to build your Power Point deck in fast and easy manner. You will see also some examples of good and bad slides. There are many advanced tools for presentation (i.e.) Prezi. Still Power Point is the most often used and widely accepted

Rules for Power Point
05:47
+ Examples of analysis done using shortcuts
3 lectures 15:59

In this section I will show you examples of anlaysis done using the shortcuts

Examples of analysis done using shortcuts – Introduction
01:05

If you work for a retailer one of the most useful analysis is to check whether there is still potential to growth and how big it is. In this lecture I will show you 2 ways in which you can estimate how many shops you can open in a specific location, city, province. One approach will be concentrated solely on the number of shops whereas the second one will also take into account the size of shops

Potential growth by regions – case in retail
06:35

Here I will show you how to see which marketing activities you should bet on

Efficiency of marketing activities
08:19