Who`s online

Welcome to Warezluan website.
» » Excel Data Analysis: Forecasting
Other Tutorials

Excel Data Analysis: Forecasting

Author: upload113 Date: 30-09-2017, 00:17 Comments: 0 Views: 25
Excel Data Analysis: Forecasting
Excel Data Analysis: Forecasting
MP4 | Video: 720p | Duration: 3:07:01 | English | Subtitles: VTT | 506.5 MB

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.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.

The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.

Topics include:
Descriptionting and displaying time-series dataCreating a moving average chartAccounting for errors and biasUsing and interpreting trendlinesModeling exponential growthCalculating compound annual growth rate (CAGR)Analyzing the impact of seasonalityIntroducing the ratio-to-moving-average methodForecasting with multiple regression
Download link:

Links are Interchangeable - No Password - Single Extraction

Comments to article
Add comment

Bold Italic Underline Strike | Align left Center Align right | Insert smilies Insert link URLInsert protected URL Select color | Add Hidden Text Insert Quote Convert selected text from selection to Cyrillic (Russian) alphabet Insert spoiler
Enter code: *


TOP users