Excel Data Analysis
Forecasting
Become a Corporate Financial Planning Analyst,
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.
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
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 3h 7m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Wayne Winston |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Data Science Business |
Tags | Data Analysis Business Microsoft Excel Forecasting |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Professor- Adjunct $23k
Material Followup Coordinator at GM Fort Wayne $48k
Occupational Therapists - (OT) Genesis/Macomb/Oakland/Wayne Counties $58k
Professor of Recreation $72k
Professor/ Poet $86k
Professor In Undergrad $101k
adj professor $112k
Chair & Professor $117k
Brand Marketing Manager - Wayne Dalton Manager $121k
Professor Titular $127k
Witing Professor $128k
Associate Professor 4 $140k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 3h 7m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Wayne Winston |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Data Science Business |
Tags | Data Analysis Business Microsoft Excel Forecasting |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course