Introduction to Microsoft Excel 2007

Duration: 1 day (6 hours)

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

Environment: Microsoft Windows

Version(s): Excel 2007. Not applicable to earlier versions of Excel.

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 2007 is designed to acquaint students with Microsoft's popular electronic spreadsheet program. This seminar applies specifically to Excel 2007 and should not be taken by students using previous versions of Excel. No previous spreadsheet knowledge is necessary. Upon completion of this seminar the student will be able to create and edit workbooks incorporating numeric, text and formula entries, adjust the appearance of the workbook, chart workbook data, and print the workbook and/or chart. Those uncertain whether this seminar is appropriate for them should call Systemetrics at (401) 275-2200, extension 121.

1. Excel Basics
1. Understanding the parts of the Excel screen
2. Understanding an Excel workbook
3. Moving around the workbook
4. Using Ribbons, Shortcut Menus, Shortcut Keys and Quick Access and Quick Format toolbars
2. Creating An Excel Spreadsheet
1. Making entries into the worksheet (numbers, text, and formulas)
2. Changing and editing entries
3. Modifying the display of information
4. Adjusting column widths and row heights
5. Aligning content in cells
6. Using number formats (currency, commas, percents, decimals, etc.)
7. Building formulas
8. Using the Sum button
9. Copying formulas, numbers, and text
10. Modifying Normal style
11. Working with range names
12. Saving and opening workbooks
13. Enhancing the appearance of the worksheet
3. Making the Spreadsheet Work Harder and Faster
1. Using the "Autos": AutoCorrect, AutoComplete, AutoFill, AutoCalculate
2. Copying groups of formulas, numbers, and text
3. Using relative versus absolute cell addressing
4. Naming areas of the spreadsheet
5. Using multiple sheets to organize information
6. Applying basic conditional formats with data bars
7. Working with multiple windows
4. Printing With Excel
1. Creating headers and footers
2. Setting page orientation and margins
3. Scaling the print out
4. Using Quick Print versus Print
5. Creating Excel Charts (Graphs)
1. Inserting a chart
2. Modifying a chart