Microsoft Excel 2007 Level 3 - Data Management

Microsoft Excel 2007 Level 3
Data Management

Course ID: S173D
Duration: 1 day

Prerequisites

Microsoft Excel 2007 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
Import external data from a variety of sources into Excel

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 Tables

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

External Data
External Data Concepts ; Importing Query Data from Access ; Importing Query Data from Web Pages ; Importing Query Data from Text Files

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