Getting Started

NumXLⁱ is a suite of time series Add-ins for Microsoft Excel. Once loaded, NumXL integrates scores of time series functions, along with a rich set of user interfaces and tools to assist in your data analysis.

This document is prepared as a self-study course; it is divided into eight(8) separate modules organized in terms of relevance (and to some extent, difficult):

• Module 1: Data Preparation
• Module 2: Descriptive Statistics
• Module 3: Time Series Smoothing
• Module 4: Correlogram Analysis
• Module 5: Modeling
• Module 6: Calibration
• Module 7: Residuals Diagnosis
• Module 8: Forecast

The purpose of these modules is to demonstrate the basic steps in conducting your own time series analysis, diagnosis, and forecast, using only NumXL’s functions and tools.

Feel free to start at any point in the course, but bear in mind that the examples build on each other from one module to the next.

Getting Started with NumXL is designed as a self-study course. We are constantly working on improving it, so we invite comments, suggestions, and criticisms.