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 ...
Get Sales and Market Forecasting for Entrepreneurs 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.
