Microsoft Excel

Microsoft Excel is a powerful tool to manipulate and store data. Workbook and worksheet are basic building blocks of Microsoft Excel. There is a difference between a workbook and a worksheet. An Excel file where a user can enter and store data is called a workbook. It has file extension .xls. A workbook can contain multiple worksheets. A worksheet is a single page within a workbook. A worksheet is composed of cells where the data is entered.

Using multiple worksheets within one single workbook can help keep a complex project with lots of information carefully organized. It will also ease the navigation within the workbook and save time. For example, while working on a design project of a residential space all the information can be divided between the worksheets according to the area within the space: sleeping area, eating area, living area etc. Another example is structuring personal budget and keeping track of all the bills. Multiple worksheets can be used for travel expenses, shopping, rental payment, bills etc.

While working with multiple worksheets cross-referencing data might be very helpful. To make a simple reference to a cell from another worksheet within the same workbook use the following formula: =+INDIRECT( "A1"). This formula can be added into other formulas like =SUM(number1,number2, ...)

However, a single worksheet can be the best way of calculating expenses for a particular occasion such as a birthday party. In a professional environment small and simple projects can be organized on one worksheet.

References

Bott, E., Leonhard, W. (2004). Special Edition Using Microsoft Office 2003. Canada: Que Publishing.

While working with multiple worksheets cross-referencing data might be very helpful. To make a simple reference to a cell from another worksheet within the same workbook use the following formula: =['name']name!A1, where name is the name of the worksheet data is referenced from. This formula can be added into other formulas like =SUM(number1,number2, ...)

However, a single worksheet can be the best way of calculating expenses for a