Excel 2 2003

Download PDF

Next Dates:

Wed, 08. Feb. 2012
Wed, 14. Mar. 2012
Thu, 19. Apr. 2012

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 185

Target audience & Prerequisites:

This Course is designed for participants who know the basics of Excel. Knowledge of Excel Introduction and Windows experience.

Learning objectives:

Upon completion of the course, you will be familiar with the following: Advanced formulas, using range names in formulas, managing worksheets within workbooks, using advance formatting techniques, creating and printing charts as well as sorting data in alphanumeric order.

Course Outline:

ABSOLUTE/ RELATIVE RANGE

Creating and using an Absolute Range

USING RANGE NAMES

Creating a Range Name
Jumping to a Named Range
Using Range Names in Formulas

ADVANCED FORMULAS

Using some of the Logical Formulas
Using some of the Financial Functions
Date Formulas
Linking Formulas

MANAGING WORKSHEETS

Copying / Moving Worksheets
Moving Data between Worksheets
Copying Data between Worksheets
Renaming Worksheet Tabs
Consolidation Worksheets

ADVANCED FORMATTING

Using Styles
Templates
Conditional Formatting
Autoformat

Chart

ChartConcepts
Creating Charts
Editing Charts
Printing Charts

DATA SORT

Sorting Lists
Sorting in Ascending/Descending Order
Sorting using multiple fields

DATABASE

Enabling AutoFilter
Using AutoFilter to Filter a Custom List

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