What You'll Learn

• Add, edit, search for, and delete records in a data list using a form
• Look up data
• Sort records in a data list using a variety of methods
• Filter data in a list using a variety of methods
• Work with filtered data
• Create and work with subtotaled lists
• Use various database functions to summarize data
• Create, modify, and work with PivotTables and PivotCharts
• Import external data from a variety of sources into Excel

Course Outline

1. Maintaining Data Lists

• Working with Data Lists
• Working with Data Forms
• Working with Lookup Functions

2. Sorting Data

• Understanding the Basics of Sorting
• Using Custom Sort Orders

3. Filtering Data

• Understanding the Basics of Filtering
• Filtering Methods
• Using AutoFilter
• Working with Advanced Filter

4. Summarizing Data

• Understanding the Basics of Automatic Subtotals
• Working with Subtotaled Lists
• Using Functions to Summarize Data
• Working with Tables

5. Working with PivotTables

• PivotTable Concepts
• Creating a PivotTable
• Modifying the PivotTable Layout
• Customizing the PivotTable
• Understanding PivotChart Concepts

6. Working with External Data

• Understanding External Data Concepts
• Importing Data from Access
• Importing Query Data from Web Pages
• Importing Data from Text Files

Classroom Dates and Locations

Date	Location
Sep 10 - 10, 2010	Ottawa, ON	Call to Register
Sep 10 - 10, 2010	Vancouver, BC	Call to Register
Sep 24 - 24, 2010	Toronto, ON	Register
Sep 27 - 27, 2010	Mississauga, ON	Register
Oct 6 - 6, 2010	Edmonton, AB	Register
Oct 8 - 8, 2010	Kitchener, ON	Register
Oct 12 - 12, 2010	Montreal, QC	Register
Oct 14 - 14, 2010	Calgary, AB	Register
Oct 21 - 21, 2010	Halifax, NS	Register
Oct 29 - 29, 2010	Ottawa, ON	Register
Oct 29 - 29, 2010	Toronto, ON	Register
Oct 29 - 29, 2010	Victoria, BC	Register
Nov 4 - 4, 2010	Winnipeg, MB	Register
Nov 5 - 5, 2010	Mississauga, ON	Register
Dec 3 - 3, 2010	Toronto, ON	Register
Dec 8 - 8, 2010	Montreal, QC	Register
Dec 9 - 9, 2010	Calgary, AB	Register
Dec 14 - 14, 2010	Edmonton, AB	Register
Dec 20 - 20, 2010	Mississauga, ON	Register
Dec 20 - 20, 2010	Ottawa, ON	Register
Jan 4 - 4, 2011	Victoria, BC	Register
Jan 14 - 14, 2011	Halifax, NS	Register
Jan 14 - 14, 2011	Toronto, ON	Register
Jan 17 - 17, 2011	Kitchener, ON	Register
Jan 17 - 17, 2011	Vancouver, BC	Register
Jan 21 - 21, 2011	Winnipeg, MB	Register
Jan 26 - 26, 2011	Mississauga, ON	Register
Feb 2 - 2, 2011	Ottawa, ON	Register
Feb 7 - 7, 2011	Montreal, QC	Register
Feb 8 - 8, 2011	Calgary, AB	Register
Feb 11 - 11, 2011	Toronto, ON	Register
Feb 22 - 22, 2011	Mississauga, ON	Register
Feb 24 - 24, 2011	Edmonton, AB	Register
Mar 18 - 18, 2011	Toronto, ON	Register
Mar 25 - 25, 2011	Ottawa, ON	Register
Mar 28 - 28, 2011	Calgary, AB	Register
Mar 29 - 29, 2011	Halifax, NS	Register
Mar 29 - 29, 2011	Victoria, BC	Register
Mar 30 - 30, 2011	Montreal, QC	Register
Mar 30 - 30, 2011	Winnipeg, MB	Register
Mar 31 - 31, 2011	Vancouver, BC	Register
Apr 7 - 7, 2011	Mississauga, ON	Register
Apr 8 - 8, 2011	Kitchener, ON	Register
Apr 18 - 18, 2011	Toronto, ON	Register
May 5 - 5, 2011	Mississauga, ON	Register
May 5 - 5, 2011	Vancouver, BC	Register
May 13 - 13, 2011	Ottawa, ON	Register
May 16 - 16, 2011	Edmonton, AB	Register
May 17 - 17, 2011	Toronto, ON	Register
May 26 - 26, 2011	Montreal, QC	Register
May 27 - 27, 2011	Calgary, AB	Register
Jun 3 - 3, 2011	Halifax, NS	Register
Jun 6 - 6, 2011	Victoria, BC	Register

Don’t see the location or date you need? No problem – just use our By Request service.