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
-
Ishmael
QuickBooks certification
10 daysAll levels12 lessons0 quizzes1 student"QuickBooks Training" on real company files under the supervision of qualified accountants. Do you want to…£650.00£549.99