Back to top



Predictive Analytics with Excel

Carlberg, Conrad.
Overview In just three hours, discover how to create accurate forecasts and predictions with Microsoft Excel's powerful predictive analytics tools! Description Moneyball made predictive analytics famous: now, you can put it to work! In just three hours of expert video, Conrad Carlberg will teach you all the core skills you need to create accurate predictions of your own with Microsoft Excel-hands-on! Learn how to use Excel to design and run the two most basic analyses used in quantitative forecasting: smoothing and regression. Explore the self-correcting nature of exponential smoothing, discover how to use autoregression to create effective forecasts, and get comfortable using Excel's powerful Data Analysis and Solver add-ins. Understand trends in time series, and master differencing, the most important technique for dealing with them. Finally, learn about ACFs and PACFs, and uncover their patterns to identify the best ways to forecast any given time series. These hands-on videos are accompanied by Excel workbooks containing all sample data and analyses: workbooks you can easily replicate and adapt for your own needs! About the Instructor Conrad Carlberg is a multiple recipient of Microsoft's Most Valuable Professional (MVP) award for Microsoft Excel. He has written twelve books about quantitative analysis with Excel, including Predictive Analytics: Microsoft® Excel . As President of Network Control Systems, Inc., he leads the development of quality control and forecasting tools for the health industry. Carlberg holds a Ph.D. in statistics from the University of Colorado, and has 25 years' experience applying advanced analytical techniques. Skill Level All Levels Beginner Intermediate Advanced What You Will Learn The essentials and basic terminology of predictive analysis How to use Excel's core predictive analysis tools, including the Data Analysis and Solver add-ins How to perform quantitative analyses using smoothing and regression How to create effective forecasts using autoregression How trends in time series work, and how to handle the challenges they create How to choose the best approach to forecast any time series Who Should Take This Course Every businessperson, scientist, analyst, and student who wants to master the essentials of predictive analytics Course Requirements Basic experience with Microsoft Excel Basic knowledge of simple statistical analysis techniques Table of Contents Introduction Part 1: Moving Averages Lesson 1: Leng...

Availability by Location

HCPL eBranch
Shelf Location
HCPL O'Reilly Online
Item ID
Call Number
gm a0u a

Additional Info


Publication Year
1 online resource (1 video file, approximately 3 hr., 12 min.)