Forecast Anything with Excel

1,554 students enrolled

Forecast Anything with Excel

Learn to create your own FORECASTS with just Microsoft Excel: trends, seasonalities, forecast intervals and more!

1,554 students enrolled

Created by Mauricio Maroto

Last updated 8/2017

English

English [Auto]

Preview this course

Forecast Anything with Excel

$65.99 $94.99 31% off

23 hours left at this price!

30-Day Money-Back Guarantee

3.5 hours on-demand video
4 articles
38 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

Keep your confidential data to yourself ═> Do your own FORECASTS!
Create FORECASTS at confidence levels: 90%, 95%, 99% and more.
Create Graphs showing your FORECASTS for your office Reports.
BONUS: Excel's SOLVER refresh and further reading.

+ – INTRODUCTION

8 lectures 29:13

Understand all this course has to offer in a few minutes!

Course Overview

Preview 05:53

This lesson presents how to approach this course, depending on your background and interests. From beginner to advanced students, you are all covered!

How to go through this course

Preview 00:43

BONUS COUPON: For any course!

00:04

Understand the concept of FORECASTS and related keywords

What is a FORECAST?

Preview 05:24

Understand all the benefits of FORECASTING!

Why should you care about FORECASTS?

03:13

Identify the available methods and the ones we'll be using in this course

What FORECAST Methods are there?

04:01

Identify the requirements FORECASTS need in order to be statistical valid (which are not many, so you can use these methods for any data you have in the form of Time Series)

What are the Statistical Requirements?

03:10

Understand the course's terminology for easier concepts and practices

Some Terminology

06:44

Quiz

4 questions

+ – FORECASTING: Preliminary Analysis

6 lectures 33:15

The first step at assessing FORECASTS is to visualize the Time Series and get familiar with it, both from the technical and expert perspectives.

Graph the Time Series

04:05

Identify Trend, if present in your Time Series in order to apply the correct Forecast Method.

Determine Trend (tendencies)

03:50

Identify Seasonality, if present in your Time Series in order to apply the correct Forecast Method.

Determine Seasonality (Correlogram)

06:44

Choose the best Train and Test subsets out of your sample (Time Series). I will give you my rule of thumb!

Determine Train and Test datasets

04:16

Understand the difference between Confidence Intervals and Prediction Intervals (they are not the same!)

Confidence Intervals and Prediction Intervals

06:59

Among your FORECASTS models, determine which one has the "best" statistical criteria

Assesing FORECAST Accuracy

07:21

Quiz

5 questions

+ – FORECASTING: Using Simple Methods

3 lectures 24:30

Compute the Average FORECAST Method and understand its meaning as a simple benchmark model

Average Method

09:20

Compute the Naive FORECAST Method and understand its meaning as simple yet very limited benchmark model

Naive Method

07:15

Compute the Drift FORECAST Method and understand its meaning as another simple benchmark model

Drift Method

07:55

Quiz

2 questions

+ – FORECASTING: Using Powerful Methods

9 lectures 01:35:37

Compute the SES as your first powerful FORECAST method

Simple Exponential Smoothing (SES)

09:38

How to choose the Optimal SES for your data

SES -continued-

14:46

Finally, compute the SES Forecast and its Forecast Interval for added precision

SES -final-

15:04

Quiz

7 questions

Compute the HES method as your second powerful FORECAST method

Holt Exponential Smoothing (HES)

13:51

How to choose the Optimal HES for your data

HES -continued-

07:52

Finally, compute the HES Forecast and its Forecast Interval for added precision

HES -final-

07:24

Quiz

5 questions

Compute the Holt-Winters Exponential Smoothing (Seasonal, ETS) as your third powerful FORECAST method

Holt-Winters Exponential Smoothing (HWES)

07:41

Compute the HWES Forecasting method all within Excel and using built-in functions!

HWES -continued-

12:07

Here, I give you additional tips and I also present a 2nd example for your maximum learning

HWES -final-

07:14

Quiz

2 questions

+ – FORECASTING: Additional Example

1 lecture 23:11

Additional example of Powerful Forecasting method applied to Real World Data #1

FORECASTING Historical Earthquakes 1965 - 2016

23:11

+ – FINAL WORDS

1 lecture 00:26

Final Words

00:26

+ – OPTIONAL: Learn to use Excel Solver

3 lectures 19:04

Install Excel Solver, it's easy as it's already in your Excel, you just need to activate it

Install Excel Solver

02:58

