Microsoft Excel

Introduction

Intermediate Level 1

Intermediate Level 2

Formulas

Functions

Advanced

Macros & VBA Level 1

Macros & VBA Level 2

Macros & VBA Level 3

Version 2007 Upgrade

 

Register Now

 

View Course Outline PDF

(all Excel Courses show in one PDF)

 

 

 

 

 

 

Pay $ 115. to $ 215. for this course using TICKETS instead (Minimum Purchase of 11 Tickets).…Click here for More Information.

 

Course Dates (9am to 4pm)

 

Versions

Toronto

North York

Mississauga

Newmarket

Version 2003

Apr 14

May 12

Jun 17

Jul 18

Aug 13

Sep 8

Apr 16

May 14

Jun 11

Jul 15

Aug 12

Sep 12

Apr 21

May 15

Jun 16

Jul 16

Aug 25

Sep 10

Apr 10

May 9

Jun 10

Jul 21

Aug 26

Sep 11

Version 2007

Apr 15

Jun 18

Aug 22

May 16

Jul 16

Sep 9

Apr 22

Jun 19

Aug 27

May 22

Jul 25

Sep 15

 

Course Prerequisites

 

Required: Understanding of Excel Introduction topics.

 

Course Description

After learning the basics in the Introduction course, this course is an absolute must to get the most out of Excel.  You will learn important features that will save you time and make you much more efficient with the program.

Detailed List of Topics

 

Window Panes & Freezing Titles

Splitting a Window into 2 Or 4 Panes

See Widely Separated Areas of a Spreadsheet Simultaneously

Freezing Titles

Unsplitting and Unfreezing

 

Views and Cell Comments

Full Screen Display

Setting Zoom Levels

Attaching Comments to Cells

Editing and Deleting Comments

 

Multiple Sheets

Switching From Page To Page

Modifying Sheets

Moving and Copying Sheets

Setting Defaults for All Sheets

Changing the Number of Pages

 

Advanced Page Setup and Printing

Headers and Footers

Printing Column And Row Titles
Page Order

Review Of Page Breaks And Printing

 

 

 

Multiple Files

Opening Multiple Files

Displaying Multiple Files

Closing All Files

Linking Cells Between Files

 

Range Names

Creating a range name

Using Range Names For Navigation

Using names already entered as headings

Range names as bookmarks

 

Using AutoCorrect

 

Database Functions

Setting Up A Database

The Current Region

Sorting Lists Alphabetically/Numerically

Using AutoFilter to Extract Information

 

The List Feature (Excel 2003)

Data Forms

 

Find & Replace

Finding Text, Values, Functions

Replacing Text

Replacing Functions

 

  

Computer Training Courses, SoftSkills Seminars & Access Database Development

Computer Help is a division of MPM Skills Development Inc.
Toronto, Ontario, Canada.

Phone: 416.494.4912, Fax: 416.494.9952

www.Computer-Help.ca

Question or Comment - Email Us