Wednesday, July 20, 2011

Tutorial on Microsoft Excel 2003


1. Click 'Start,' 'All Programs,' 'Microsoft Office,' and then Microsoft Office Excel 2003. Excel 2003 will launch.
2. Click on any cell in the worksheet to select it.
3. Type numerical data or text in a selected cell and then press 'Enter' to enter information into the cell.
4. Click on the 'Sheet' tabs at the bottom of the window to work in different worksheets. Each sheet acts as its own separate workspace within the same Excel workbook.
5. Click on a cell, hold down the mouse button and then drag the mouse across the spreadsheet to select a block or range of cells. Selecting ranges of cells allows you to perform actions on all the cells at once. For instance, you can select a group of cells and then press 'Delete' to delete the data they contain.
6. Select a range of cells containing data, click 'Insert' and then 'Chart' to insert a graph. A chart creation wizard will appear. Select the chart type you want from the list, click 'Next' several times and then 'Finish.'
7. Select a cell by pressing the '=' button, type in a formula and then press 'Enter' to have the cell display the result of the formula. You can reference the values in other cells while entering a formula by clicking on the desired cell while entering the formula.
8. Hold down the 'Control' key and then press 'S' to save the current workbook. You will have to enter a name for the workbook and then click the 'Save' button when saving the project for the fist time.

Blogger news