Excel Data Analysis: Forecasting

Start my 1-month free trial
  • Course details

    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.


    • Click here to view Wayne Winston’s instructor page

      Wayne Winston

      Professor and Higher Education Consultant

      Wayne Winston is the professor of decision sciences at Indiana University's Kelley School of Business.

      He has won over 30 teaching awards, including the John and Esther Reese Professorship, and written over 20 journal articles and 15 books. His most recent book, Mathletics, explains the use of mathematics by professional sports teams and gamblers. Wayne has consulted for many organizations including the Dallas Mavericks, USA Diving, Cisco, Microsoft, US Army, Eli Lilly, Diamond Consulting, Tellabs, and Medtronics. He has also developed online spreadsheet modeling and mathematics courses for Harvard Business School Publishing. Finally, Wayne is a two time Jeopardy! champion.

    Skills covered in this course

    For each course you will get

    • Exercise files and quizzes
    • Certificate of completion from LinkedIn
    • Offline and audio-only options
    Start my free month
  • Welcome

    - [Voiceover] Hi, I'm Wayne Winston. In this course I'll be showing you how to create and evaluate forecasts. We'll start by exploring the nature of time series data with scatter plots and moving average plots. Then we'll examine data bias and accuracy using methods including mean apps through deviation and sum of squared errors. Next we'll try out trend lines for forecasting. Then we'll model exponential growth, and compute CAGRs or compound annual growth rates. And finally, I'll help you understand seasonality of data and how to forecast with multiple regression. So roll up your sleeves and let's get ready to learn a lot about forecasting.

  • Practice while you learn with exercise files

    Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.

    Download the exercise files for this course. Get started with a free trial today.

  • Download courses and learn on the go

    Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.

    Watch this course anytime, anywhere. Get started with a free trial today.