Sales and Market Forecasting for Entrepreneurs

Chapter 10

Spreadsheet Tips and Traps

It’s not that the subject of this book is spreadsheet work, rather than sales forecasting. However, since the daily work and nuts and bolts of sales forecasting tends to be with spreadsheets, it’s hard to imagine this book without this chapter. Let’s look at some specific spreadsheet fine points that will help. I’m going to try to put this in the same order these fine points appeared in the book, by referencing the figures in which they first come up.

Referencing an Entire Row With a Single Cell

This comes up first in Figure 2.2, showing a simple sales forecast including units and price per unit. I use it a lot. I’m lazy, so I like to set up my spreadsheet to automatically repeat the price I type into the ...