最新消息:请大家多多支持

Lynda – Excel Data Analysis: Forecasting

其他教程 dsgsd 179浏览 0评论


Lynda - Excel Data Analysis: Forecasting

Lynda – Excel Data Analysis: Forecasting | 818MB

Duration: 3h 07m | Video: AVC (.mp4) 1280×720 15&30fps | Audio: AAC 48KHz 2chGenre: eLearning | Level: Intermediate | 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.
Lynda - Excel Data Analysis: ForecastingLynda - Excel Data Analysis: Forecasting

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


Download 百度云

你是VIP 1个月(1 month)赞助会员,

资源下载此资源仅限VIP下载,请先

转载请注明:0daytown » Lynda – Excel Data Analysis: Forecasting

您必须 登录 才能发表评论!