Understand what is Solver and how it works as an iterative solution finding algorithm

What is Excel Solver? What is it good for?

08:51

Have a few hints and tis on using Excel Solver easily

How to use Excel Solver easily?

07:15

Quiz

6 questions

+ – OPTIONAL: Further Reading

1 lecture 00:23

Further Reading

00:23

Requirements

1. Your data as Time Series (data that evolves through time).
Examples of time series: monthly imports, weekly sales, daily website visits, hourly clicks, etc. You name it!
2. The NEED to make your own FORECASTS in-office.
3. You do NOT want to share Confidential Data => Keep it to YOURSELF!
4. Excel 2016 or 365 versions

Description

+800 Worldwide Students enrolled
+4.1 Average All-Time Rating!

═════════════════════════════════════════════════════

Some Student Reviews are:

"Very good choice, I'm sure this will help me with my daily work." (July 2018).

"My new job requires me to perform forecasting." (February 2018).

"This course really helped me understand the methods available and how to determine which one to use for my forecast." (January 2018).

"The tutor has taken his time to explain the concept and advantage of forecasting" (January 2018).

"Very good overview. Mauricio knows what he is talking about, and he presents the content in a very easy to understand way as well as in a direct way" (December 2017).

═════════════════════════════════════════════════════

More Student Reviews:

"This is a great course by Mr Mauricio Maroto. It is logically structured and built through consistent formulae & examples." (September 2017)

"The instructor is clear concise and direct to the point . He deep dive and explained each section of the course thoroughly." (October 2017)

"Another excellent course, full of clarity, detailed and yet offer excellent insights into the subject." (September 2017)

"Good Course if you want to understand the various Exponential Smoothing methods of forecasting using excel...Thank you." (June 2017)

"The course is excellent and very practical. In addition, the instructor is excellent and attentive. Very recommended course for anyone who wants to learn forecasting." (April 2017)

"Overall it is great." (April 2017)

"Very insightful!" (March 2017)

═════════════════════════════════════════════════════

Hi. Thanks for showing interest in this course!

With this course, you will learn how to FORECAST Anything with Excel. I'll show you step-by-step instructions for creating statistical FORECASTS applied to any Time Series, and thus, estimating your own results.

Many times, I found clients trying to FORECAST their own data but it's a difficult task. And not only that, they don't like to share their CONFIDENTIAL data to others! So, this course is the perfect answer for that.

You will learn how to FORECAST your own data using state-of-the-art statistical methods, but explained in a friendly way. I will also upload the Excel spreadsheets, so you can FORECAST your own data IMMEDIATELY.

With this course, you will also learn how to proficiently use Excel regarding variables, functions and graphs. In this course, we will cover:

» Preliminary Analysis

» Prepare Data for FORECASTS

» Create and Estimate FORECASTS

» Diagnose and Improve FORECASTS

» Show Results and Graphs

» Apply method to any other variable/data

The only thing you'll need for this course is your own data, which probably is confidential and don't want to share with others. The course will show you the rest!

You will also need a computer with Microsoft Excel 2016 installed (Home or Professional versions) or Microsoft Excel 365 version, because we will be using a few nice and easy new functions.

The course shows you everything you need to know in order to FORECAST your own key variables/data for better decision-making. Some of the benefits of FORECASTS are:

✓ Learn and improve from the past

✓ Remain and/or increase competitiveness

✓ Increase value by mitigating risks of uncertainty

✓ Decrease unnecessary costs, high inventories and/or unbalances

✓ Face spike in sales and keep customers happy, and much more!

As an added bonus, I will also leave all spreadsheets, so you can get to work and FORECAST immediately! You will get quick easy quizzes with detailed answers, so you can learn faster. In the end, you will be able to apply these methods in order to FORECAST any variable for your own purposes.

Lastly, you can post questions or doubts, and I’ll answer to you personally.

I hope you find this course as useful as I have creating it!

I’ll see you inside,

-M.A. Mauricio M.

Who this course is for:

Anyone that needs to FORECAST his/her confidential data for professional (or own) purposes.

Featured review

Jatin Dinesh ( 25 courses, 3 reviews )

a year ago

I felt it was difficult to adjust with the teachers start-stop pace of narration and teaching. Concepts should have been explained better and in a simpler easy to understand manner. The MVP of this course is the utilisation of Excel for basic forecasting techniques. One can experiment on the sample Data set to grasp the working of all forecasting methods taught and visualize it mentally.