Excel 2003: Intermediate

 

Performance-Based Objectives

  • Create And Apply Templates.
  • Create And Modify Charts.
  • Work With Graphic Objects.
  • Calculate With Advanced Formulas.
  • Sort And Filter Data.
  • Use Excel With The Web.

                                                             

Course Content

 

Lesson 1: Creating and Applying Templates

·         Create a Workbook from a Template

·         Create a Custom Template

·         Working with Comments

·         Create a Hyperlink

·         Use Web-based Research Tools

 

Lesson 2: Creating and Modifying Charts

·         Create a Chart

·         Format Chart Items

·         Change the Chart Type

·         Create a Diagram

 

Lesson 3: Working with Graphic Objects

·         Insert Graphics

·         Create AutoShapes

·         Format Graphic Objects

·         Change the Order of Graphic Objects

·         Group Graphic Objects

·        Move, Copy, and Resize Graphic Objects

Lesson 4: Calculating with Advanced Formulas

·         Create and Apply a Name for a Range of Cells

·         Calculate Across Worksheets

·         Calculate with Date and Time Functions

·         Calculate with Financial Functions

·         Calculate with Statistical Functions

·         Calculate with Lookup and Reference Functions

·         Calculate with Logical Functions

 

Lesson 5: Sorting and Filtering Data

·         Sort Data Lists

·         Filter Data Lists

·         Create and Apply Advanced Filters

·         Calculate with Database Functions

·         Add Subtotals to a Worksheet

 

Lesson 6: Using Excel with the Web

·         Export Excel Data

·         Publish a Worksheet to the Web

·         Import Data from the Web

·         Create a Web Query

 

Appendix A: Microsoft Office Specialist Program