What is the aim of this course?
What is the aim of this course?
In consulting, you will be spending plenty of time browsing through documents and doing calculations in Excel to estimate the impact of potential improvements. However, in the end, you have to produce a presentation that you can show to your customers. That is why it’s essential to master PowerPoint. This skill will help you finish your work on time. In this course, I will teach how to produce fast and efficiently slides in PowerPoint during consulting projects.
In the course you will learn the following things:
How to create slides from scratch
How to be fast and efficient in PowerPoint
How to create simple and intermediate animations in PowerPoint
How to create charts in Excel
How to create charts in PowerPoint
How to create or modify templates
How to animate charts in 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 I have carried out or supervised over 90 different performance improvement projects in different industries that generated in a total of 2 billion in 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 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 case studies, so you will have a lot of lectures showing examples of analyses, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and materials shown in the lectures so as a part of this course you will also get a library of ready-made analyses that can, with certain modifications, be applied by you or your team in your work.
Why have I decided to create this course?
During consulting projects, you will spend up to half of your time in PowerPoint creating slides. That’s why it’s vital to use PowerPoint fast and efficiently. Once you master tricks and hacks that will help you do the slides much faster, you can spend more time understanding the business and building relationships with the customers. This, in turn, will help you get promotions much faster. Most firms, don’t give you the full toolbox that you need. This may lead to huge frustration during consulting projects and a lot of inefficiencies.
Therefore, I have decided to create this course that will help students learn essential PowerPoint or refresh their knowledge of PowerPoint. We will concentrate on the things you need during consulting projects. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will work much faster with PowerPoint and produce better, more consistent slides.
To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have pretty good at PowerPoint. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those who did not finish business school or Economics. The course will help you, master PowerPoint, on the level of McKinsey, BCG, Bain, and other top consulting firms.
In what way will you benefit from this course?
The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you understand, and analyze businesses. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will learn:
How to create slides from scratch
How to be fast and efficient in PowerPoint
How to create simple and intermediate animations in PowerPoint
How to create charts in Excel
How to create charts in PowerPoint
How to create or modify templates
How to animate charts in PowerPoint
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 currently divided into the following sections:
Introduction. We begin with a little introduction to the course as well as some general info on how the course is organized
Essentials. In this section, we will discuss how to do basic things in Excel like inserting slides, aligning objects, inserting objects, bringing and sending objects, and using smart art.
Animations. In this brief section, I will show you how to do different types of animations. We will use not only basic animation but also the animation of charts and through the transition.
Templates. In consulting, you will be using a lot of templates. In this section, I will show you how to create and modify them.
Essential Charts in Excel. In this section, I will show you how to insert and edit great charts in Excel. This will help us, later on, repeat it in PowerPoint.
How to create charts in PowerPoint. In the last section, I will show you how to create and modify charts in PowerPoint. We will use a lot of concepts that we have learned from Excel.
You will be able also to download many additional resources
Templates and libraries of slides
Additional resources
Links to additional presentations, articles, and movies
At the end of my course, students will be able to…
How to create fast and efficiently slides in PowerPoint during consulting projects
How to move, copy, and rearrange objects in PowerPoint
How to create animation in PowerPoint
Hot to create charts in Excel
How to create charts in PowerPoint
How to use the transition to animate objects
How to create templates in PowerPoint
How to use Smart Arts in PowerPoint
Who should take this course? Who should not?
Management Consultants and Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders
Project Managers
We begin with a little intro to the course as well as some general info on how the course is organized.
A few words about your humble teacher
Let's have a look how the course is organized
Here I will show you what to do if a blurry image appears
Here I will show you how to find additional resources attached to the course like Excel files, presentations, links, etc.
Where can you find the slides for the exercises?
In this section, we will discuss how to do basic things in Excel like insert slides, align objects, insert objects, bring and send objects, use smart art.
There are some standard ways to copy slides in PowerPoint. We usually copy slides from the Template presentation
Add a slide from the Insert Tab
Add a slide by right-clicking on the left column showing mini slides in Normal View
Copy existing slide from the current presentation
Copy existing slide from the Template Presentation
Use the Reuse Option
There are 3 ways in which you can copy objects in PowerPoint
Option 1 – Using Shortcuts
Option 2 – Mouse & Ctrl
Option 3 – Mouse & Ctrl & Shift
There are 3-4 ways in which you can move objects. We will discuss them in this lecture
Let’s try to rearrange the objects below so they are in 1 line
In consulting you use simple objects to create the majority of slides
Rectangles
Circles
Text Box
Lines
Connector
Let's train what we have learned in the previous lecture
On many occasions, you will want to have bars and columns with different colors, changed automatically. Let's see how this can be done in practice.
By using bring and send you can create complicated objects from simple shapes.
By using bring and send you can create complicated objects from simple shapes
In many situations, you will want to copy the formatting from one shape to other shapes. Let’s see how this can be done in practice.
PowerPoint has a lot of built-in interesting, complicated shapes that are called Smart Art. Let’s see how you can use them.
In some cases, you will want to highlight certain periods like weekends or specific months on a chart. Let's see how this can be done in practice.
There are 7 ways to view the presentation. We will discuss them in this presentation.
In this brief section, I will show you how to do different types of animations. We will use not only basic animation but also the animation of charts and through the transition.
PowerPoint allows the following animations
Entrance
Emphasis
Exit
Motion
Animation of text
Animation of charts
Excel does not allow you to put the total on column charts. There is a hack that enables you to do that. Let's see how this can be done in practice.
Here I will show you how to animate the movement of objects
There are also many options to animate text within the boxes. We will discuss them now.
Now let’s see how we can use Animation to show specific things during consulting projects. We will have a look at real-life examples.
Let's use a sequence of slides to create an animation
Let's see how we can use transition to do animations
Let's see how you can use morphing to show the transition from one object to another one
In consulting you will be using a lot of templates. In this section, I will show you how to create and modify them.
A lot of things are repetitive. Therefore, it makes sense to standardize everything. In this lecture, we will show to do it in practice.
The next step after you created standards is to create templates. In this lecture, I will explain how to do it in practice
For some things, standards cannot be applied straightforward. You need to introduce modules to move forward. I will show you in this lecture how to implement it in practice.
Master slides & Layouts have a lot of benefits. We will discuss them in this lecture.
Here I will show you why it's good to have a library of ready-made slides
How to structure presentations like management consultants
In this section, we will move to more technical issues. I will show you how you can create and modify specific types of charts in Excel.
Let's see how you create a regular chart in excel. We will share the basics
In consulting you will spend a lot of time on formatting charts. Let's see how this can be done fast
Now let's see how you can make the charts more appealing to your customers
In some cases, you will need 2 different axes on the same chart. Let's see how this can be done in practice.
Excel allows you to reuse formatting done for other charts. Let's see how this can be done in practice.
In some cases, you will not like the order in which data are put. Let's see how this can be done in practice.
I will show you why it's important a separate sheet for data for the slides
Sometimes you will want to create more complicated charts that you cannot do directly in Excel. I will show how to find a way around
I will show you how to create a waterfall chart
I will show you how to create a scatter plot chart with automatically updated labels
In the last section, I will show you how to create and modify charts in PowerPoint. We will use a lot of concepts that we have learned from Excel.
In this lecture, I will show you how to create charts in PowerPoint
In this lecture, I will show you how to format charts in PowerPoint.
In this lecture, I will show you the library of formatted charts that may prove useful
In this lecture, I will show you how to change the colors of charts in PowerPoint
In this lecture, I will show you how to animate charts
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.