Excel 2 2003 FE

Download PDF

Next Dates:

Mon, 19. Mar. 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

CHARTS
Chart Concepts
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