Microsoft Excel 2003 Level 3 - Advanced (Option 1)

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

This course is designed for users who are familiar with Excel and want to expand their
knowledge.

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

Additional Details

Pre-Requisites

Participants must have good working knowledge of Excel Introduction and Excel Intermediate.

Certificates offered

Certificate of completion

Cancellation Policy

RESCHEDULING POLICY

Registrants who wish to reschedule their course may do so at least 5 working days before the commencement of their course providing the course fee is paid within 30 days following the originally scheduled date of the course. Otherwise, a 20% surcharge is applicable.

CANCELLATION POLICY

Notice received less than 5 working days prior to the course date is subject to a 20% service charge. If the notice is given within 48 hours of the course date, the course is non-refundable. Notice of cancellation must be received by CompuEase 5 working days prior to the confirmed date to obtain a full refund.

Map & Reviews

CompuEase
[ View Provider's Profile ]

CompuEase Training Classroom
124 O'Connor, Suite 204
Ottawa, ON
Canada   K1P 5M9

Reviews

 

   

The crse was very well paced, covering all aspects of Microsoft Excel that I wanted to learn / had questions on. The trg provider is very well versed in both the subject and teaching / instructing skills, ensuring that all questions are answered before moving on to the next lesson / exercise. The crse handout booklet used and will use in the future is a great ref.

Reviewed by Arthur K. 2011