Aurora College

Charts & Tables CMPT 0015 - Online
2025-03-13 09:00 - 12:00 (America/Inuvik)
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:March 13, 2025

Time:9:00 a.m. – Noon

Cost:$175.00

Instructor:Heather Lyon

Bookkeeper & Financial Officer Training – Part Three - Computerized Accounting - Online / Multi-Day
2025-03-31 09:00 - 2025-04-04 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.

DatesMarch 31 – April 4, 2025

Time9:00 a.m. – 4:00 p.m.

LocationOnline

InstructorHeather Lyon

Word Extras - Online
2025-04-01 09:00 - 12:00
You know the basics of the Word 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 Tabs

Envelopes & Labels

Mail Merge

Tracking Changes

Using comments

Proofing Tools

Headers & Footers

Page Numbering

Date:April 1, 2025

Time:9:00 a.m. – Noon

Cost:$175.00

Instructor:Heather Lyon

SPEAK UP, SPEAK OUT - Online
2025-04-15 09:00 - 16:00
SPEAK UP, SPEAK OUTOnline delivery

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:April 15, 2025

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

Cost:$350.00

Instructor:Heather Lyon

Writing & Editing Skills - Making the Message Clear - Multi-Day / Online
2025-04-28 09:00 - 2025-04-29 16:00
OverviewGood business writing leads to good business decisions, which leads to good business. This course emphasizes business writing (letters, memos, emails, documents, web material) with the reader and readability in mind. In two days you will focus on new formats, writing style, tone, clarity, conciseness and results while exploring new skills and time saving approaches.

Spend less time writing and more time communicating

Motivate and persuade readers to take action

Develop an active, objective and powerful writing style

Write sensitive or negative messages in a positive way

Understand the importance of word choice

Learn the implications of FOIP in written documentation

Prepare written information with objectivity and a results perspective

Develop time saving approaches to minute taking

Outline:Why is writing so difficult to do?Preparing to Write

Purpose

Audience

Tone

Choosing a Format

Emails/Memos

Business Letters

Reports

Advertising Material

Instructional Documents

Historical Records

Putting it All Together

Start with an Outline

Greetings & Introductions

Main body of the message

Wrapping things up

Proof-reading & Editing

Effective and Efficient

Clear & Simple

Vocabulary

Sentence length & structure

Paragraph length

Readability

Headings

Lists/Tables

Page Numbering

Underlining & Italics

Font size and weight

Graphics & Pictures

Mechanics of Writing

Correct word choice

Correct spelling

Comma usage

Capitalization

Numbers

Abbreviations

Latin expressions

Subjects & Verbs

Colons & Semi-colons

Best Practices & Practical Application

Emails/Memos

Business Letters

Reports

Advertising Material

Instructional Documents

Historical Records

Date:April 28 & 29, 2025

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

Location:Online

Cost:$600.00

Instructor:Heather Lyon

Northern Leadership Development Program (NLDP) – Level 1 – Open Series
2025-09-16 09:00 - 17:00
Are you an employer interested in supporting emerging leaders on your team? Are there talented Northerners in your organization who have the potential to take on management, supervisory or leadership positions? Are there individuals on your team new to supervisory or managerial roles? Are you looking for a cost-effective way to provide these individuals with the skills and knowledge to advance within your organization? If so, Aurora College has the program for you.

Aurora College is pleased to offer the Northern Leadership Development Program (NLDP). Over the past 14 years, the NLDP has provided leadership education to more than 150 leaders across the Northwest Territories.

NLDP consists of nine modules. Each module is 21 hours in length. The modules will be offered as a combination of in-person and online settings.

Pre-Entry Workshop (ONLINE) September 16, 2025

Personal Development (in person) September 22, 23, 24, & 25, 2025

Communication Skills/ Coach Mentoring (in person) October 20, 21, 22 & 23, 2025

Effective Personal Leadership (ONLINE) November 24, 25, 26 & 27, 2025

Effective Team Leadership (in person) January 12, 13, 14 & 15, 2026

Conflict Management (in person) February 9, 10, 11 & 12, 2026

