Learn everything about Analytics

Excel Data Analysis: Forecasting – Lynda

0-6 Month Online
Intermediate Contact Institute
Online Business Intelligence
Online Self Paced 2676

[su_tab title = “Description”]

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.

[su_tab title = “Program Structure”]

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


INR 15, 00 (assuming $ = INR 60)


3 hour 7 minutes

[su_tab title =”Tools”]

  • Excel

[su_tab title = “Contact”]

Name :
Email :
Contact Number :
Message :
Code :




This article is quite old and you might not get a prompt response from the author. We request you to post this comment on Analytics Vidhya's Discussion portal to get your queries resolved