Aurora College

Formulas & Functions - Online
2026-03-26 09:00 - 12:00 (America/Inuvik)
In this 3-hour session, learn how to set up formulas and functions to get the Excel program to do the math for you. Topics include:

Creating and editing formulas

Mathematical operators

Common functions

Conditional functions

Absolute & relative cell references

Protecting your workbook

Date: March 26, 2026Time: 9:00 a.m. – NoonCost: $175.00Instructor: Heather Lyon

Formatting the Worksheet - Online
2026-04-02 09:00 - 12:00
Make your Excel workbooks look professional and readable by learning how to properly format all the aspects of your spreadsheet. In this 3-hour session, you will learn how to work with:

Formatting dates & numbers

Cell alignment

Fonts & sizes

Borders

Colours and patterns

Format painter

Themes & Styles

Conditional formatting

Date: April 2, 2026Time: 9:00 a.m. – NoonCost: $175.00Instructor: Heather Lyon

Good Friday
2026-04-03 08:00 - 17:00

Easter Monday
2026-04-06 08:00 - 17:00

Charts & Tables - Online
2026-04-09 13:00 - 16:00
In the Excel program, you can convert your data from a spreadsheet into a table and/or chart. Learn how you can turn dry financial and statistical information into a vibrant visual display that will have a powerful impact on your audience!

Charts vs. Tables

Creating a chart

Changing chart types

Changing chart layout and location

Using sparklines

Creating a table

Creating a Pivot Table

Date: April 9, 2026Time: 1:00 p.m. – 4:00 p.m.Cost: $175.00Instructor: Heather Lyon

Excel Extras - Online
2026-04-16 09:00 - 12:00
You know the basics of the Excel program. Now learn about what else you can do to make working with this program even easier and more effective in this 3-hour session. Topics include:

Working with graphics

Inserting a screenshot

Sorting & Filtering

Using hyperlinks

Using comments

Drop-down lists

Grouping & Subtotals

Quick Analysis

Date: April 16, 2026Time: 9:00 a.m. – NoonCost: $175.00Instructor: Heather Lyon

Delivering Exceptional Customer Service
2026-04-20 09:00 - 2026-04-21 16:00
Course Overview

Customers today have high expectations. They are more demanding and less patient. Providing a positive, productive and proactive response is the key to exceptional customer service. Service skills always require updating, careful analysis, review and practice. This course examines the key to exceptional customer service by emphasizing the importance of first impressions, a positive service image and a customer focused approach.

Objectives:

Develop a positive approach to dealing with customers

Use responsive customer service skills

Help customers to understand changes in service

Keep your customer satisfied when explaining complex policies

Respond to demands for service with the best use of resources

Course Outline

Why is great service important?

How does it impact our customers?

How does it impact our business/organization?

How does it impact us personally?

How can we deliver exceptional service?

An attitude adjustment

Know your ‘product’

Know your customers

First Impressions

Why is this so important?

Face to face

Over the telephone

Business image

Building Relationships

Value Exchange

Recognition

Building Trust

Customer Communication

Learning to Listen

A different point of view

Personality Differences

Mirroring

Keeping the Customer Satisfied

Dealing with change

Oops, we made a mistake!

An attitude of gratitude

Managing Time & Resources

Multi-tasking

Time Bandits

Improving efficiency

Developing a Customer Service Plan

Belief Statements

Service Agreements

Accountability/Reporting Loop

Dates: April 20 & 21, 2026Times: 9:00 a.m. – 4:00 p.m.Location: OnlineInstructor: Heather LyonCost: $500.00

Robert's Rules of Order - Online
2026-04-23 09:00 - 16:00
Have you ever played a team sport where only a few of the players knew the rules? The same types of challenges can occur in your meetings if your group does not understand how to properly “play the game”. In this one-day online session, you will learn the basics of Robert’s Rules of Order, the foremost manual on parliamentary procedures that is used by most organizations with boards of directors. By following these rules and other tips included in this session, you can ensure your meetings will be fair, efficient, democratic and orderly.

What are Roberts Rules of Order?o History of the booko What are the principles behind these rules?

Motionso What is a motion?o Types of motions and their purposeso Presenting a motiono Seconding a motiono Debating a motiono Amending a motiono Withdrawing a motiono Voting on a motion

Requesting Points of Somethingo What is a ‘Point’?o Types of points and their purposes

Tips for chairpersons of a meetingo Know and teach your group the rules of ordero Set meeting times and dates that worko Notify and confirm attendanceo Prepare and distribute an agenda in advanceo Request reports in advanceo Start & finish on timeo Stick to the agendao Assign time limits for reports/debateso Ensure action items are clear and assignedo Do an Action Item Review each meetingo Dealing with “hot topics”o Make every decision unanimous

Date: April 23, 2026Time: 9:00 – 4:00 p.m.Cost: $350.00Instructor: Heather Lyon

Winter Term Ends
2026-04-24 08:00 - 17:00

Business Administration Math Entry Course
2026-05-05 18:00 - 19:30, 2026-05-07 18:00 - 19:30, 2026-05-12 18:00 - 19:30, 2026-05-14 18:00 - 19:30, 2026-05-19 18:00 - 19:30, 2026-05-21 18:00 - 19:30, 2026-05-26 18:00 - 19:30, 2026-05-28 18:00 - 19:30 and 4 more dates
Are you interested in attending the Business Administration Program but are missing the Math prerequisite or need to refresh your math skills?