Leading While Managing (ONLINE) March 9, 10, 11 & 12, 2026

Problem Solving and Decision Making (in person) April 13, 14, 15 & 16, 2026

Diversity-Conscious Leadership (ONLINE) May 4, 5, 6 & 7, 2026

Leadership in Action / Coach Mentoring (in person) June 15, 16, 17 & 18, 2026

NLDP is more than just a conventional leadership program; it is designed to fundamentally change how participants view leadership, themselves, and their communities. The program fosters deep self-awareness, challenges existing beliefs, and encourages participants to develop a vision that aligns with the unique cultural, social, and economic contexts of the North. By emphasizing transformation, the NLDP aims to create leaders who can drive sustainable change in their communities.

For more information, please contact:

Karen Horn, Coordinator, Continuing Education ProgramsAurora College, Yellowknife/North Slave Campus867-920-8802khorn@auroracollege.ca

Wanda Roberts, BN, RN, M. Ed, Instructor, Northern Leadership Development ProgramAurora College, Yellowknife/North Slave Campus867-767-8205wroberts@auroracollege.ca

C.O.R.E De-Escalation - Multi-Day / Online
2025-10-09 09:00 - 2025-10-10 16:00
C.O.R.E De-EscalationCreating Opportunities with Respect & Empathy

Introduction

Introduction Sequence

Traditional lecture vs. skill based learning

De-escalation Overview

Goals of the course

Part I: Realizing Expectations

Being a professional brings expectations from:

The organization, the public, the media and the courts

Natural reactions in the face of conflict – Fight, Flight or Freeze

Exceptions are those who benefited from: great parents, great mentors, the Anvil of Experience (making mistakes) or effective training Experience Alone is No Guarantee of Success – Ericsson’s 10,000 hr. principle

Intergenerational Communication

For the first time, we are seeing Grandparents working on teams that contain persons their grandchildren’s age. Dr. Mary Donahoe

The Impact of Technology on Interpersonal Communication

Video Technology has created a new reality, the power of social media

Part II: It’s Not Personal!

Rationalizing the Irrational

People under the influence of negative emotions can appear irrational

Their attacks can be very personal and offensive

People Don’t Mean What They Say …

Words and meanings can be (and usually are), completely different

We need to ignore the words and search for the correct meanings

Don’t Take the Bait – 80% of Complaints Stem from Our Reaction

EGO Is the Enemy

Ultimately, that voice in our head that makes us do and say things that we never planned on doing or saying!

Compliance vs. Cooperation – Separating attitude from behavior

The Unanswered Question – the appropriate response to verbal resistance

Part III: The Learned Response Confidence In Conflict – Confidence comes from skill acquisition and skill development Aristotle – ‘Audiences Are Made, Not Found’ and the 3 Appeals Emotional Intelligence:Knowing who we are and what our role is (moral compass) Recognizing our emotions (and only perform the positive ones) Recognizing the emotions of others (empathy) Using this awareness to start building a relationship THE 93% RULE – It’s not what you say, it’s how you say it!

Breath! – Control your heart rate and prevent your emotions from ‘high jacking’ you

C.O.R.E. Philosophy

By recognizing and controlling our negative emotions, we can now perform only positive emotions. This mindset allows us to see opportunity in conflict as we endeavor to maintain the high ground by showing respect and diffusing the other with empathy

PROFESSIONAL RESPECT

Performed respect forms the basis of a healthy relationship

PROFESSIONAL EMPATHY

Essential for diffusing a difficult encounter – empathy absorbs tension

Part IV: Communication Essentials

Active Listening Revisited – Finding the meanings behind the words

The Power of Paraphrasing – the ultimate communication tool

Digging Deeper – asking the appropriate questions at the appropriate time

Providing Real Options – The essence of persuasion

Part V: Practical Application

Personal Security Awareness

Imminent Jeopardy

Proxemics

De-escalation Phrases – demonstrate that you are listening – refocus the contact

C.O.R.E. PROCESS

Introduction Sequence

Clarify – ask the $1,000,000 question

