Chapter 3

This chapter is about …

What spreadsheets are and what they can do. All of the principal facilities and functions needed to create and use the forecasting models in the book are explained here, with examples of their use. There is also a section of handy tips and shortcuts.

How to use the example files

This part of the book will introduce the practical use of spreadsheets. Where reference is made to one of the downloaded examples it is shown as EXnn, where nn is the example number. These relate to the numbers on the tabs at the foot of a spreadsheet.

Microsoft Excel™ is the spreadsheet we’ll use throughout the book and for the downloaded ...

Get Brilliant Budgets and Forecasts now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.