This course will introduce students to the mathematical principles needed to be successful in the Business Administration Program. It will act as a pathway to admittance for students who may not currently meet the admission requirements or wish to refresh their skills before starting the program. The course will cover the concepts underlying math theories, principles, and usage. These fundamental skills are necessary to be successful in the BA Program for the development of numerical literacy.

Dates: May 5, 2025 – June 18, 2026Times: Tuesday and Thursday Evenings from 6:00 p.m. – 7:30 p.m.Instructor: Joanna HartleyTuition: $475.00 plus the cost of the e-textbook (approx. $88.00)Textbook: Foundations of Mathematics with Geometry, Trigonometry, and Statistics, fourth Edition, by Kugathasan & Kox (Publisher: Vretta). Price: E-Textbook package $88.00.Prerequisites: English 150 or English 30-2, Math 145 or Math 20-2 or 20-1Location: Online via TEAMS/Moodle

Add/Drop Deadline
2026-05-08 08:00 - 17:00
Also the last day for tuition to be paid or for a student to setup with a payment plan through Finance.

Writing Effective Proposals - Online
2026-05-13 09:00 - 2026-05-14 16:00
This 2-day course is designed to teach students how to write an effective proposal, whether to obtain work for a business or funding for an organization. The steps involved are covered from obtaining the needed information to prepare the proposal right to the layout of the final document. Through a combination of lecture and hands on work, students will work through the development and preparation of an actual proposal.

Date: May 13 & 14, 2026Time: 9:00 a.m. – 4:00. p.m.Cost: $600.00Instructor: Heather Lyon

Course Withdrawal 1/3 of Course
2026-05-21 08:00 - 17:00
50% refund to student and no academic penalty.

Intro to Excel - Online
2026-05-21 09:00 - 12:00
This 3-hour session will introduce you to the capabilities of the MS Excel program. Learn the basics of what you can do with the powerful electronic spreadsheet program including:

Purpose of spreadsheets

Moving around the screen

Using the ‘Ribbon’

Entering data

Creating basic formulas

Selecting cells

Working with workbooks

Viewing & printing

Date: May 21, 2026Time: 9:00 a.m. – NoonCost: $175.00Instructor: Heather Lyon

BOOKKEEPER & FINANCIAL OFFICER TRAINING PART ONE – INTRO TO ACCOUNTING - Online
2026-05-25 09:00 - 2026-05-27 16:00
This class is designed to enhance the knowledge of people presently employed in a bookkeeping or finance position or interested in pursuing a career in a bookkeeping position.

This 3-day course looks at the theory and the steps involved in preparing books for a business or organization in the NWT. Using an accounting simulation consisting of actual source documents from a fictitious business, students will enter one month of financial transactions for a small company using the five-journal system. This course will show students who use a computerized software program what is actually happening behind the entry screens on their computer and will give them a better overall understanding of the accounting process. Please note: This class includes intensive, hands-on work that will require your full attention. It is strongly suggested that if you are participating in these on-line sessions, you take the class in an environment where you can focus solely on the class. You will need a calculator or adding machine for this session.

Course objectivesAfter completing this course, you will be able to:Better understand the accounting process used in the 5 Journal manual accounting systemBe familiar with the steps involved in the annual accounting cycleUnderstand the five account categories used in accountingUnderstand Debits & Credits

Dates: May 25 – 27, 2026Times: 9:00 a.m. – 4:00 p.m.Location: OnlineInstructor: Heather LyonCost: $750.00

Formulas & Functions - Online
2026-05-28 09:00 - 12:00
In this 3-hour session, learn how to set up formulas and functions to get the Excel program to do the math for you. Topics include:

Creating and editing formulas

Mathematical operators

Common functions

Conditional functions

Absolute & relative cell references

Protecting your workbook

Date: May 28, 2026Time: 9:00 a.m. – NoonCost: $175.00Instructor: Heather Lyon

Course Withdrawal 50% of Course
2026-05-29 08:00 - 17:00
Spring Term. No refund, no academic penalty.

BOOKKEEPER & FINANCIAL OFFICER TRAINING PART TWO – READING AND UNDERSTANDING FINANCIAL STATEMENTS - Online
2026-06-01 09:00 - 2026-06-02 16:00
Many bookkeepers spend a lot of time recording financial transactions that are used to create financial statements each month. It is not unusual for bookkeepers, along with business owners and managers, to lack a full understanding of the valuable information included in these statements. This workshop goes through the sections of basic financial statements including balance sheets, income statements and supporting documents to give you a thorough understanding of the information they contain. You will learn how to use common ratios used by lenders and investors to determine the health of a business or organization, as well as ways to thoroughly analyze the information contained in the statements.

Course Objectives:To learn how the double entry accounting system worksTo develop an understanding of the principles of accounting used in financial statementsTo learn what information is included in a balance sheetTo learn what information is included in an income statementTo learn how to analyze the information in financial statementsTo learn how to read a statement of cash flows

Date: June 1 & 2, 2026Time: 9:00 a.m. – 4:00 p.m.Location: OnlineCost: $600.00

Formatting the Worksheet - Online
2026-06-04 09:00 - 12:00
Make your Excel workbooks look professional and readable by learning how to properly format all the aspects of your spreadsheet. In this 3-hour session, you will learn how to work with:

Formatting dates & numbers

Cell alignment

Fonts & sizes

Borders

Colours and patterns

Format painter

Themes & Styles

Conditional formatting

Date: June 4, 2026Time: 9:00 a.m. – NoonCost: $175.00Instructor: Heather Lyon
