Microsoft Excel Course Online October 22, 2025 Forecasting

Excel forecasting course

Wed, Oct 22 2025

10:00 am to 5:00 pm

Online Training

$395.00

In this Excel course you learn the process and tools for forecasting and creating useful data projections to help with strategic decision-making. Master forecasting techniques using the Forecast Sheet and Forecast Functions as you learn tools for streamlining data analysis including the Quick Analysis Tool. Learn efficient data structuring, and create useful visualizations to aid decision making, including sparklines, and dynamic charts. Learn to use What-If Analysis to create scenarios and projections, and learn to use Goal Seek to create more precise forecasts. Enhance your analytical capabilities with Solver, defining and solving complex problems, optimizing numerical decisions, and conducting thorough What-If Analysis. You’ll also improve your data management skills as you learn to use the Power Query Editor for gathering, appending, merging, and transforming data. Elevate strategic analysis using the Excel Data Model, linking tables, creating calculated columns, measures, and Key Performance Indicators (KPIs). In this Excel course you will gain skills to transform data into actionable insights for making informed decisions that drive success.

Detailed topics covered in the Excel forecasting course

Introduction to Excel forecasting

Understanding forecasting
Creating precise projections with the forecast sheet
Tailoring forecasts with modifiable options
Improving insights with forecast functions
Understanding Data Segmentation

Using quick analysis for efficiently interpreting data

Streamlining analysis with the quick analysis tool
Improving visual appearance of forecast charts
Craft dynamic charts for data insights
Using instant totals application for quick summaries
Improve data structure with tables
Identifying trends with sparklines
Creating histograms
Plotting a moving average

Improving decision-making with Excel what-if analysis

Navigate decision scenarios using what-if analysis
Craft and evaluate scenarios for strategic planning
Dynamically visualize alternatives with data tables
Achieve precision with the goal seek function

Using Excel Solver to optimize decision making

Understanding solver's capabilities
Define and solve complex problems with solver
Apply solver to budgeting decisions
Using solver for planning and projections
Optimize product mix with solver insights
Conduct comprehensive what-if analysis using solver

Smart data management with Excel power query editor

Streamline data gathering with power query editor
Append and merge data for holistic insights
Transform data dynamically for optimal analysis

Improving analysis with the Excel data model

Understand the Excel data model
Efficiently retrieve and link data
Leverage the data model for strategic analysis
Craft intelligent calculated columns
Elevate analysis with dynamic measures
Visualize success using key performance indicators (KPIs) and objective and key results (OKRs)

Essentials of Data Analysis in Excel

Understanding Measures of Central Tendency, Position, and Dispersion
The Normal Bell Curve (20 min)
Using descriptive statistics
Working with T-Tests

Using Excel for Predictive Analytics

Determining a correlation
Understanding regressions and performing regression analysis
Working with linear regression
Using multiple regression

See all Excel classes

Why Excel classes at AGI are the best option for you

Hands-on learning: Learn Excel quickly with our proven teaching methods.
Exceptional curriculum: AGI has delivered Excel training to thousands over 25 years.
Expert instructors: Our instructors are Excel experts and skilled educators.
Small class sizes: Receive personalized attention with 10 or fewer participants per class.
Repeat for Free: If you need a refresher or miss a class day, retake the Excel class at no cost.

American Graphics Institute

All Excel classes include