Excel Data Analysis: Forecasting Training Video
Duration: 3h 7m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 48KHz 2ch | 818 MB
Genre: eLearning | Level: Appropriate for all | Language: English
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:

Descriptionting 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


Kod:
rapidgator_net:
http://rapidgator.net/file/01850e60f6f53b819ffcbbf9a6ed9e4d/wjrr6.Excel.Data.Analysis.Forecasting.Training.Video.part1.rar.html
http://rapidgator.net/file/94ab1c6adf2f88232fe6b47e2e9a1417/wjrr6.Excel.Data.Analysis.Forecasting.Training.Video.part2.rar.html

nitroflare_com:
http://nitroflare.com/view/BB19BF1AF21AAD4/wjrr6.Excel.Data.Analysis.Forecasting.Training.Video.part1.rar
http://nitroflare.com/view/C7C69C7DEE78FEC/wjrr6.Excel.Data.Analysis.Forecasting.Training.Video.part2.rar

uploaded_net:
http://uploaded.net/file/lose1e6l/wjrr6.Excel.Data.Analysis.Forecasting.Training.Video.part1.rar
http://uploaded.net/file/3u0t1cdb/wjrr6.Excel.Data.Analysis.Forecasting.Training.Video.part2.rar