Calendar

January 2012 February 2012 March 2012
Mo Tu We Th Fr Sa Su
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29

Search

Search

Course List

Request a course date
  Sign Up to our News letter Today!

 

Excel 3 2003 - Option 1
Download PDF

Next Dates:
Fri, 17. Feb. 2012
Wed, 28. Mar. 2012
Wed, 02. May. 2012

Choose a date:


Mode:

Length:
1 day

Location:
Ottawa

Language:
EE

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: