Overview:

This course is designed for students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the Web.

Course Outline:

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 graphics 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 & 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