Excel Forecasting and Data Analysis​

This Microsoft Excel Forecasting & Data Analysis course is aimed at people who want to expand their knowledge into forecasting and more specialised analytical functionality offered by Microsoft Excel.

Prerequisites

Completion of our Excel advanced course or equivalent knowledge.

Excel Forecasting and Data Analysis​

This Microsoft Excel Forecasting & Data Analysis course is aimed at people who want to expand their knowledge into forecasting and more specialised analytical functionality offered by Microsoft Excel.

Prerequisites

Completion of our Excel advanced course or equivalent knowledge.

Benefits

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.

Benefits

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.

Our Popular Courses