Aurora College

Business Administration Math Entry Course
2026-05-21 18:00 - 19:30, 2026-05-26 18:00 - 19:30, 2026-05-28 18:00 - 19:30, 2026-06-02 18:00 - 19:30, 2026-06-04 18:00 - 19:30, 2026-06-09 18:00 - 19:30, 2026-06-11 18:00 - 19:30, 2026-06-16 18:00 - 19:30 (America/Inuvik) and 1 more date
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

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

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

Charts & Tables - Online
2026-06-18 09:00 - 12: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: June 18, 2026Time: 1:00 p.m. – 4:00 p.m.Cost: $175.00Instructor: Heather Lyon

BOOKKEEPER & FINANCIAL OFFICER TRAINING – PART THREE - COMPUTERIZED ACCOUNTING - Online
2026-06-23 09:00 - 2026-06-25 16:00, 2026-06-29 09:00 - 2026-06-30 16:00
This is Part 3 of the Bookkeeper & Financial Officer Training Program. You do not have to have taken part 1 as long as you have some basic knowledge and experience with bookkeeping. This 5-day session uses an accounting simulation package to teach you more about the various aspects of bookkeeping while learning how to enter financial transactions using the QuickBooks Desktop software program. Topics include Accounts Receivable, Accounts Payable, Payroll, Banking & Cash Accounts, and GST.

Dates: June 23 – 25 & June 29 & 30, 2026Times: 9:00 a.m. – 4:00 p.m.Location: OnlineInstructor: Heather LyonCost: $1,000.00

Excel Extras - Online
2026-06-26 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: June 26, 2026Time: 9:00 a.m. – NoonCost: $175.00Instructor: Heather Lyon
