Tutorvo
Menu
Courses Guides Pricing Log in Sign up
Data & Analytics Intermediate

Forecasting & Time-Series Analysis in Excel

Growth rates, smoothing, seasonal indices, trend × season forecasts, accuracy metrics and driver-based scenarios: 8 labs on one consistent retail dataset.

8 lessons 8 labs 2.2 h Certificate

  • One-time payment
  • 14-day money-back guarantee
  • Secure checkout with Stripe

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

  • Read 36 months of revenue: month-over-month, year-over-year, the annual totals and the compound annual growth rate.
  • Forecast next week's web-shop orders three ways: a 4-week moving average, a weighted moving average and exponential smoothing.
  • Measure how strong each calendar month is: average per month, overall average and the seasonal index.
  • Remove the season from 2025 revenue to see the underlying level, then put the season back to forecast Q1 2026.
  • Fit a straight-line trend to 36 months of deseasonalised revenue and extend it through 2026.
  • Combine the linear trend with the seasonal indices into a monthly 2026 forecast and compare the year with 2025.
  • Grade last year's 2025 forecast against the actuals: average error, percentage error, bias and the tracking signal.
  • Build 2026 revenue from its drivers in three scenarios, weight them and compare the result with the trend × season forecast.

About this course

Before reaching for a black-box model, it helps to forecast a series by hand and understand each component. You describe a time series with month-on-month, year-on-year and compound growth, then smooth it with simple and weighted moving averages and exponential smoothing. A seasonal index is calculated for every month, used to deseasonalise the data and to put seasonality back in. A linear trend is fitted with TREND, FORECAST.LINEAR, SLOPE and INTERCEPT, then combined with seasonality into a twelve-month forecast. You measure accuracy with MAE, MAPE, bias and a tracking signal, and finally compare the statistical forecast with a driver-based scenario. For analysts, planners, finance teams and students.

Curriculum

Course content

8 lessons · 8 labs · 2.2 h · final exam

  1. Time-Series Basics: MoM, YoY and CAGRLab15 min4 checked tasks
    Unlocked when you buy the course
  2. Moving Averages, Weighted Averages & Exponential SmoothingLab18 min3 checked tasks
    Unlocked when you buy the course
  3. Seasonality: a Seasonal Index for Every MonthLab16 min4 checked tasks
    Unlocked when you buy the course
  4. Deseasonalising & ReseasonalisingLab16 min4 checked tasks
    Unlocked when you buy the course
  5. Linear Trend: TREND, FORECAST.LINEAR, SLOPE & INTERCEPTLab17 min5 checked tasks
    Unlocked when you buy the course
  6. Trend × Seasonality: the 12-Month ForecastLab17 min4 checked tasks
    Unlocked when you buy the course
  7. Forecast Accuracy: MAE, MAPE, Bias & Tracking SignalLab18 min5 checked tasks
    Unlocked when you buy the course
  8. Driver-Based Scenarios vs the Statistical ForecastLab17 min4 checked tasks
    Unlocked when you buy the course
  9. Final exam12 questions, 75% to pass, unlimited retries.

Certificate

Finish with a certificate you can verify

Complete every lesson and pass the final exam to receive a certificate of completion for this course, with a unique credential ID and a public verification page.

  • Names the course, your score and the date of issue
  • A verification link for your CV or LinkedIn profile
  • 12 questions, 75% to pass, unlimited retries.

A Tutorvo certificate confirms that you completed a course. It is not an official or professional qualification.

Illustration. Your certificate shows your own name, course and credential ID.

Before you buy

Questions about this course

Is this a subscription?

No. You pay $9.99 once for this course. There is no subscription and nothing renews automatically. Prices are in US dollars; taxes may be added where required.

What exactly do I get?

All lessons and labs of this course, the final exam and the certificate, including later updates to the course, for as long as Tutorvo offers it. Access is personal and tied to your account.

Can I get a refund?

Yes. If you are not satisfied, email hello@tutorvo.com within 14 days of buying and we refund the course in full via Stripe. The guarantee does not apply once a certificate for the course has been issued to you, or where there are signs of abuse.

When can I start?

Right after payment. Access starts immediately at your request; for consumers in the EU/EEA the statutory right of withdrawal therefore ends once access has begun, while our 14-day money-back guarantee applies regardless.

Do I need Excel or other software?

No. The labs run in a spreadsheet inside your browser on a laptop, tablet or phone. Function names and syntax follow Excel.

Is the certificate an official qualification?

No. It confirms that you completed all lessons of the course and passed its final exam. It is not an official, state-recognised or professional qualification. The name is taken from your profile when the certificate is issued.

Full details are in our Terms · hello@tutorvo.com

Browse all Data & Analytics courses →
$9.99one-time payment
Buy course