Introduction to Microsoft Excel 2007

Duration: 12 hours

Description: After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. They will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting, and printing. Students will create and modify charts, and learn to manage large workbooks.

Objective: The student will learn to use basic features in worksheet applications.

Course Content:

Unit 1: Getting started Topic A: Spreadsheet terminology Topic B: Exploring the Excel window Topic C: Getting help Topic D: Navigating workbooks Unit 2: Entering and editing data Topic A: Entering and editing text and values Topic B: Entering and editing formulas Topic C: Working with pictures Topic D: Saving and updating workbooks Unit 3: Modifying a worksheet Topic A: Moving and copying data Topic B: Moving and copying formulas Topic C: Absolute and relative references Topic D: Inserting/deleting ranges, rows, columns Unit 4: Using functions Topic A: Entering functions Topic B: AutoSum Topic C: Other useful functions

Unit 5: Formatting worksheets Topic A: Formatting text Topic B: Formatting rows and columns Topic C: Formatting numbers Topic D: Conditional formatting Topic E: Copying formats and applying table formats Unit 6: Printing Topic A: Preparing to print Topic B: Page Setup options Topic C: Printing worksheets Unit 7: Creating charts Topic A: Chart basics Topic B: Modifying charts Topic C: Printing charts Unit 8: Managing large workbooks Topic A: Viewing large worksheets Topic B: Printing large worksheets Topic C: Using multiple worksheets