College Gallery


Course Description

This six-hour session is for people who have used the Excel program but want to learn about some of the additional features in the program. Learn how to create and work with charts and tables, and how to analyze your data through the power of pivot tables. You will also explore other features that make it easier to find and organize data, especially when working with large spreadsheets. Lastly, you will learn a few tools to save you time when working with Excel.

Topics include:
- Charts vs. tables
- Creating a chart
- Changing chart types
- Changing chart layout and location
- Using sparklines
- Creating a table
- Creating a Pivot table
- Using Pivot tables to analyze data
- Sorting and filtering
- Using comments
- Add drop-down lists
- Grouping and subtotals
- Automatic Subtotals
- Using hyperlinks
- Quick analysis

Course Number



Withdrawals and Refunds

 Your registration will be fully refunded when notice of withdrawal is given three (3) working days before the course start date. When notification is received less than three (3) full days before the course start date no refund will be issued. If you are unable to attend your course, you may arrange for someone to take your place by contacting Continuing Education & Corporate Training at or 780-849-8623.


Northern Lakes College reserves the right to re-schedule or cancel a course that lacks sufficient registrations to provide a satisfactory learning atmosphere. In this event your registration fee will be refunded in full or applied to the re-scheduled course.

Fee Payment

Fee Payment: Fees are due at the time of registration. Northern Lakes College accepts cash, cheque, money order, debit, VISA, MasterCard, American Express. Invoicing to a company requires a Purchase Order (PO).