Course Length:

1 Day

Course Description:

This course teaches intermediate-level features and functions of Excel 2003. Students will learn how to work with large worksheets, use 3-D formulas, customize Excel's toolbars and menus, apply special cell formatting, sort and filter lists, create combination charts and trendlines, use Excel's auditing features, and work with templates. This course is approved courseware for Microsoft Office Specialist certification.

Who Should Attend:

Students who want to gain the skills necessary to create templates, sort and filter data, and import, export, and analyze data, should take this course. This course also helps prepare students for the Microsoft Office Specialist exam in Excel .

Benefits of Attendance:

Upon completion of this course, students will be able to:

• Navigate large worksheets effectively by using magnification, frozen panes, and split panes; and control the printing of large worksheets.
• Navigate, manage, and print multiple worksheets; link workbooks by using 3-D formulas; and summarize data by using the Consolidate command.
• Change the View, General, and Calculation settings of Excel; and customize toolbars and menus.
• Add borders and shading; apply special formats; create, apply, and modify styles; and change the orientation of cells.
• Sort lists by columns; and filter lists based on complex criteria.
• Format data points; create combination charts and trendlines; and add and format graphic elements.
• Use auditing features; add comments and text boxes; and protect a worksheet or part of a worksheet.
• Work with Excelâ¿¿s built-in templates; and create and manage custom templates.

Prerequisites:

Students should have experience creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003. Students can obtain this level of skill by taking Microsoft Excel 2003: Level 1. In addition, Web browsing experience is strongly recommended.

Course Outline:

• Unit 1: Working with large worksheets
  1. Topic A: Viewing options
  2. Topic B: Hiding, displaying, and outlining data
  3. Topic C: Printing large worksheets
• Unit 2: Using multiple worksheets and workbooks
  1. Topic A: Using multiple worksheets
  2. Topic B: Linking worksheets by using 3-D formulas
  3. Topic C: Consolidating data
  4. Topic D: Linking workbooks
  5. Topic E: Managing workbooks
• Unit 3: Customizing Excel
  1. Topic A: Using the Options dialog box
  2. Topic B: Customizing toolbars and menus
• Unit 4: Advanced formatting
  1. Topic A: Borders and shading
  2. Topic B: Using special number formats
  3. Topic C: Working with dates
  4. Topic D: Working with styles
  5. Topic E: Other advanced formatting
• Unit 5: List management
  1. Topic A: Examining lists
  2. Topic B: Sorting and filtering lists
  3. Topic C: Advanced filtering
• Unit 6: Advanced charting
  1. Topic A: Chart formatting options
  2. Topic B: Using combination charts
  3. Topic C: Using graphic elements
• Unit 7: Documenting and auditing
  1. Topic A: Auditing features
  2. Topic B: Comments and text boxes
  3. Topic C: Protection
  4. Topic D: Workgroup collaboration
• Unit 8: Using templates
  1. Topic A: Built-in templates
  2. Topic B: Creating and managing templates
• Appendix A: Web discussions
  1. Topic A: Creating and responding to Web discussions
• Appendix B: Microsoft Office Specialist exam objectives maps
  1. Topic A: Specialist exam objectives
  2. Topic B: Expert exam objectives