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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.