Search Courses
Dates for this class:
No dates are available for this class.

Course Details    [choose new course]     [printable version]
Excel 2002: Intermediate
Course Number: AP0054
Category: Business & Office Applications
Duration: 1.00 day
Description
This ILT Series course builds on the skills taught in Access 2002: Intermediate. In this advanced course, students will learn how to create and manage databases and database objects. Students will learn how to create PivotTables, PivotCharts, add tab controls to forms, create and use macros, and create SQL queries. Course activities also cover using hyperlinks and data access pages, working with database utilities and security features, such as passwords and permissions. This course maps to Microsoft Office Specialist exam objectives. The manual is designed for quick scanning in the classroom and filled with interactive exercises that help ensure student success.
Outline
  • Unit 1: Working with large worksheets
    • Topic A: Viewing options
    • Topic B: Hiding and displaying data
    • Topic C: Printing large worksheets 

 

  • Unit 2: Working with multiple worksheets and workbooks
    • Topic A: Using multiple worksheets
    • Topic B: Linking worksheets by using 3-D formulas
    • Topic C: Consolidating data
    • Topic D: Linking workbooks
    • Topic E: Managing workbooks

 

  • Unit 3: Customizing Excel
    • Topic A: Changing options
    • Topic B: Customizing toolbars and menus 

 

  • Unit 4: Advanced charting
    • Topic A: Chart formatting options
    • Topic B: Creating combination charts
    • Topic C: Using graphic elements 

 

  • Unit 5: Advanced formatting
    • Topic A: Borders and shading
    • Topic B: Using special number formats
    • Topic C: Working with dates
    • Topic D: Working with styles
    • Topic E: Other advanced formatting

 

  • Unit 6: List management
    • Topic A: Working with lists
    • Topic B: Sorting and filtering lists
    • Topic C: Advanced filtering 

 

  • Unit 7: Documenting and auditing
    • Topic A: Comments and text boxes
    • Topic B: Auditing features
    • Topic C: Protection
    • Topic D: Workgroup collaboration 

 

  • Unit 8: Using templates
    • Topic A: Built-in templates
    • Topic B: Creating and managing templates

 

  • Appendix A: Additional functions
    • Topic A: IF, SUMIF, and PMT 

 

  • Appendix B: Web discussions
    • Topic A: Creating and responding to Web discussions 

 

  • Appendix C: MOUS exam objectives map
    • Topic A: Core exam objectives
    • Topic B: Expert exam objectives