Establish Context– tactfully minimize resistance, build upon credibility

Proceed OR Persuade – Verify

Conclude

Case Study – application of C.O.R.E. techniques to actual events

Scenario Development – Practical application

Skill building – Introduction Sequence with De-escalation phrases

Skill building – Clarifying Sequence

Skill building – Putting it all together, no resistance

Skill building – Minimal Resistance – persuasion

Skill building – Medium Resistance – persuasion – Verify

The Ethical Protector Creed and Closing Remarks

Date:October 9 & 10, 2025

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

Cost:$550.00

Instructor:Darcy Pennock

Location:Online via Zoom

Northern Leadership Development Program (NLDP) – Level 2, Leadership in Action – Open Series
2025-10-14 09:00 - 17:00
The Northern Leadership Development Program (NLDP) Level 2 delivery will focus on applied leadership principles and skills for NLDP graduates, or current northern leaders who have other leadership training and/or experience. Level 2 mirrors the delivery of Level 1 Modules 1 – 9, going further in-depth with specific focus on leadership in action.

NLDP Level 2 is a comprehensive program designed to provide leaders with advanced knowledge, skills, and tools to lead their teams and organizations effectively. This program is best suited for experienced leaders who are looking to develop and enhance their leadership abilities to take on increasingly challenges that are more significant.

NLDP Level 2 incorporates a combination of classroom learning, individual coaching, group workshops, and experiential learning activities. The focus is on developing skills in areas such as strategic thinking, decision-making, communication, conflict resolution, change management, and team building. Emphasis will be placed on application of learning between modules, with time to review concepts and develop applied learning plans during module delivery.

NLDP Lever 2 consists of nine modules. Each module, except for Modules 1 and 9, is 15 hours in length. The modules will be offered as a combination of in-person and online settings.

Pre-entry Workshop (online) October 14, 2025

Module 1 – Personal Development (in person) November 12 – 14, 2025

Module 2 – Communication Skills/ Coach Mentoring (in person) December 16 & 17, 2025

Module 3 – Effective Personal Leadership (online) January 20 & 21, 2026

Module 4 – Effective Team Leadership (online) February 17 & 18, 2026

Module 5 – Conflict Management (in person) March 3 & 4, 2026

Module 6 – Leading While Managing (online) March 31 & April 1, 2026

Module 7 – Problem Solving and Decision Making (online) April 21 & 22, 2026

Module 8 – Diversity-Conscious Leadership (online) May 12 & 13, 2026

Module 9 – Leadership in Action / Coach Mentoring (in person) June 9, 10 & 11, 2026

NLDP is more than just a conventional leadership program; it is designed to fundamentally change how participants view leadership, themselves, and their communities. The program fosters deep self-awareness, challenges existing beliefs, and encourages participants to develop a vision that aligns with the unique cultural, social, and economic contexts of the North. By emphasizing transformation, the NLDP aims to create leaders who can drive sustainable change in their communities.

For more information, please contact:

Karen Horn, Coordinator, Continuing Education ProgramsAurora College, Yellowknife/North Slave Campus867-920-8802khorn@auroracollege.ca

Wanda Roberts, BN, RN, M. Ed, Instructor, Northern Leadership Development ProgramAurora College, Yellowknife/North Slave Campus867-767-8205wroberts@auroracollege.ca

Minute Taking (MGMT 0010) - Online
2025-10-22 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.

Your Role

Meeting Preparation

Working with the Chair

Recording

Distribution

Meeting Preparation

Agenda Preparation

Notifying & Confirming Attendance

Preparing the Room

Working with the Chair

Improved Communication

Understanding Objectives

Follow-up and Approval

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

Distribution

Who gets a copy?

Storing the original

Preparing for next meeting

Date Wednesday, October 22, 2025

Time9 a.m. to 4 p.m.

LocationOnline

InstructorHeather Lyon

Intro to Excel CMPT 0012 - Online
2025-11-03 13:00 - 16:00
This three-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:November 3, 2025

Time:1 p.m. – 4 p.m.

InstructorHeather Lyon

