Learn
Getting Started
Learn how to get started with the 
Google Sheets addon.
-
Installation and Setup
Install the addon and setup your API key
-
Your first forecast
Make your first forecast
-
Improving forecasts
Your first forecast probably doesn't look quite right. Learn how to apply data transformations and regressors to make it better.
-
Using the sidebar
Learn how to make forecasts using the sidebar menu
Theory
A deep dive into the theory of forecasting.
Once you've got the hang of the basics, look here to learn how to get the most out of your forecasting toolbox.
- Custom functions to add weather data to your forecasts
- Detecting anomalies in Google Sheets
- Automatically Scheduling Forecasts and importing into Google Data Studio
- A Workflow for Forecasting
- Cumulative Forecasts and Measuring Impact
- Backtesting and Estimating Accuracy
- Box-Cox and Logit transforms
- The Power of Spreadsheets
Training Courses & Consulting
Not finding what you are looking for?
I run online or on-location training courses in all areas of forecasting. These are perfect if you want to learn in a group environment with your collegues or if you learn best when you aren't just reading text.
If you have a tricky forecasting task I can also consult with you about how best to solve the problem. This might involve different algorithms and methods that aren't currently available on this site.
Ask about training or consultingTemplates and Examples
-
Easter Pageviews — Simple Example
The simplest example. Forecasting the number of pageviews for the Easter page on wikipedia.
-
Easter Pageviews — Complete Example
Read the tutorial on improving forecasts for an explanation of this sheet.
-
Graham Norton Pageviews
A more complex example; back testing a forecast for the number of pageviews for Graham Norton's wikipedia page.
