Microsoft Office Tutorials and References
In Depth Information
Assign the name to the range that begins and ends with the border
rows in the Name column. In Figure 7-2, this range is defined as:
To assign this name and the adjacent names easily, select the
range B3:D114 and choose Insert, Name, Create. In the Create
Names dialog, ensure that only Top Row is checked.
When you create reports, it’s often convenient to look up the
description of the GL account number you use. This column allows
you to do that. This column also labels the GL accounts to make
them easier to work with when you build your reports.
In Figure 7-2, the Desc range is defined as: =Month!$C$3:$C$114.
Notice in the figure that I didn’t bother to enter Desc values for the
labels in rows 111 and 112. You could enter such labels if you want
The data in most General Ledgers is designed so that the sum of
debits and credits equals zero. That is, debits are stored as positive
numbers and credits are stored as negative numbers. You’ll find it
useful to follow the same convention in the ActGL.xls workbook.
If you follow this convention, however, you need an automatic way
to convert the sign of your data when you create reports. The Sign
column in Figure 7-2 achieves this purpose. Here, all accounts with
a natural debit balance have a value of 1, and all accounts with a
natural credit balance have a value of minus 1. You’ll soon see how
we use this information in our reports.
In Figure 7-2, the Sign range is defined as: =Month!$D$3:$D$114.