Speak Up, Speak Out - Online
2025-11-06 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:November 6, 2025

Time:9 a.m. – 4 p.m.

Cost:$350.00

Instructor:Heather Lyon

Formatting the Worksheet CMPT 0014 - Online
2025-11-17 13:00 - 16:00
Make your Excel workbooks look professional and readable by learning how to properly format all the aspects of your spreadsheet. In this three-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:November 17, 2025

Time:1 p.m. – 4 p.m.

Cost:$175.00

Instructor:Heather Lyon

Charts & Tables CMPT 0015 - Online
2025-11-24 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:November 24, 2025

Time:1 p.m. – 4 p.m.

Cost:$175.00

Instructor:Heather Lyon

Excel Extras - Online
2025-12-01 13:00 - 16: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: December 1, 2025Time: 1:00 p.m. – 4:00 p.m.Cost: $175.00Instructor: Heather Lyon

Minute Taking - Online
2025-12-04 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: December 4, 2025Time: 9:00 a.m. to 4:00 p.m.Location: OnlineTuition: $350.00Instructor: Heather Lyon

BOOKKEEPER & FINANCIAL OFFICER TRAINING PART ONE – INTRO TO ACCOUNTING (ACCT 0011) - Online / Multi-Day
2025-12-08 09:00 - 2025-12-10 16:00
This three-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 online 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 system

Be familiar with the steps involved in the annual accounting cycle

Understand the five account categories used in accounting

Understand Debits & Credits

DatesDecember 8 – 10, 2025

Time9 a.m. – 4 p.m.

LocationOnline

InstructorHeather Lyon

Bookkeeper & Financial Officer Training Part Two – Reading and Understanding Financial Statements - Online / Multi-Day
2025-12-15 09:00 - 2025-12-16 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 works

To develop an understanding of the principles of accounting used in financial statements

To learn what information is included in a balance sheet

To learn what information is included in an income statement

To learn how to analyze the information in financial statements

To learn how to read a statement of cash flows

DatesDecember 15 – 16, 2025

Time9 a.m. – 4 p.m.

LocationOnline

InstructorHeather Lyon

Bookkeeper & Financial Officer Training – Part Three - Computerized Accounting - Online / Multi-Day
2026-01-19 09:00 - 16:00, 2026-01-20 09:00 - 16:00, 2026-01-21 09:00 - 16:00, 2026-01-26 09:00 - 16:00, 2026-01-27 09:00 - 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 five-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.

DatesJanuary 19, 20, 21, 26, & 27, 2026

Time9 a.m. – 4 p.m.

LocationOnline

InstructorHeather Lyon

C.O.R.E De-Escalation - Online
2026-02-05 09:00 - 2026-02-06 16:00
Creating Opportunities with Respect & Empathy

Introduction

Introduction Sequence

Traditional lecture vs. skill based learning

De-escalation Overview

Goals of the course

Part I: Realizing Expectations

Being a professional brings expectations from:

The organization, the public, the media and the courts

Natural reactions in the face of conflict – Fight, Flight or Freeze

Exceptions are those who benefited from: great parents, great mentors, the Anvil of Experience (making mistakes) or effective training Experience Alone is No Guarantee of Success – Ericsson’s 10,000 hr. principle

Intergenerational Communication

For the first time, we are seeing Grandparents working on teams that contain persons their grandchildren’s age. Dr. Mary Donahoe

The Impact of Technology on Interpersonal Communication

Video Technology has created a new reality, the power of social media

Part II: It’s Not Personal!

Rationalizing the Irrational

People under the influence of negative emotions can appear irrational

Their attacks can be very personal and offensive

People Don’t Mean What They Say …

Words and meanings can be (and usually are), completely different

We need to ignore the words and search for the correct meanings

Don’t Take the Bait – 80% of Complaints Stem from Our Reaction

EGO Is the Enemy

Ultimately, that voice in our head that makes us do and say things that we never planned on doing or saying!

Compliance vs. Cooperation – Separating attitude from behavior

The Unanswered Question – the appropriate response to verbal resistance

