Learn everything about Analytics

Excel Data Analysis: Forecasting – Lynda

Lynda
0-6 Month Online
Intermediate Contact Institute
Online Business Intelligence
Online Self Paced 1213
Rate this post
DescriptionProgram StructureToolsContact

In this course, he shows how to use Excel’s data-analysis tools—including charts, formulas, and functions—to create accurate and insightful forecasts. Learn how to display time-series data visually; make sure your forecasts are accurate, by computing for errors and bias; use trendlines to identify trends and outlier data; model growth; account for seasonality; and identify unknown variables, with multiple regression analysis. A series of practice challenges along the way helps you test your skills and compare your work to Wayne’s solutions.

Course Program:

  • Plotting and displaying time-series data
  • Creating a moving average chart
  • Accounting for errors and bias
  • Using and interpreting trendlines
  • Modeling exponential growth
  • Calculating compound annual growth rate (CAGR)
  • Analyzing the impact of seasonality
  • Introducing the ratio-to-moving-average method
  • Forecasting with multiple regression

Fees:

INR 15, 00 (assuming $ = INR 60)

Duration:

3 hour 7 minutes

  • Excel
Name :
Email :
Contact Number :
Message :
Code :

 

 

Leave A Reply

Your email address will not be published.

Join 50,000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:




 P.S. We only publish awesome content. We will never share your information with anyone.