Initial Sheet in the file (workbook)

- Open a new workbook (This will automatically create a blank workbook).

- Save the new workbook. In the process of saving a new workbook, you will be asked to give a name for the workbook. Give the new workbook a suitable name that reflect what data it will contain. For example, if the name is "AccJan2012.xls" it will contain accounting data for January 2012.

Other than name, you also be asked to state or select which folder you want to put the workbook.

A workbook is same as a file.

A workbook (or a file) consist sheet. Initially you are provided with one sheet. You can add more sheet or delete sheets.

A sheet consist of rectangular boxes. You write into these boxes.

When you firstly open the new file, initially, there is only one sheet in the new file that you have just created.

In Excel, sheet is also called worksheet.

Rename the sheet as : DATA. (This name is used throughout this book and in formulas in the file. Do not use other name unless you are aware of the effect).

Later, when you have more sheets, you can arrange the sheets in any order.

Sheet DATA will contain all your raw transaction data (such as opening balances, sales, purchases, receipts, payments, journals, etc).

TIP Usually we use the mouse to move from sheet to sheet by clicking the intended sheet. You can use a combination of keyboard keys, instead. Use Ctrl+Page Down to move to the sheet on the right (Hold down the Ctrl key, and press the Page Down key. The next sheet will become active.). Use Ctrl+Page Up to move to the sheet on the left. By depending less on the mouse, you can speed up your work, but this requires a good memory.