Overview

Forecasting Techniques Course Overview

This Forecasting Techniques course will teach you qualitative and quantitative forecasting techniques. Various quantitative techniques will be covered, including an application of each technique to a practical situation. The course will use these techniques in a financial model to produce compelling financial forecasts.

Who Should Take This Course?

This course on forecasting techniques is designed for those responsible for producing and maintaining forecasts in financial models within their organizations. This may include professionals in financial planning and analysis (FP&A), accounting, treasury, financial reporting, corporate development, and capital markets.

Forecasting Techniques Learning Objectives

  • Explain how Goal Seek can be used when forecasting in a financial model.
  • Calculate an optimal solution for a forecast using the Solver tool in Excel.
  • Build a financial model forecast using the slope and Y-intercept from a linear regression.
  • Create a forecast using the coefficients from a multiple linear regression.
  • Explain how forecast functions in Excel can be used to forecast a seasonal business.
  • Build a forecast for a seasonal business showing the upper and lower confidence intervals.

Prerequisite Courses

Recommended courses to complete before taking this course.

Forecasting Techniques
5

Level 2

49min

100% online and self-paced

Field of Study: Finance

Start Learning

This Course is Part of the Following Programs

Why stop here? Expand your skills and show your expertise with the professional certifications, specializations, and CPE credits you’re already on your way to earning.

Financial Planning & Analysis Professional

  • Skills You’ll Gain Accounting, Finance, Excel, Data Analysis, Financial Statement Analysis, Financial Modeling, Budgeting, Forecasting, Power Query, Power BI, Data Visualization, Economics, and more
  • Great For The FPAP certification focuses on practical, desk-ready skills that are immediately applicable to current FP&A professionals or anyone seeking to land a role in FP&A

What Our Members Say

Excellent professor with the right teaching skills and knowledge.

Ramón Rodríguez González

Superb
I would like to express my sincere thanks to Duncan and the organization for delivering such a high-quality learning experience. Duncan explained each concept in a very clear and structured manner, making even complex topics easy to understand. The course has been thoughtfully designed to guide learners from a foundational level to advanced knowledge, making it suitable for both beginners and professionals looking to deepen their expertise in Regression Analysis etc.

Herath Mudiyanselage Samith Menaka Dissanayake Herath

must learn
goal seek, solver, regression, analysis tookpak for multiple regression, forecast.ets, forecast.ets.confint. essential excel forecast tools and techniques taught in the simplest way possible. thank you!

Christopher Shee Kay Shen

Simple and clean workflow
Quick and simple course

Krishnan Iyer

Frequently Asked Questions

If you haven’t found your answer from our FAQ, please send us a message.
If you haven’t found your answer from our FAQ, please send us a message.
0 search results for ‘