Computer Help Training: Excel Courses - Toronto - North York - Mississauga

Excel
Functions

1 Day (9am to 4pm)
$ 275. or 1 Ticket

Other Excel Course Levels

Introduction
Intermediate Level 1
Formulas
Intermediate Level 2
Functions
Advanced Level 1
Advanced Level 2
Macros & VBA Level 1
Macros & VBA Level 2
Macros & VBA Level 3
Upgrade from 2003

Register Now

Contact Us

View PDF Course Outlines for All
Excel Courses

Locations

Toronto
20 Queen Street West, Suite 3306
(Toronto Eaton Centre)

North York
2 Lansing Square, Suite 505
(Hwy 401 & Hwy 404/DVP)

Mississauga
1087 Meyerside Drive, Unit 10
(Dixie Rd. & Hwy. 401)

Newmarket
16635 Yonge Street, Unit 19
(Yonge St. & Mulock Dr.)

Functions are Excel formulas that make your computer do the heavy lifting of calculating rather than making you explain every step of the work. If you’ve looked at other peoples’ spreadsheets full of words like IF, VLOOKUP, ROUND, and SUMIF and wondered how they worked, then this is the course you are looking for.

As well as teaching you how to create the most commonly used functions (with a special focus on IF and VLOOKUP), this course will also show you how to understand any complicated function formula you might encounter in future. Not only will you know many useful tricks by the end of the course, you’ll have laid the foundation for future self-learning up to a very high level of complexity.

Creating a Basic Function

Typing Functions

Using Insert Function

Review of Using AutoSum

4 Ways to Add up Numbers

Sum and Average

Statistical Functions

Count

CountA

Large

Small

Rank

Max

Min

Average

Median

Mode

Functions Across Multiple Ranges

Multiple Ranges on Same Sheet

Multiple Ranges on Different Sheets

Multiple Ranges in Different Files (Linking)

Math and Trig Functions

Product

Roman

Sum

SumIf

Round

RoundUp

RoundDown

Ceiling

Floor

Date and Time Functions

Today

Now

Date

Value

Day

Month

Year

Weekday

Text Functions

Left

Mid

Right

Len

Trim

Lower

Upper

Proper

Logical Functions

Nesting If's

And

Information Functions

IsErr

IsText

IsNumber

IsBlank

Lookup Functions

Vlookup

Hlookup

Choose

Transpose

Financial Functions

IRR

PMT

Versions	Toronto	North York	Mississauga	Newmarket
2007 /2010	May 30	May 27	May 28
2007 /2010/2013	Jul 22 Sep 18	Jun 25 Aug 27	Jul 29 Sep 26	Jun 28 Aug 29
Course Prerequisite: 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.