Course Description

Boost your Excel skills by building timesaving, functional and effective workbooks for real life situations. These include Invoices, lists, budgets, payroll, cashflow, projections of expenses and revenue. Share workbooks in the cloud and discover basic AI functionality, generating charting and extract or join data using Flashfill.

Learner Outcomes

  •  Understand the Excel interface (terminology)

    •     Create mathematical Formulas

    •     Utilize the Functions SUM, MIN, MAX, AVERAGE, COUNT, TRIM, UPPER, LOWER

    •     Use Auto fill and Flashfill which uses machine-learning techniques to automatically reformat data based on an examples

    •     Modify layouts for columns and rows

    •     Construct worksheets that effectively, manage formulas and functions, using autofill with absolute/relative referencing.

    •     Move, copy and paste content using special paste functionality

    •     Design effective Databases using Tables

    •     Understand the order of mathematical operations - BEDMAS

    •     Format and control layout for readability for print or PDFs.

    •     Generate charts

Applies Towards the Following Certificates


Be the first to know when this course is available!

Unfortunately, this course is currently not open for enrollment or is in the process of being rescheduled. Join Our Interest List below to be notified via email when the course is next available for registration.


We are especially grateful to live, work, and play on the traditional territories of the Lekwungen (Songhees, Esquimalt), Malahat, Pacheedaht, Scia'new, T'Sou-ke, and WSÁNEĆ (Pauquachin, Tsartlip, Tsawout, Tseycum) peoples. We acknowledge their welcome and graciousness to the students who seek knowledge here.

Required fields are indicated by .