Introduction to Microsoft 2003 Excel

1. Introduction to Microsoft 2003 Excel Computer Training Lab Presentation Created by Donna Kemp

2. OLD WAY - SPREADSHEET Typerwriters Filing Systems Pencils Paper Folders

3. What is Microsoft Excel • Electronic grid made up of rows and columns where you can perform numeric calculations and formulas • Mathematical tool which is formatted in columns and rows to display numerical data • Accounting • Data Analysis • Scientific Formulas • Can display • Calculations • Charts • Reports • Analytical functions • Almost unlimited entries

4. Open Microsoft Excel • Start • ALL PROGRAMS • MICROSOFT OFFICE • MICROSOFT EXCEL 2003 Or • Look for the Microsoft Excel Shortcut on your Desktop

5. Microsoft Excel Workbook Menu Bar Tool Bar Name Box Columns (Vertical) Column Headers Formula Box Rows (Horizontal) Row Headers Cell Worksheet tabs

6. Exercises 1 • Open Microsoft Excel Application • Save and Rename Microsoft Excel Book 1 • Olympic Village Flower Restocking • Column headers • Cell A1 enter American House Red/White/Blue Carnations • Cell B2 enter House 101 • Cell C2 enter House 102 • Cell D2 enter House 103 • Cell E2 enter House 104 • Row headers • Cell A3 enter Floor 1 • Cell A4 enter Floor 2 • Cell A5 enter Floor 3 • Cell A6 enter Floor 4

7. Exercise 1 - completed

8. Exercise 2 • Merge cells A1 thru E1 into one cell • Change font color to RED and BOLD • Center Header • Enter the following data: • Cell B3500, cell C320 • Cell B4375, cell D4300, cell E4550 • Cell C5125 • Cell C675, cell D6550, cell E62050

9. Exercise 2 - completed

10. Exercise 3 • Formatting • Center data in columns • Right alignment data • Left alignment data • Formatting Numbers • Borders • Simple Functions (formulas) • Adding

11. Exercise 3 - completed