College Gallery

CC189 - MS Excel 2016: Formulas, Functions & Fill


Add to cart


Available Anywhere Open Enrollment


9:00 AM-12:00 PM Tuesday - May 02, 2017 (Mountain Time Zone)

Delivery Method

Recording Only


Total: $103.95
Tuition: $99.00
GST: $4.95


Heather Lyon

About the Facilitator: Heather Lyon. Heather is the owner and operator of First Start Planning Ltd., and is a Certified Professional Bookkeeper. Based in Rocky Mountain House, AB, she has provided training and business services to her clients throughout Western Canada for over 20 years. Heather delivers a variety of workshops and presentations to organizations and through colleges in Alberta and the Northwest Territories, both face to face and online. Heather's students consistently describe her as knowledgeable, practical and enthusiastic in delivering the many topics she teaches.

Available Anywhere: By Recording Only

In this 3-hour session, learn how to set up formulas and functions to get the MS Excel 2016 program to do the math for you.

Learn to work with:
 Creating and editing formulas
 Mathematical operators
 Common functions
 Conditional functions
 Fill function
 Absolute and Relative cell references
 Protecting your workbook

Private Training - A Continuing Education & Corporate Training Specialty

Training on your terms and your schedule. We can offer any course to your workplace or community. Phone 780.849.8623 and talk with us about your training needs or email:


No Pre-requisites

Withdrawals and Refunds

Safety and Driver Training Courses:  Your registration will be fully refunded when notice of withdrawal is given two (2) working days before the course start date.  When notification is received less than two (2) full working days before the course start date no refund will be issued.  If you are unable to attend your course, you may arrange for someone to take your place by contacting Continuing Education & Corporate Training at or 780-849-8623.


Northern Lakes College reserves the right to re-schedule or cancel a course that lacks sufficient registrations to provide a satisfactory learning atmosphere. In this event your registration fee will be refunded in full or applied to the re-scheduled course.

Fee payment

Fees are due at the time of registration. Northern Lakes College accepts cash, cheque, money order, debit, VISA, MasterCard, American Express. Invoicing to a company requires a Purchase Order (PO).


This course is also available at these times and places

Available Anywhere Open Enrollment
May 2, 2017 - Dec 31, 2017
Available Anywhere Open Enrollment
Nov 23, 2017 - Jun 30, 2018