Microsoft Excel 2003 - Data List Management

Learn how to add, edit, search for, & delete records in a data list using a form. How to sort data in a data list, creating &working with subtotaled lists, using various database functions to summarize data, creating &working with pivot tables & charts.

Course Outline

This course introduces user to Excel's advanced features and functions by showing users how to add, edit, search for, and delete records in a data list using a form. How to sort data in a data list, creating and working with subtotaled lists, using various database functions to summarize data, creating and working with pivot tables and charts, and how to import external data from various sources into Excel.

Course Content

Maintaining Data Lists

• Data List Concepts
• Using Data Forms
• Using Lookup Tables

Sorting List

• Sorting Concepts
• Sorting Lists
• Custom Sort Orders

Filtering Lists

• Filtering Concepts
• Using AutoFilter
• Using Advanced Filter
• Working with Filtered Data

Summarizing Data

• Changing Font Type, Size, Colour, and Styles

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

Additional Details

Pre-Requisites

Excel 2003 - Level II or equivalent knowledge experience

Certificates offered

Certificate of completion

Cancellation Policy

10 business days cancellation or full course fee will be charged

Map & Reviews

Technology Training Centre
[ View Provider's Profile ]

Training Room 12 A
12th floor, 44 Capital Blvd.
10044-108 Street
Edmonton, Alberta
Canada   T5J 3S7

Reviews

 

   

The course was excellent and the instructor did a great job but why does everybody cut the time short. I think we should take a shorter lunch and get more class time instead of leaving a half of an hour early!

Reviewed by Darlene T. 2011