Excel Data Analysis Forecasting Training video

[caovantan 42]

 

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

 

Download link:

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.

 

Links are Interchangeable - No Password - Single Extraction