Microsoft Excel: Forecast Sheets & Trendlines

Wishlist Share

About Course

Use Excel’s built-in tools to project trends sensibly. Learn how to prepare time-series data, create a Forecast Sheet with confidence intervals and seasonality, use FORECAST.ETS and FORECAST.LINEAR, add trendlines to charts, and – just as importantly – understand the limits of any forecast.

Tutwoo is an independent learning provider. This course is general awareness training written from published official guidance. It does not replace training required for your specific job, and it is not an accredited qualification.

© 2026 Tutwoo UK Limited. This course was created in-house by Tutwoo and is our original work. It is for your own learning only: please do not copy, share, record or resell it.

What Will You Learn?

  • Prepare time-series data with consistent intervals
  • Create a Forecast Sheet and interpret its confidence interval
  • Choose suitable trendlines and read R-squared sensibly
  • Explain the limitations and assumptions of a forecast

Course Content

Course Lessons

  • Preparing data for forecasting
  • Creating a Forecast Sheet
  • Trendlines and FORECAST.LINEAR
  • Using forecasts responsibly

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