Aurora College

Word Basics - Instructor-led Online Series
2023-11-07 13:00 - 16:00 (America/Inuvik)
This 3-hour session will introduce you to the capabilities of the MS Word program. Learn the basicsof what you can do with this powerful word processing program including:

Types of documents

Moving around the screen

Using the ‘Ribbon’

Entering text

Find & Replace

Using undo and redo

Creating new documents

Switching between documents

Saving documents

Viewing & printing documents

Date: November 7, 2023Time: 1:00 – 4:00 p.m.Cost: $150.00Instructor: Heather Lyon

Formulas & Functions - Instructor-led Online Series - Excel Training
2023-11-07 09:00 - 12:00
In this 3-hour session, learn how to set up formulas and functions to get the Excel programto 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: November 7, 2023Time: 9:00 a.m. – 12:00 p.m.Cost: $150.00Instructor: Heather Lyon

Course Withdrawal 1/3 of Course - Fall 2023 Term
2023-11-01 00:00 - 23:59
50% refund to student & no academic penalty.

Medical Terminology – In Person in Yellowknife
2023-10-31 18:00 - 21:00, 2023-10-24 18:00 - 21:00, 2023-10-17 18:00 - 21:00, 2023-10-10 18:00 - 21:00, 2023-10-03 18:00 - 21:00, 2023-09-26 18:00 - 21:00, 2023-09-19 18:00 - 21:00, 2023-09-12 18:00 - 21:00 | Yellowknife North Slave Campus, 5004 54 St, Yellowknife, NT, X1A2R6, Canada
This course is a comprehensive introduction to medical terminology. The course will have an emphasis on medical word building, medical word parts and the use of medical terminology. The course will take a body systems approach to help the learner understand medical terms related to human anatomy and physiology, diagnostic procedures, disease processes, as well as various medical and surgical treatment modes.

Date: Tuesday Evenings, September 12 – December 19, 2023

Time: 6:00 – 9:00 p.m.

Tuition: $545.00

Text: Medical Terminology A Living Language – Cost TBD

Instructor: Lesia Lucan

This course will be delivered face to face at Yellowknife Campus. Contact Karen Horn at (867) 920-8802 or email khorn@auroracollege.nt.ca for more information and to register.

Excel Advanced – Instructor-led Online Series
2023-10-30 09:00 - 16:00
This 1-day workshop is for experienced users of the Excel program. In this session, we learn some of the more advanced features of Excel, including advanced functions such as lookup, date & time, and financial functions; how to nest functions; Data analysis using Pivot Tables and Pivot Charts; and how to perform What-if Analyses. We also learn how to create forms in Excel. Students should have a good understanding of the basics of the program before taking this course.

Functions & Formulas

Named Ranges

Lookup Functions

Date & Time Functions

Checking for Formula Errors

Data Verification

Financial Functions

Nesting Functions

Pivot Tables & Pivot Charts

Customizing Pivot Tables

Filters

Data Slicers

Grouping Data

Creating a Pivot Chart

Changing Pivot Chart Options

Drilling Down

Creating Forms in Excel

Adding Command Buttons

Spin Buttons and Scroll Bars

Check Boxes and Option Buttons

List Boxes and Combo Boxes

Group Box

Text Boxes

Performing What-if Analysis

Using the Goal Seek Tool

Working with Scenarios

Using Cell Watch

Date: October 30, 2023Time: 9:00 a.m. – 4:00 p.m.Cost: $350.00Instructor: Heather Lyon

Speak Up, Speak Out - Instructor-led Online
2023-10-26 09:00 - 16:00
Surveys indicate that many people list public speaking as their greatest fear – while fear of death is listed farther down the list! If you are someone who would rather die than speak up in public, this one-day course is for you. In addition to learning what it takes to be effective in any public speaking situation – whether making a formal presentation or just offering an opinion in a meeting, you will gain valuable experience in facing your fear and moving through it.

Date: October 26, 2023Time: 9:00 a.m. – 4:00 p.m.Location: Virtual

Cost: $300.00Instructor: Heather Lyon

Intro to Excel - Instructor-led Online Series
2023-10-24 09:00 - 12:00
This 3-hour session will introduce you to the capabilities of the MS Excel program. Learn thebasics 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: October 24, 2023Time: 9:00 a.m. – 12:00 p.m.Cost: $150.00Instructor: Heather Lyon

PROJECT MANAGEMENT FUNDAMENTALS
2023-10-23 09:00 - 2023-10-25 16:00 | Aurora Campus, Inuvik
During this face-to-face workshop you will examine project management from conceptualization through to final completion. You will learn how to set up an effective plan, apply project planning steps, develop the project plan and implement it, manage work in progress, monitor controls, and reporting status.

Date: October 23 to 25, 2023

Time: 9:00 AM to 4:00 PM each day

Cost: $900.00

Instructor: Janet Dean

Fall Term 2023
2023-10-03 00:00 - 2024-01-19 23:59

Minute Taking - Online
2023-09-28 09:00 - 16:00
This workshop is for people who are responsible for taking minutes in meetings. You will learn how to co-ordinate meetings, take minutes in formal and informal meetings, edit the minutes without altering content, and how to present, distribute and maintain the minutes most effectively. Topics include agenda preparation, minute taking styles & formats for different types of meetings, some basics on Rules of Order and motions, what to keep in, what to leave out, and more.

A. Your Role

Meeting Preparation

Working with the Chair

Recording

Distribution

B. Meeting Preparation

