Introduction to Microsoft Excel

Duration: 1 day (6 hours)

Prerequisite(s): Familiarity with the Windows environment and using a mouse.

Environment: Microsoft Windows

Version(s): All through Excel 2003. Taught using Excel 2003.

Support: Upon completion of this seminar, the student will be entitled to unlimited, free telephone support in Excel.

Who Should Take This Seminar: Introduction to Microsoft Excel is designed to acquaint students with Microsoft's popular electronic spreadsheet program. No previous spreadsheet knowledge is necessary. Upon completion of this seminar the student will be able to create and edit spreadsheets incorporating numeric, text and formula entries, adjust the appearance of the spreadsheet, chart spreadsheet data, and print the spreadsheet and/or chart. Those uncertain whether this seminar is appropriate for them should call Systemetrics at (401) 275-2200.

1. Definition And Use Of An Electronic Spreadsheet
2. Excel Basics
1. Parts of the Excel screen
2. Specifications of an Excel workbook
3. Moving around the workbook
4. Making entries into the worksheet (constants and formulas)
5. Changing and editing entries
6. Using shortcut keys and shortcut menus
3. Creating An Excel Spreadsheet
1. Setting up the worksheet
2. Modifying the display of information
3. Adjusting column widths
4. Positioning data in cells
5. Using number formats (currency, commas, percentages, etc.)
6. Building formulas
7. Copying formulas, numbers, and text
8. Saving and opening workbooks
9. Enhancing the appearance of the worksheet
4. Tools to Enhance Workbook Development
1. The "Autos": AutoCorrect, AutoComplete, AutoFill, AutoCalculate, AutoSum
2. Understanding relative versus absolute cell addressing
3. Naming areas of the spreadsheet
4. Using multiple sheets to organize information
5. Creating Excel Charts (Graphs)
1. Using the Chart Wizard
2. Modifying a chart
6. Printing With Excel
1. Establishing print settings
2. Using Print Preview