Intermediate
Microsoft Excel 2003

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

---

All Excel Courses

Excel 2010 Classes	Excel 2007 Classes	Excel 2003 Classes
What's New in Excel 2010 > Introduction > Intermediate > Advanced >	What's New in Excel 2007 > Introduction > Intermediate > Advanced > Expert >	Introduction > Intermediate > Advanced >
		About Excel >

---