Excel Forecasting and Data Analysis
- At the end of this course you will understand how you can forecast in Excel using different methods based on seasonal, linear or exponential data. You will be able to calculate forecast errors to update your forecast model to assure more accurate forecasts. You will able to do trend analysis, break-even analysis, calculate correlation coefficient and creating statistical analysis using Excel's analysis toolpak.
You will also be able to clearly visualise trends and forecasts in Excel charts.
This course is a part of a wider portfolio of our Excel software training courses.
What to expect
- 24 months post training support included .
- Tailored and bespoke programme options .
- Our experienced training and logistics team in the last 23 years have assisted 204,432 people .
- Over 14,060 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.8% of our customers recommend us .
- Delivery UK wide and international (75+ countries delivered) .
Suitability - Who should attend?
This Microsoft Excel Forecasting and Data Analysis course is aimed at people who want to expand their knowledge into forecasting and more specialised analytical functionality offered by Microsoft Excel.
Learn more about the Excel training spreadsheet.
Training Course Content
Plan a forecast Model
Which data can be forecasted?Set up the source data the right way to get an efficient model
Decide which method is the right for your data or should I use more methods?
How can I measure the accuracy of the forecast?
Which measurement method is the best for my data?
How can I track that I am using the right forecasting model over time
Maintenance of the forecast models
Forecasting Methods
Linear RegressionForecast Function
Trend Function
Slope and Intercept Function
Exponential Regression
Growth Function
Exponential Smoothing
Data Analysis Tool Exponential Smoothing
Naïve Forecast
Moving Average
Data Analysis Tool Moving Average
Seasonal Forecasting
Measuring Forecast Accuracy
Forecast Error/DeviationForecast Absolute Error/Deviation
Forecast Percentage Error/Deviation
Forecast absolute percentage error/deviation
Square Error
Standard Error
MAD (Mean Absolute Deviation)
MSQ (Mean Square Error)
MPE (Mean Percentage Error)
MAPE (Mean Absolute Percentage Error)
TSE (Tracking Signal Error)
Using the solver to optimise forecasts
Optimise Exponential Smoothing ForecastsOptimise Weighted Moving Average Forecasts
Optimise Seasonal Forecasts
Trends and forecasting using charts
Chart TypesTrendlines
Equations
R2
Visualise Forecasts and Forecast accuracy
Comparing Forecasting Methods and Models
Accuracy and visualisationManipulate Forecasts using What-If Analysis
Scenarios ManagerGoal Seek
Data Tables
Correlation Coefficient
Correl FunctionThe Data Analysis Tool Correlation
Display Correlation Coefficient in Scatter Chart
Break-Even Analysis
Break-Even ModellingCalculate Break-Even
Visualise Break-Even
Use Goal Seek to analyse Break-Even
Data Analysis Tools
Descriptive StatisticsHistogram
Regression
Sampling
Rank and Percentile
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads