xREL.v3

QUASAR PROUDLY PRESENTS

Excel Data Analysis: Forecasting
(c) Lynda.com

Supplier . : QUASAR       Size ..... : 13 x 50MB
Cracker .. : QUASAR       Protection : Condom
Packager . : QUASAR       Type ..... : Brain Enhancement
Date ..... : 09-05-2014   OS ....... : Win/Mac

Excel Data Analysis: Forecasting
with Wayne Winston

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

INSTALLATION

Unpack, burn or mount and enjoy.

GREETINGS

We salute our friends, our loyal members and our fair competitors.

THE ALMIGHTY QUASAR   2014