Creating Trial Balance using PivotTable operation page 52

Creating Trial Balance' Report Using PivotTable Operation

An alternative way to build a Trial Balance is by using PivotTable function. Follow these steps:

1. Click any non-empty cell in the data area in sheet DATA. (Make sure data is not filtered.)
2. Click menu "Data/PivotTable and PivotChart Report".
3. A dialog titled "PivotTable and PivotChart wizard Step 1 of 3" will appear (Refer to page 60).
4. Under the label "Where is the data that you want to analyze", select "Multiple consolidation ranges". This is because we are going to consolidate or merge unique items from multiple columns (ACCOUNTS-DEBIT, RM-DEBIT, ACCOUNT CREDIT and RM-CREDIT) into one list.
5. Under the label "What kind of report do you want to make", select "PivotTable".
6. Click Next.
7. A dialog titled "PivotTable and PivotChart wizard Step 2a of 3" will appear.
8. Under the label "How many page fields do you want", select "Create a single page field for me".
9. Click "Next" button.
10. A dialog titled "PivotTable and PivotChart wizard Step 2b of 3" will appear.
11. Under the label "Range:", add 2 ranges namely DATA!$G$4:$H$30000 and DATA $I$4:$J$30000. (30000 is the last row in the author's sample data. Change it to your own last row for your data in sheet DATA).

Notice that the first range consists of 2 columns i.e. ACCOUNTS-DEBIT (column G) and RM-DEBIT (column H). Notice also that the second range consists of 2 columns i.e. ACCOUNTS-CREDIT (column I) and RM-CREDIT (column J).

52