Excel 3 2003 - Option 1

Download PDF

Next Dates:

Mon, 09. Apr. 2012

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 235

Target audience & Prerequisites:

This course is designed for users who are familiar with Excel and want to expand their knowledge. Participants must have good working knowledge of Excel Introduction and Excel Intermediate.

Learning objectives:

Upon completion of the course, you will be able to work with Outlines, Subtotals, Data Forms and Autofilter. You will also be comfortable using Pivot Tables and Charts as well as importing and exporting data.

Course Outline:

WORKING WITH OUTLINES
Applying an Outline
Expanding/Collapsing an Outline
Modifying Outline Settings
Clearing an Outline
Using Auto Outline

WORKING WITH SUBTOTALS
Creating and using Subtotal Data
Removing Subtotals from a List

WORKING WITH DATA FORMS
Viewing the Data Form
Editing Data Form Records
Adding Data Form Records
Defining Criteria
Clearing Data Form Criteria
Deleting Data Form Records

WORKING WITH AUTOFILTER
Creating a Custom AutoFilter
Using Advance Filters

PIVOT TABLES
Creating a PivotTable Report using Wizard
Modifying Pivot Tables
Working with Pivot Tables
Pivot Table Charts

IMPORTING AND EXPORTING
Importing Data using MS Query
Changing External Data Range Properties
Importing a Table from a Web Page
Exporting Data to Other Applications

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List