Excel Shortcuts for Management Consultants

Overview

A practical guide on 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 courseSpend less time on repetitive thingsUse the right Excel shortcuts to create a killer business analysis in ExcelHave more time to progress faster at your work 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 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 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 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 224 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 most 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 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 courseEssential 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

Syllabus

• Introduction to Excel for Management Consultants
Overview of Excel and its importance in consulting
Basic navigation and interface
• Essential Shortcuts for Efficient Workflow
Navigation shortcuts
Selection shortcuts
• Data Entry and Management
Data entry shortcuts
Managing large datasets
• Formatting and Styling
Formatting shortcuts
Conditional formatting
• Formulas and Functions
Shortcut keys for common formulas
Tips for using functions effectively
• Data Analysis Techniques
Using shortcuts for data analysis tools
Pivot tables and charts shortcuts
• Reporting and Presentation
Creating reports quickly with shortcuts
Chart and graph shortcuts
• Collaboration and Sharing
Shortcuts for collaborative work
Protecting and sharing workbooks
• Practice Activities and Real-World Applications
Case studies on the use of Excel in consulting
Hands-on exercises with frequently encountered scenarios
• Wrapping Up
Recap of key shortcuts
Final project or assessment

Taught by

Asen Gyczew

Subjects

Business