Microsoft Excel

Introduction

Intermediate Level 1

Intermediate Level 2

Formulas

Functions

Advanced Level 1

Advanced Level 2

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

Mar 23

May 26

Apr 23

Mar 25

May 28

May 25

Version 2007

Apr 30

Apr 26

 

May 14

 

Course Prerequisites

 

Excel Introduction and Formulas courses or equivalent knowledge. Excel Intermediate Level 1 and Intermediate Level 2 courses are not required before taking this course, although knowledge of the topics covered in them is strongly recommended.

 

Course Description

This course is designed for Excel users who would like to learn more using the various functions available in Excel. 

Detailed List of Topics

 

Review of Using AutoSum

Typing Functions

Using Insert Function

 

Statistical Functions

Count

CountA

Large

Small

Rank

Max

Min

Average

Median

Mode

 

Logical Functions

If

And

Or

 

Math and Trig Functions

Product

Roman

Sum

SumIf

Round

RoundUp

RoundDown

 

Date and Time Functions

Today

Now

Date

Value

Day

Month

Year

Weekday

 

 

 

Text Functions

Left

Mid

Right

Len

Search

Trim

Lower

Upper

Proper

 

Information Functions

IsErr

NA

IsText

IsNumber

IsBlank

Info

 

Lookup Functions

Vlookup

Choose

Transpose

 

Financial Functions

IRR

FV

PMT

PV

DB

 

 

  

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