Lynda - Excel Data Analysis: Forecasting {AceMerlin}seeders: 28
leechers: 8
Lynda - Excel Data Analysis: Forecasting {AceMerlin} (Size: 296.48 MB)
Description
Excel Data Analysis: Forecasting with Wayne Winston 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. Level: Intermediate Length: 3h 7m Released: September 5, 2014 Topics include: 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 Uploaded by Request Related Torrents
Sharing WidgetAll Comments |
waiting for the next one