Forecast Anything with Excel
4.0 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
189 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Forecast Anything with Excel to your Wishlist.

Add to Wishlist

Forecast Anything with Excel

Learn to create your own FORECASTS with just Microsoft Excel: trends, seasonalities, forecast intervals and more!
4.0 (19 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
189 students enrolled
Created by Mauricio Maroto
Last updated 8/2017
English
Curiosity Sale
Current price: $10 Original price: $95 Discount: 89% off
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 5 Articles
  • 38 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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 reports.
  • BONUS: Excel's SOLVER refresh and further reading.
View Curriculum
Requirements
  • 1. Numerical data in the form of time series (evolves through time).
  • Examples of time series: monthly imports, weekly sales, daily website visits, hourly clicks, etc.
  • 2. The NEED to make your own FORECASTS.
  • 3. You do NOT want to share Confidential Data.
  • 4. Excel 2016 or 365 versions
Description

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

Course Achievements:

  • +100 Worldwide Students enrolled

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

Some Student Reviews are:

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

"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." (Apr-17)

"Overall it is great." (Apr-17)

"Very insightful!" (Mar-17)

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

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 is the target audience?
  • Anyone that needs to FORECAST his/her confidential data for professional (or own) purposes.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
33 Lectures
03:45:49
+
INTRODUCTION
8 Lectures 29:14
Understand all this course has to offer in a few minutes!
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!

Preview 00:45

BONUS COUPON: For any course!
00:04

Understand the concept of FORECASTS and related keywords

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 Examples
2 Lectures 23:20

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

FORECASTING Historical Earthquakes 1965 - 2016
23:11

As an early enrolled student, you get to decide what FORECASTING Example goes here. Let me know!

FORECASTING Project #2: You decide!
00:09
+
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:25
Further Reading
00:25
About the Instructor
Mauricio Maroto
4.3 Average rating
150 Reviews
2,417 Students
4 Courses
Economist Data Scientist +2,000 students and growing!

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

In-Development: Convolutional Neural Networks: Create your Full CNN Application. Send your suggestions and comments now!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Latest course: The Visual Guide on How Neural Networks Learn from Data. Average Review: 4.5/5.0. Check it out now!

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

Mauricio Maroto holds a Master in Industrial Economics from Carlos III University in Madrid, Spain. 

He has with extensive experience in Data Analysis and Visualization. He's proficient at Python, STATA and Microsoft Excel and he likes Machine Learning, Prediction, Optimization Methods and similar quantitative topics. He gained all experience through work, private consultancies and personal projects.

He blogs about Machine Learning, Energy, Technology and related topics at medium website.

He believes "Code is a fundamental skill" and "innovation brings progress to everyone". He loves teaching, passing knowledge and just making life easier. 

Mauricio's other passions are his family, friends, his pets and he loves to play soccer, whether indoors or outdoors. He also goes out for a run on weekends (not lately). He also loves topics such as Entrepreneurship, Cryptocurrencies and Science.