Creating Balance Sheet using Pivot Table operation pg 57 58

Creating 'Balance Sheet Report Using PivotTable Operation

An alternative way to create a Balance Sheet report is by using Pivot Table operation.

We will use data in sheet TB to build a Balance Sheet report using a PivotTable operation. More specifically, we will use 2 columns i.e. BALANCE SHEET MAIN CATEGORY and RM-NET. The PivotTable operation will summarise each unique item in the column BALANCE SHEET MAIN CATEGORY with its corresponding total.

The advantage of using the PivotTable operation is that you can build and then delete the report sheet. The disadvantage is you cannot rearrange the position of items in the report produced.

57
Here are the steps to create a Balance Sheet report using Pivot Table operation:

1 Select any filled cell in the sheet TB

2 Click menu Data/PivotTable and PivotChart Report

3 A dialog titled PivotTable and Pivot Chart Wizard Step 1 of 3 will appear

3a Under label Where is the data that want to analbant

External data sarce
CMALNrokatten shpes
what kiest of meort de you want to eas
Cancel

4. Under the Where is the data that you want to analyze? label, select Nicrosoft Excel list or database.

5. Under What kind of report do you want to create? label, select PivotTable

6. Click Next.

7

A dialog titled PivotTable and pivot Chart Wizard Step 2 of 3 will appear

58