Course Description

Realistic examples will be used to demonstrate ways to build on your basic knowledge of Excel to increase your productivity. Use powerful logic functions such as “IF” to identify conditions met or not met for specific criteria. Determine if you can afford a loan with financial payment functions. Use conditional formatting tools to easily identify key indicators for your business such as top 10, or highest average, based on your unique criteria. Link and group worksheets, use named ranges to quickly locate data, and use powerful database techniques that include data validation, sorting and filtering and many more Excel topics. You must be familiar with AutoSum, AutoFill, how to create a basic chart and understand the difference between relative and absolute referencing.


Excel Level 1 or equivalent skills plus strong file management skills. Word Level 1 or equivalent skills recommended. Electronic course manual (pdf) included. See course outline for detailed list of topics.

Students should ensure they have access to a cloud (such as Dropbox, GDrive, OneDrive, Icloud etc. ) and ensure they know their username and password for class.


"Caroline was amazing! She was funny, informative and a pleasure to have as an instructor! Very easy learning pace, tons of help given so you're never lost." V.E.

Applies Towards the Following Certificates


Course Details

Section Title
Excel - Level 2 - Advanced Formulas and Analysis
T, W, Th
9:00AM to 4:00PM
Nov 12, 2019 to Nov 14, 2019
Schedule and Location
Total Course Hours
Course Fee(s)
Tuition non-credit $450.00
Reading List / Textbook
Electronic course manual (pdf) included

Camosun College campuses are located on the traditional territories of the Lkwungen and WSÁNEĆ peoples.
We acknowledge their welcome and graciousness to the students who seek knowledge here.

Required fields are indicated by .