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
16775 Yonge Street, Suite 219
(
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

Search

Trim

Lower

Upper

Proper

 

Logical Functions

If

Nesting If's

And

Or

 

 

 

 

Information Functions

IsErr

NA

IsText

IsNumber

IsBlank

 

Lookup Functions

Vlookup

Hlookup

Choose

Transpose

 

Financial Functions

IRR

FV

PMT

PV

DB

 

 
Versions Toronto North York Mississauga Newmarket
2007 /2010/2013 Click here for Course Dates and Booking information.

 

 

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.

 

  

Computer Training Courses / SoftSkills Seminars  / Access Database Development

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

www.Computer-Help.ca

Question or Comment - Email Us