Search Activities

Excel Data Analysis: Forecasting

Description
Professor Wayne Winston has taught advanced forecasting techniques to Fortune 500 companies for more than twenty years. 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.
Activity ID
100020003054
Duration
3.00 Hours
Language
English
Activity Type
Course or Training
Customized Training
No
Provider
Lynda.com (LinkedIn Learning)
Provider Contact
Megan Russell
+1805 755-1880 (phone)
+1805 684-5900 (fax)
ldc-projectmanagement@linkedin.com
Website
http://www.linkedin.com/learning/
Professional Development Units
  • Technical
    0.00 PMI-ACP®
    0.00 PfMP®
    0.00 PMI-PBA®
    0.00 PMP®
    0.00 PgMP®
    0.00 PMI-SP®
    0.00 PMI-RMP®
  • Leadership
    0.00 PMI-ACP®
    0.00 PfMP®
    0.00 PMI-PBA®
    0.00 PMP®
    0.00 PgMP®
    0.00 PMI-SP®
    0.00 PMI-RMP®
  • Strategic & Business
    3.00 PMI-ACP®
    3.00 PfMP®
    3.00 PMI-PBA®
    3.00 PMP®
    3.00 PgMP®
    3.00 PMI-SP®
    3.00 PMI-RMP®
More Information about Lynda.com (LinkedIn Learning)

Activity Content

Audience Level
Mixed
Learning Objectives
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

Contact Information for this Activity

Contact Name
Jolie Miller
E-mail Address
projectmanagement@lynda.com
Phone
805-755-1731
Fax
Not provided

Locations, Dates and Times (2)