All the figures are typed straight into the newly named spreadsheet
('Raw Numbers') - the
CELL name (e.g. B4) is automatically generated as you begin to type the
word "Sales" into that cell - i.e. it knows where you are on the
sheet!
It is wise to SAVE your work after every few entries.
To do this click on
the FLOPPY DISC (it will say "Save" if you hover over it) symbol at the left
[3rd from] of
the actual EXCEL page Menu bar under the word Edit.
These figures show that this operation has a deteriorating monthly Pre-tax
$ profit, however, the figures, as they
appear, do not really give us much of a clue as to why or how this
happened. Nor do they allow us to compare the rate of change
across all parts of the Profit & Loss report.
Numbers only represent the underlying activity! It
is the activity itself we must understand.
The 'copy' of this table seen on the next page has firstly had
the six months
total added across to a new column.
TO DO THIS EXERCISE, SET OUT YOUR SHEET AS ABOVE |