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.
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.Course Content
- 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
