Microsoft Excel 2000 - 2003 Level 3 - Data List Management

Microsoft Excel 2000 - 2003 Level 3
Data List Management

Course ID: S1N3D
Duration: 1 day

Prerequisites

Excel 2000 - 2003 Level 2

Course Objectives

After completing the course, participants will be able to:

Add, edit, search for, and delete records in a data list using a form, as well as look up data
Sort records in a data list using a variety of methods
Filter data in a list using a variety of methods, as well as work with filtered data
Create and work with subtotalled lists, as well as use various database functions to summarize data
Create, modify, and work with PivotTables and PivotCharts
Start MS Query, define a data source and add a table to the query window, as well as add and manage fields in the data pane, return data to Excel, and import data from Web pages
Import text files using the Text Import wizard

Course Content

Maintaining Data Lists
Data List Concepts ; Using Data Forms ; Using Lookup Tables

Sorting Lists
Sorting Concepts ; Sorting Lists ; Custom Sort Orders

Filtering Lists
Filtering Concepts ; Using AutoFilter ; Using Advanced Filter ; Working with Filtered Data

Summarizing Data
Automatic Subtotals ; Working with Subtotalled Lists ; Using Functions to Summarize Data ; Working with Lists

PivotTables
PivotTable Concepts ; Creating PivotTables ; Modifying PivotTable Layouts ; Working with PivotTables ; Additional PivotTable Information ; PivotCharts

Using MS Query to Retrieve Data
Overview ; Starting Query from Excel ; Defining the Data Source ; Query Wizard ; Returning Data to Excel ; Microsoft Query ; Refreshing Data from a Query ; Importing Query Data from Web Pages

Supplemental Topics
Data Parsing

More Information

For more information, contact us by phone or send us an e-mail.

Toll Free: (866) 926-5671

Halifax • Montreal • Ottawa • Toronto • Winnipeg
Regina • Saskatoon • Calgary • Edmonton • Vancouver