Microsoft Office Tutorials and References
In Depth Information
The account balances in column G of Figure 8-6 use a formula like
this:
G9:
=INDEX(ActGL.xls!DataYTD,$C9,MonthIndex)*$D9*Scale
The Scale value and the cell references are shown in Figure 8-6.
To display the Balance Sheet in the Report sheet, select the
shaded Balance Sheet area, click on the Camera tool, and click
anywhere on the Report worksheet. Doing so will paste a Camera
object of the Balance Sheet. Then position the balance sheet within
the Report. Chapter 6 explains the Camera tool in detail.
Create the Income Statement
Figure 8-7. The top of the worksheet that contains the income statement.
The formulas and procedure for creating the Income Statement are
virtually identical to that of the Balance Sheet.
Search JabSto ::




Custom Search