Aurora College

Excel Advanced – Instructor-led Online Series
2024-03-26 09:00 - 16:00 (America/Inuvik)
This two 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: March 19 & 26, 2024

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

Cost: $700.00

Location: Online

Instructor: Heather Lyon

Teaching and Learning at a Distance - Online / Multi-day
2024-03-26 19:00 - 22:00
This course is a practical exploration of techniques, systems, challenges, and benefits associated with distance education for adult educators in the North. It focuses on preparing teachers to facilitate distance learning based on their prior knowledge of adult learning, communication theory, and technology. Students will explore the use of relevant technology and appropriate instructional design in distance education. In addition, participants will investigate ways to establish a community of learning in an online course. Students will make use of Aurora College software platforms to learn how to create and deliver a distance learning course, in the context of the contemporary environment. Specifically, consideration will be given to how we can enhance connectivity and better simulate in-person learning using technology in a social distancing environment. The course uses Moodle, Teams, Zoom, and may include other platforms.

PrerequisiteElements of Instruction

DatesMarch 19th, 26th, April 2nd, 9th, 16th, 23rd, 30th, and May 7th

Time7:00 p.m. – 10:00 p.m.

LocationOnline via TEAMS/Moodle

TextbooksTBD

InstructorHannah Vedamani
