All Excel classes include
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Excel Course Online April 22, 2024 Forecasting
Excel forecasting course
$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
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.