->
Lynda - Excel Data Analysis: Forecasting - 153775
Lynda - Excel Data Analysis: Forecasting
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.


Table of Contents

  • Introduction
  • 1. Visually Displaying Your Time-Series Data
  • 2. How Good Are Your Forecasts? Errors, Accuracy, and Bias
  • 3. Using a Trendline for Forecasting
  • 4. Modeling Exponential Growth and Compound Annual Growth Rate (CAGR)
  • 5. Seasonality and the Ratio-to-Moving-Average Method
  • 6. Forecasting with Multiple Regressions
  • Conclusion
  • Lynda - Excel Data Analysis: Forecasting


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss