Lynda - Excel Data Analysis Forecasting[TutDownload]seeders: 9
leechers: 22
Lynda - Excel Data Analysis Forecasting[TutDownload] (Size: 809.71 MB)
Description
Author: Wayne Winston Subject: Business, Data Analysis Software: Excel 2013 Level: Intermediate | Duration: 3h 7m | Released: Sep 05, 2014 Homepage: http://www.lynda.com/Excel-tutorials/Excel-Data-Analysis-Forecasting/153775-2.html 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. 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 Related Torrents
Sharing WidgetAll Comments |
Thanx.