Sales Forecasting in Excel for Management Consultants

Sales Forecasting in Excel for Management Consultants, available at $69.99, has an average rating of 4.55, with 70 lectures, based on 517 reviews, and has 3093 subscribers.

You will learn about Identify main drivers for specific business models Translate the drivers into a basic sales forecast models Create the sales forecast models in Excel Create simple simulations & sensitivity analysis This course is ideal for individuals who are Management Consultants or Business Analysts or Financial Controllers or Investment Analysts or Startup Founders or Project Managers or Managers responsible for Acquisitions and Mergers It is particularly useful for Management Consultants or Business Analysts or Financial Controllers or Investment Analysts or Startup Founders or Project Managers or Managers responsible for Acquisitions and Mergers.

Enroll now: Sales Forecasting in Excel for Management Consultants

Summary

Title: Sales Forecasting in Excel for Management Consultants

Price: $69.99

Average Rating: 4.55

Number of Lectures: 70

Number of Published Lectures: 70

Number of Curriculum Items: 70

Number of Published Curriculum Objects: 70

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

Identify main drivers for specific business models
Translate the drivers into a basic sales forecast models
Create the sales forecast models in Excel
Create simple simulations & sensitivity analysis

Who Should Attend

Management Consultants
Business Analysts
Financial Controllers
Investment Analysts
Startup Founders
Project Managers
Managers responsible for Acquisitions and Mergers

Target Audiences

Management Consultants
Business Analysts
Financial Controllers
Investment Analysts
Startup Founders
Project Managers
Managers responsible for Acquisitions and Mergers

What is the aim of this course?

During many consulting projects, you may be asked to forecast the sales of the firm or check sales forecast models done by the customer.Sales forecasting requires a specific approach to data and also a lot of creativity, thinking outside the box, to address the issue of insufficient data and the changing environment. In this course, I will teach you how to do fast and efficiently basic sales forecast models in Excel. We will create relatively simple sales forecasts. Nevertheless, they will significantly help your customer define strategy, and decide whether he should open a new factory, enter a new field, or buy a business. We will NOT get into complicated models, or forecasts as in most cases you will have neither time nor data to do them. It would also require a wider knowledge of mathematics, statistics, econometrics, and the usage of more advanced tools than Excel. The things you will learn in this course will be sufficient in 70% of the cases and can be done with the knowledge of basic Math. Such basic sales forecasts are especially important during Strategy projects, M&A projects, and business development projects. In such projects, you want to get fast rough sales forecasts using simple methods. A similar approach as we will show in this course can be used as the starting point for budgeting models.

In the course, you will learn the following things:

The essential conceptsin sales forecastingand the main tools that you may need.
How to forecast sales in Excelusing simple methods fast and efficiently
What drivers of salesyou should take into account for selected industries?
We will look at different case studies to see how you can move from drivers to a working model 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 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 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 McKinsey, 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. For every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and materials shown in the lectures. Therefore, 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?

Most management consultants avoid the topic of sales forecasting due to insufficient knowledge of mathematics, probability, and statistics. To make advanced models you need those things. However, in most cases, a simple approach using Excel can produce pretty good results. For that, you don’t have to spend 5 years studying math.

Therefore, I have decided to create this course that will help students understand or refresh the main skills and toolsthat they need during consulting projects to do basic sales forecasting. 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 know what and how to do during the consulting project, when you will be asked to forecast sales. You will see how to identify what drivers are important in specific businesses and how to use them to build simple models in Excel.

To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of how to do essential sales forecasting. That is why, I highly recommend this course to Management Consultants and Business Analysts, especially those that did not finish, mathematics and econometrics. The course will help you become pretty good at doing simple sales forecasting models in Excel 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:

The essential conceptsin sales forecastingand the main tools that you may need.
How to forecast sales in Excelusing simple methods fast and efficiently
What drivers of salesyou should take into account for selected industries

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 3 sections. Currently, you will find the following sections:

Introduction.We begin with a little intro to the course as well as some general info on how the course is organized
Basics of Sales Forecasting.In sales forecasting, you can use different approaches. We will discuss them in this section and I will give you some tips on which one you should use in a specific situation.
Useful Tools for Sales Forecasting.In sales forecasting, you can use different tools. We will discuss them in this section. We will talk about disaggregation, simulations, sensitivity analysis, and random variables. We will, later on, need those concepts to solve case studies
Case Studies in Sales Forecasting. Finally, in the 4th section, we will move to case studies devoted to specific industries. We will look at 6 case studies and I will show you how to move from general drivers for the business to a model in Excel that you can use

You will be able also to download many additional resources

1. Useful frameworks and techniques

2. Analyses shown in the course

3. Additional resources

4. Links to additional presentations, articles, and movies

5. Links to books worth reading

At the end of my course, students will be able to…

