Trial Balance

	A	B	C
1	ACCOUNTS	RM
2
3
4
5
6
7
8
9
10

Notes :
- One Trial Balance for 1 year of financial transactions data.
- In this book, the sheet that contain the Trial Balance is named TB.
- The name TB used throughout this book refers to the Trial Balance.
- The name TB used in any functions parameters refers to the Trial Balance.
- The structure in the sheet TB is as above.
- About the structure and how to fill the structure :
- Row 1 contains the data titles.
- Data must start from row 2.
- No blank cell between the titles in row 1.
- No blank cell between the row in column A.
- The data area of the TB begin from row 1 to any filled row.
- A blank row below the data area will be treated as the bottom border.
- The right border of the data area is column C.
- Fill cells in column ACCOUNTS with name of all Accounts name.
- The spelling of an Accounts name in column ACCOUNTS must be the same with the spelling of the Accounts name available in column ACCOUNTS in sheet "Transactions".
- Fill cells in column RM with total RM of an Accounts in sheet "Transactions". - Total RM is extracted from column RM in sheet "Transactions" using function SUMIF.
- Example of usage of SUMIF function is : .....
- A change in content of a cell in Transaction sheet automatically uodate relevant cell in sheet TB.
- To go to the most bottom row of the data area ....
- To check that the TB is balance ...
- To remove the unuse column (to conserve memory) is ...