.· ░░░ ·■. ▀ ▓▄■ ■ ▄░ ■▄░ ▀▄ zk ■
▄▓█████▓▄ ▀▄ · ▄▓ ▄███▄░ ▄▄▄▄████ ░▄███▄ ▀▓█▄▄▄▄▄▄░ ·
████▀▀▀███▄ ██▄ ▄██ █████████▄ ▒█████▀▀██ ▄█████████▄ ██████████▄
▒███ ▓██░███ ███ ▓██▀ ▀██▓ ▓██▓ ▓██░███▀ ▓███ ███ ▀██▓
▓███ ▓██▓███░ ███░███░ ▓██░███░ ▄██▀ ██▓ ░███░███ ▓█▓
▓███ ▓██████░ ███████ ▀██████ ▀ ██▀ ███▓███░ ▄▓█▓
▓██▓ ███████░ ████████████████████████████████████████████████▀▀
▒██▓ ░▄ ███▓███░ ███░██▀▀▀▀▀▀▀██▓▀▀▀▀▀▀▀▀███▓██▀▀▀▀▀▀▀██▀███▀▀▀▀███▄
███▄ ▓█▄███░███░ ███░███░ ▓██░ ▄▄▄■ ███░██▓░ ░███ ▓██ ███░
▀█████████░ ███▓░ ▄███ ██▀ ▀██ ███ ░██▓ ██▀ ▓██ ▓██ ▓██▓
▀▀▓▓░███▄ ▀█████████▀ █▀ ▀█ ████▄▄▄███▒▄▀ ▀█▓███ ░███
▀██▄ ▀▀▓▓░▀▀ ▀ ▀ ▀▀█████▀▀ .░ ▓██
▀ .· ▄█▀
▀ ▀
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 ··· ░▓██████████████▓░
· ───────────────────────────────────────────────────────────────────────── ·