Agenda Preparation

Notifying & Confirming Attendance

Preparing the Room

C. Working with the Chair

Improved Communication

Understanding Objectives

Follow-up and Approval

D. Recording

Minute Formats (narrative, action, resolution)

Level of formality

Enhancing your listening skills

Rules of Order

What to keep, what to leave out

Using a template

Staying “on track”

Identifying decisions and action plans

Editing and Proofreading

Approvals and Sign-offs

E. Distribution

Who gets a copy?

Storing the original

Preparing for next meeting

Date: September 28, 2023

Time: 9:00 a.m. to 4:00 p.m.

Location: Online

Tuition: $300.00

Instructor: Heather Lyon

PROJECT MANAGEMENT FUNDAMENTALS
2023-09-18 09:00 - 2023-09-20 16:00 | Yellowknife North Slave Campus, 5004 54 St, Yellowknife, NT, X1A2R6, Canada
This workshop will examine project management from conceptualization through to completion. You will learn: setting up an effective plan, applying project-planning steps, developing the project plan and implementing it, managing work in progress, monitoring controls, and reporting status.

Date: September 18-20, 2023

Time: 9:00 AM to 4:00 PM each day

Cost: $600.00

Instructor: Janet Dean, TangleTree Enterprises Ltd.

Add/Drop Deadline Fall 2023 Term
2023-09-08 08:00 - 17:00
Last day to add or drop course for the Fall 2023 term.

*Also the last day for tuition to be paid or for a student to be setup with a payment plan through Finance Division.

Excel Extras - Instructor-led Online Series
2023-08-31 13:00 - 16:00
You know the basics of the Excel program. Now learn about what else you can do to make workingwith 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: August 31, 2023Time: 1:00 p.m. – 4:00 p.m.Cost: $150.00Instructor: Heather Lyon

Charts & Tables - Instructor-led Online Series - Excel Training
2023-08-17 13:00 - 16:00
In the Excel program, you can convert your data from a spreadsheet into a table and/orchart. Learn how you can turn dry financial and statistical information into a vibrant visualdisplay 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: August 17, 2023Time: 1:00 p.m. – 4:00 p.m.Cost: $150.00Instructor: Heather Lyon

Excel Extras - Instructor-led Online Series
2023-08-17 09:00 - 12:00
You know the basics of the Excel program. Now learn about what else you can do to make workingwith 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: August 17, 2023Time: 9:00 a.m. – 12:00 p.m.Cost: $150.00Instructor: Heather Lyon

Formatting the Worksheet - Instructor-led Online Series - Excel Training
2023-08-03 13:00 - 16:00
Make your Excel workbooks look professional and readable by learning how to properlyformat all the aspects of your spreadsheet. In this 3-hour session, you will learn how towork with:

Formatting dates & numbers

Cell alignment

Fonts & sizes

Borders

Colours and patterns

Format painter

Themes & Styles

Conditional formatting

Date: August 3, 2023Time: 1:00 p.m. – 4:00 p.m.Cost: $150.00Instructor: Heather Lyon

Charts & Tables - Instructor-led Online Series - Excel Training
2023-08-03 09:00 - 12:00
In the Excel program, you can convert your data from a spreadsheet into a table and/orchart. Learn how you can turn dry financial and statistical information into a vibrant visualdisplay 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: August 3, 2023Time: 9:00 a.m. – 12:00 p.m.Cost: $150.00Instructor: Heather Lyon

Formulas & Functions - Instructor-led Online Series - Excel Training
2023-07-20 13:00 - 16:00
In this 3-hour session, learn how to set up formulas and functions to get the Excel programto 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: July 20, 2023Time: 1:00 p.m. – 4:00 p.m.Cost: $150.00Instructor: Heather Lyon

Formatting the Worksheet - Instructor-led Online Series - Excel Training
2023-07-20 09:00 - 12:00
Make your Excel workbooks look professional and readable by learning how to properlyformat all the aspects of your spreadsheet. In this 3-hour session, you will learn how towork with:

Formatting dates & numbers

Cell alignment

Fonts & sizes

Borders

Colours and patterns

Format painter

Themes & Styles

Conditional formatting

Date: July 20, 2023Time: 9:00 a.m. – 12:00 p.m.Cost: $150.00Instructor: Heather Lyon

Intro to Excel - Instructor-led Online Series
2023-07-06 13:00 - 16:00
This 3-hour session will introduce you to the capabilities of the MS Excel program. Learn thebasics 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: July 6, 2023Time: 1:00 p.m. – 4:00 p.m.Cost: $150.00Instructor: Heather Lyon

Formulas & Functions - Instructor-led Online Series - Excel Training
2023-07-06 09:00 - 12:00
In this 3-hour session, learn how to set up formulas and functions to get the Excel programto 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: July 6, 2023Time: 9:00 a.m. – 12:00 p.m.Cost: $150.00Instructor: Heather Lyon

Intro to Excel - Instructor-led Online Series
2023-06-22 09:00 - 12:00
This 3-hour session will introduce you to the capabilities of the MS Excel program. Learn thebasics 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: June 22, 2023Time: 9:00 a.m. – 12:00 p.m.Cost: $150.00Instructor: Heather Lyon

WRITING EFFECTIVE PROPOSALS – Instructor-Led Online
2023-06-07 09:00 - 2023-06-08 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: June 7 to 8, 2022Time: 9:00 a.m. – 4:00. p.m.Cost: $600.00Instructor: Heather Lyon