Part III: The Learned Response

Confidence In Conflict – Confidence comes from skill acquisition and skill development Aristotle – ‘Audiences Are Made, Not Found’ and the 3 Appeals Emotional Intelligence:

Knowing who we are and what our role is (moral compass) Recognizing our emotions (and only perform the positive ones) Recognizing the emotions of others (empathy) Using this awareness to start building a relationship THE 93% RULE – It’s not what you say, it’s how you say it!

Breath! – Control your heart rate and prevent your emotions from ‘high jacking’ you

C.O.R.E. Philosophy

By recognizing and controlling our negative emotions, we can now perform only positive emotions. This mindset allows us to see opportunity in conflict as we endeavor to maintain the high ground by showing respect and diffusing the other with empathy

PROFESSIONAL RESPECT

Performed respect forms the basis of a healthy relationship

PROFESSIONAL EMPATHY

Essential for diffusing a difficult encounter – empathy absorbs tension

Part IV: Communication Essentials

Active Listening Revisited – Finding the meanings behind the words

The Power of Paraphrasing – the ultimate communication tool

Digging Deeper – asking the appropriate questions at the appropriate time

Providing Real Options – The essence of persuasion

Part V: Practical Application

Personal Security Awareness

Imminent Jeopardy

Proxemics

De-escalation Phrases – demonstrate that you are listening – refocus the contact

C.O.R.E. PROCESS

Introduction Sequence

Clarify – ask the $1,000,000 question

Establish Context– tactfully minimize resistance, build upon credibility

Proceed OR Persuade – Verify

Conclude

Case Study – application of C.O.R.E. techniques to actual events

Scenario Development – Practical application

Skill building – Introduction Sequence with De-escalation phrases

Skill building – Clarifying Sequence

Skill building – Putting it all together, no resistance

Skill building – Minimal Resistance – persuasion

Skill building – Medium Resistance – persuasion – Verify

The Ethical Protector Creed and Closing Remarks

Date: February 5 & 6, 2026Time: 9:00 a.m. – 4:00 p.m.Cost: $550.00Instructor: Darcy PennockLocation: Online via Zoom

High-Impact AI Workflow: An Introduction to Increasing Your Output With Better Prompts – Online Workshop
2026-02-09 13:00 - 16:00
This three-hour intensive workshop is designed for professionals, managers, and individual contributors ready to move beyond basic AI queries and leverage generative tools (like Gemini, ChatGPT, or Copilot) for a strategic advantage. You’ll explore a Prompt Engineering Framework—a core skill for professional output—and learn high-impact workflows for communication, research, and project planning. Leave with practical, ethical skills to confidently integrate AI into your daily routine, immediately saving time and significantly boosting your overall work output.

Participants will need access to Zoom, the internet and access to a generative AI tool such as Google Gemini, ChatGPT, CoPilot, etc.

Dates: February 9th, 2026Times: 1:00 p.m. – 4:00 p.m.Location: OnlineInstructor: Jeff O’Keefe

High-Impact AI Workflow: An Introduction to Increasing Your Output With Better Prompts - Online
2026-03-02 09:30 - 12:00
This three-hour intensive workshop is designed for professionals, managers, and individual contributors ready to move beyond basic AI queries and leverage generative tools (like Gemini, ChatGPT, or Copilot) for a strategic advantage. You’ll explore a Prompt Engineering Framework—a core skill for professional output—and learn high-impact workflows for communication, research, and project planning. Leave with practical, ethical skills to confidently integrate AI into your daily routine, immediately saving time and significantly boosting your overall work output.

Participants will need access to Zoom, the internet and access to a generative AI tool such as Google Gemini, ChatGPT, CoPilot, etc.

Dates: March 2nd, 2026Times: 9:00 a.m. – NoonLocation: OnlineInstructor: Jeff O’KeefeCost: $175.00

Intro to Excel - Online
2026-03-19 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: March 19, 2026Time: 9:00 a.m. – NoonCost: $175.00Instructor: Heather Lyon

Formulas & Functions - Online
2026-03-26 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: 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

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
