Lynda - Excel Data Analysis Forecasting[TutDownload]

seeders: 9
leechers: 22
Added on September 26, 2014 by kytoroin Other > Tutorials
Torrent verified.



Lynda - Excel Data Analysis Forecasting[TutDownload] (Size: 809.71 MB)
 00_01-welcome.mp44.26 MB
 00_04-exercisefiles.mp43.37 MB
 00_03-whatknow.mp43.15 MB
 00_02-whofor.mp42.75 MB
 00_05-Challenges.mp42.49 MB
 01_07-movingaverage.mp414.27 MB
 01_05-seasonality.mp412.01 MB
 01_03-level.mp411.15 MB
 01_02-plotting.mp47.83 MB
 01_06-noise.mp47.39 MB
 01_04-trend.mp46.6 MB
 01_09-solution.mp46.4 MB
 01_01-timeseriesdata.mp45.6 MB
 01_08-challenge.mp41.4 MB
 02_03-MAPE.mp425.7 MB
 02_01-accuracybias.mp420.97 MB
 02_02-MAD.mp418.17 MB
 02_06-advancedbias.mp417.83 MB
 02_05-bias.mp415.85 MB
 02_04-SSE.mp412.46 MB
 02_08-solution.mp412.29 MB
 02_07-challenge.mp41.72 MB
 03_05-autocorrelation.mp431.92 MB
 03_04-standarderror.mp429.92 MB
 03_03-Rsquare.mp422.05 MB
 03_01-trendline.mp414.07 MB
 03_07-Solution.mp413.73 MB
 03_02-intreprettrendline.mp48.72 MB
 03_06-Challenge.mp41.64 MB
 04_02-exponential.mp426.34 MB
 04_01-lineartrendfails.mp425.37 MB
 04_03-CAGR.mp413.03 MB
 04_05-solution.mp46.3 MB
 04_04-challenge.mp41.75 MB
 05_06-forecastingahead.mp423.49 MB
 05_01-seasonalindex.mp420.94 MB
 05_04-indices.mp420.19 MB
 05_03-CMA.mp419.15 MB
 05_07-trendchanging.mp414.65 MB
 05_05-trend.mp49.7 MB
 05_02-ratiotoMAintroduction.mp48.11 MB
 05_09-solution.mp47.75 MB
 05_08-challenge.mp41.58 MB
 06_07-validating.mp444.01 MB
 06_04-findingEquation.mp442.79 MB
 06_02-preparingdata.mp442.04 MB
 06_01-whatis.mp428.46 MB
 06_05-howgood.mp426.31 MB
 06_10-solution.mp422.55 MB
 06_06-makingforecasts.mp420.74 MB
 06_08-coefficents.mp420.51 MB
 06_03-running_regression.mp411.78 MB
 06_09-challenge.mp43.11 MB
 07_01-nextsteps.mp412.28 MB
 Ex_Files_ExcelDataAnalysis_Forecst.zip1.04 MB
 please support me.txt613 bytes


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

torrent name size seed leech

Sharing Widget


Download torrent
809.71 MB
seeders:9
leechers:22
Lynda - Excel Data Analysis Forecasting[TutDownload]

All Comments

Great stuff , This what Im looking for

Thanx.
This is my happiness