Essential Excel for Project Managers (Udemy.com)

This course contains the use of artificial intelligence.

What is the aim of this course?

Nowadays, project managers have plenty of apps and software that support their work on a daily basis. Nevertheless, Excel still remains an important tool used to estimate the costs and benefits of the project. In some cases, Excel can be used to manage the project. In this course, I will teach how to use fast and efficiently Excel as a Project Manager.

In the course, you will learn the following things:

1. Essential Excel functions that will be useful during your work as a Project Manager

2. How to conduct cost-benefit analysis using Excel

3. How to select projects using Excel

4. How to create and use rankings in Excel

5. How to create Gantt Charts, dashboards, and project cards in Excel.

6. How to summarize progress in Excel

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 the 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. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who are now 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 315 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 Excel files, as well as additional presentations, and materials shown in the lectures, so as 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?

Project Managers will have to use Excel in a different way than Analysts. Moreover, in some cases, you cannot use more advanced tools for project management as your team is obsessed with Excel. Project Sponsor will also ask you to create dashboards, Gantt charts, and a summary of the results of projects. Therefore, I have decided to make this course that will help students work fast and efficiently in Excel before and during projects. The course will give you the knowledge and insight into real-life case studies that will make your life easier. Thanks to this course, you will know what and how to prepare and manage efficiently any projects with the help of Excel.

To sum it up, I believe that if you want to become a world-class Project Manager, you have to have a pretty decent understanding of Excel. That is why I highly recommend this course to Project Managers, especially those who have to report to the Steering Committee the results of many projects. The course will help you become an Excel expert at 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:

1. Essential Excel functions that will be useful during your work as a Project Manager

2. How to conduct a cost-benefit analysis using Excel

3. How to select projects using Excel

4. How to create and use rankings in Excel

5. How to create Gantt Charts, dashboards, and project cards in Excel.

6. How to summarize progress in Excel

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

How is the course 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 information on how the course is organized

• How to merge data from different sources. In this section, we will see how we can use essential functions to merge data from different sources. You will need them not only to analyze data but also to summarize results and create reports for the Steering Committee

• To-do lists in Excel. In the next section, I will discuss how you can create an easy-to-navigate to-do list in Excel. I will show you some hacks that will turn the to-do list into an effective tool for efficient project management.

• Cost-Benefit Analyses in Excel. As a Project Manager, you will quite often have to see whether the project makes sense or not. That’s why I will explain to you how to create a cost-benefit analysis. We will look at useful frameworks, and we will apply them to case studies.

• How to create a Project Charter using Excel. In this brief section, I will show you how to create a project charter and a project card in Excel.

• How to use the IF function and what you can do instead? The IF function is not always the best choice. That’s why in this section I will show you what other, more flexible functions you can use instead.

• Gantt Charts in Excel. In this brief section, I will show you how to create a Gantt chart in Excel.

• How to create a dashboard in Excel. In this brief section, I will show you how to create a dashboard in Excel.

• Rankings. In some cases, you may also need to present different options to solve specific problems. Your Supervisor will expect you to somehow rank those options. That’s why in this section, I will show you how to create rankings in Excel.