Learn practical sales forecasting methods

The course material is condensed, filtered, and carefully crafted into 32 video lectures

SCANBA produced high quality, easy to understand, professional level course that is right for you, as a person interested in business education. Sales Forecasting by SCANBA is the course that will teach you how to forecast your sales in real life. Trends? No problem! Seasonality? You got it! Accuracy? Nail it down. By looking at data from the past, you can extrapolate trends that will allow you to make forecasts that are more accurate. These forecasts can be useful in all areas of business from sales, to management, to marketing. With your new knowledge on forecasting, you are on your way to making better business decisions.
Take The Course
  • Forecast trends, seasonal sales, and trends+seasonality

    Real business forecasting uses quantitative data collection methods, mathematics, and logical reasoning, there is very little guesswork involved and much to be gained for the business owner.

  • Organize and store sales data

    Your historical data can be used to make accurate predictions about what will happen in the future, allowing you to order the appropriate amount of stock, hire enough employees, and ensure your business runs smoothly.

  • Drive forecasts to high accuracy

    By looking at data from the past, you can extrapolate trends that will allow you to make forecasts that are more accurate. These forecasts can be useful in all areas of business from sales, to management, to marketing. With your new knowledge on forecasting, you are on your way to making better business decisions.

  • Report forecasting results with confidence

    The financial gains that can be achieved with business forecasting are real and can be achieved with the help of basic Excel techniques.

  • The course includes downloadable files with the examples

    Downloadable examples with Microsoft Excel.

  • Personalized SCANBA Certificate

    The course includes an exam. Successful students will receive a personalized SCANBA Certificate that will open new career opportunities and confirm your level of professional expertise.

What Will I Learn?

  • 3 major sales forecasting methods including moving average, exponential smoothing, and regression

  • 2 additional extensions to the methods for in-depth analysis

  • 5 Excel spreadsheet examples

  • Methods for predicting both seasonality and trends in your sales

Course curriculum

  • 01
    Get Started
    Show details
  • 02
    Moving Average
    Show details
  • 03
    Trends
    Show details
    • Trends
    • Example - Trend Forecasting. A Quick Start
    • Understanding Correlations
    • Regression. The Formula.
    • Example - Simple Regression
    • Excel File - Example Simple Regression
  • 04
    Seasonality
    Show details
    • Seasonality
    • Forecasting Seasonal Sales
    • Example - Forecasting Seasonal Sales
    • Excel File - Example Forecasting Seasonal Sales
  • 05
    Becoming a Professional
    Show details
    • Seasonality and Trend
    • Using More Than One Predictor Variable
    • Example - Using More Than One Predictor
    • Excel File - Example Using More Than One Predictor
    • Accuracy Matters
    • Building Confidence
  • 06

Course price

SCANBA Certificate

By the end of the course, you will be able to pass an exam and receive a personalized certificate of completion from the Scandinavian Institute of Business Analytics.
Take The Course
SCANBA Certificate