2 hours Live Training on Forecasting and Predictive Analytics with Excel

Learn to create your own forecast in Excel and generate Predictive Analytics In Excel. This course is all about predictions! We'll dive into forecasting using with Excel.
Duration: 1 Day
Hours: 2 Hours
Training Level: All Level
Virtual Class Id: 50153
Recorded
Single Attendee
$199.00 $332.00
6 month Access for Recorded
Have Any Queries

Call Us : +1-888-880-0589

support@virtualtrainings.com

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.

Who is the Excel for Forecasting and Prediction Course Target Audience?

  • Accountants, Accounts, Audit
  • Aviation
  • Banking, CFOs
  • Controllers, CPAs
  • Education
  • Energy
  • FDA
  • Finance, Financial consultants
  • Human Resource
  • Insurance
  • Investments
  • IT
  • Logistics & Supply Chain
  • Marketing
  • Medical Devices
  • Pharmaceutical
  • Retail, Sales
  • Telecom

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.

Curriculum
Total Duration: 2 Hours
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