Introduction to Microsoft Excel 2010

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, do conditional formatting with graphics, SmartArt and screenshots, 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: The Excel environment Topic C: Getting help Topic D: Navigating a worksheet 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: Functions Topic A: Entering functions Topic B: AutoSum Topic C: Other useful functions

Unit 5: Formatting Topic A: Text Formatting Topic B: Rows and column formatting Topic C: Numbers formatting Topic D: Conditional formatting Topic E: Additional formatting options Unit 6: Printing Topic A: Preparing to print Topic B: Page Setup options Topic C: Printing worksheets Unit 7: Charts Topic A: Chart basics Topic B: Formatting charts Unit 8: Managing large workbooks Topic A: Viewing large worksheets Topic B: Printing large worksheets Topic C: Working with multiple worksheets Unit 9: Graphics and screenshots Topic A:Conditional formatting with graphics Topic B: SmartArt Graphics Topic C: Screenshots