Identify the main drivers for a specific business
Translate the drivers into basic sales forecast models
Create the sales forecast models in Excel
Create simple simulations & sensitivity analysis

Who should take this course? Who should not?

Management Consultants and Business Analysts
Financial Controllers
Investment Analysts
Startup Founders
Project Managers
Managers responsible for Acquisitions and Mergers

What will students need to know or do before starting this course?

Basic or intermediate Excel
Basic knowledge of economics
Basic or intermediate knowledge of finance & accounting

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: A little bit about me

Lecture 3: How the course is organized

Lecture 4: How to deal with Blurry image

Lecture 5: How to reach additional resources

Chapter 2: Basics of Sales Forecasting

Lecture 1: Basics of Sales Forecasting – Introduction

Lecture 2: Different approaches to sales forecasting

Lecture 3: Data Base for Sales forecasting

Lecture 4: What you have to account for in sales forecasting

Chapter 3: Useful Tools for Sales Forecasting

Lecture 1: Useful Tools for Sales Forecasting – Introduction

Lecture 2: Scenario analysis – Introduction

Lecture 3: Which price formula is the best for my profits – Introduction

Lecture 4: Which price formula is the best for my profits – Solution – Times & Materials an

Lecture 5: Which price formula is the best for my profits – Solution – Mixed Options

Lecture 6: Simulation analysis – Introduction

Lecture 7: What will be the effect of the price increase – Introduction

Lecture 8: What will be the effect of the price increase – Solution – Impact on coffee only

Lecture 9: What will be the effect of the price increase – Solution – Impact on coffee and

Lecture 10: Juice Producer – Simulation – Introduction

Lecture 11: Juice Producer – Simulation – Tips how to do it

Lecture 12: Juice Producer – Simulation – Solution

Lecture 13: Decomposition of effects analysis – Introduction

Lecture 14: LFL analysis – Introduction

Lecture 15: LFL analysis – Solution – Part 1

Lecture 16: LFL analysis – Solution – Part 2

Lecture 17: LFL analysis – Solution – Power Point

Lecture 18: Sensitivity analysis – Introduction

Lecture 19: Sensitivity analysis – Solution In Excel

Lecture 20: Sensitivity analysis – Solution in Power Point

Lecture 21: Simple Regression Model – Introduction

Lecture 22: Simple Regression Model – Example

Lecture 23: Random Variables

Lecture 24: Random Variables in Excel – Introduction

Lecture 25: Random Variables in Excel – Examples

Chapter 4: Case Studies in Sales Forecasting

Lecture 1: Case studies – Overview

Lecture 2: Plywood sales forecasting – Case Introduction

Lecture 3: Plywood sales forecasting – Drivers

Lecture 4: Plywood sales forecasting – Engine

Lecture 5: Plywood sales forecasting – Simulations

Lecture 6: Book publisher – Case Introduction

Lecture 7: Book publisher – Drivers

Lecture 8: Book publisher – Seasonality & Aging

Lecture 9: Book publisher – New Books Modeling

Lecture 10: Book publisher – Old Books Modeling

Lecture 11: Book publisher – Summary

Lecture 12: Cosmetics producer – Case Introduction

Lecture 13: Cosmetics producer – Drivers

Lecture 14: Cosmetics producer – Data Available

Lecture 15: Cosmetics producer – Next Year Forecast

Lecture 16: Cosmetics producer – Changes

Lecture 17: Retailer new & old stores – Case Introduction

Lecture 18: Retailer new & old stores – Drivers

Lecture 19: Retailer new & old stores – Data Available

Lecture 20: Retailer new & old stores – New Stores

Lecture 21: Retailer new & old stores – Old stores

Lecture 22: Retailer new & old stores – Change

Lecture 23: Consulting Firm Sales Forecast – Case Introduction

Lecture 24: Consulting Firm Sales Forecast – Drivers

Lecture 25: Consulting Firm Sales Forecast – Data Available

Lecture 26: Consulting Firm Sales Forecast – Maximal and Expected Sales

Lecture 27: Consulting Firm Sales Forecast – Sales by Type

Lecture 28: Consulting Firm Sales Forecast – Random Delay in the Start

Lecture 29: Drones Sales Forecasting – Case Introduction

Lecture 30: Drones Sales Forecasting – Drivers

Lecture 31: Drones Sales Forecasting – Data Available

Lecture 32: Drones Sales Forecasting – Modeling Sales via Amazon

Lecture 33: Drones Sales Forecasting – Modeling Sales via Retail Chain

Lecture 34: Drones Sales Forecasting – Total Sales

Lecture 35: Drones Sales Forecasting – How to create the simulation

Chapter 5: Conclusions

Lecture 1: Bonus Lecture

Instructors

Asen Gyczew
Expert in performance improvement, turnaround and startups

Rating Distribution

1 stars: 5 votes
2 stars: 8 votes
3 stars: 50 votes
4 stars: 187 votes
5 stars: 267 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu