Browse » Home
Saturday, April 27, 2013
Step
1. Click the Windows 'Start' button, and select 'All Programs.' Click 'Microsoft Office,' then click 'Excel 2003.' The software opens on the computer to the main window. Excel automatically starts a new spreadsheet for you, if you want to create a new worksheet.
2. Click the 'File' menu item, then click 'Open.' The 'Open' dialog window lets you open an existing spreadsheet. Double-click an XLS file to load it in the Excel software, if you want to edit an existing spreadsheet.
3. Create the data in your spreadsheet. The type of data you enter into the spreadsheet is determined by what you intend to create. You can type text and numbers into the Excel cells. To create formulas, you must enter only numbers in a cell. For instance, if you want to make a spreadsheet of revenue, type 'Revenue' in the 'A1' cell. Excel marks each row with a number and columns with a letter, so 'A1' is the first cell on the spreadsheet.
4. Type your revenue data under the A1 cell. For instance, type '30' in A2 and '40' in A3. The following is what the spreadsheet should look like:Revenue3040
5. Create a formula to add the two revenue values. You can add two or several values in a formula. You prefix a formula with the equals sign. For instance, to add the two values typed in step four, type the following in A4:=sum(a2:a3)The formula above tells Excel to add cells A2 through A3. After you press 'Enter,' notice the value in the cell is the total sum of the two cells.
6. Highlight any cells you want to format. Click the 'Format' menu item, then click 'Cells.' A configuration window opens. The configuration window lets you set up the font, colors, background color, borders and alignment. Make you changes in the window and click 'OK' to see the changes.
7. Click the 'Save' toolbar button at the top of the window after you complete all of the spreadsheet changes. The file extension used for Excel 2003 is XLS. To open the file in the future, click 'File,' then view the files listed in the 'Recent' list. You can open the file using this method, if you forget the file name.