About Forecasting in Excel and Predictive Analytics in Excel
In this practical and interactive webinar, you will work along with the instructor. As you progress through the provided spreadsheet of exercises, you will learn how to use Excel for forecasting and prediction. You will be introduced to the concepts of correlation, simple linear regression, the Excel Trend Curve, Excel Forecast Sheet, exponential smoothing, and multiple regression
.
Forecasting in Excel and Predictive Analytics in Excel Course Objective
Organizations need accurate and unbiased forecasting for budgeting and inventory control. In this course you will master Excel’s exciting forecasting tools.
What Basic Knowledge Required to Learn Predictive Analysis in Excel?
This is an intermediate level class. Attendees should be familiar with Excel and use it on a regular basis, at least weekly.
Forecasting in Excel and Predictive Analytics in Excel Course Curriculum
The computation and meaning of correlation
Simple linear regression via the Trend Curve and Analysis Toolpak
Prediction with the exponential curve and power curve
Extrapolation forecasting with the Forecast Sheet
Multiple Regression with the Analysis Toolpak
Agenda
The computation and meaning of correlation
Simple linear regression via the Trend Curve and Analysis Toolpak
Prediction with the exponential curve and power curve
This product gives access to the selected training webinar. Please select an access option from the list below. This product gives access to the selected training webinar. This is a single delegate licence. This allows access for one delegate. The recorded webinar can be accessed through a secure website. Username and password will be sent via email.
