Course details:
- Date: October 13, 2026
- Time: 8:30 a.m. – 4 p.m.
- Duration: One session (7.5 hours each)
- Location: In-person at CANS Dartmouth Office
- Gold Seal accreditation: 2 credits
- Pricing:
- · Member: $445 + HST (WIPSI discount $222.50 + HST for eligible members)
- · Non-Member: $575 + HST
-
Overview:
Designed for experienced users, this course introduces advanced Excel tools for managing complex data and improving workflow efficiency. Participants learn to build dynamic reports and automate processes.
Learning Objectives:
-
- · Create and analyze data using pivot tables
- · Automate tasks using macros
- · Import and transform data using Power Query
- · Develop efficient workflows for large data sets
Facilitator: Andrew Smith (Andrew Smith Engineering)
If you are unable to attend in person, please contact Anna Swimm at aswimm@cans.ns.ca to make arrangements.
Please note: This is a peanut-free office space.
Cancellation Policy
-Cancellations must be received no later than 10 business days prior to the course date to be eligible for a 75% refund of registration fees.
-No refunds will be issued after this date.
-If you register for the course and do not attend, you are liable for the full registration fee unless you cancel according to the terms stated above.
-If you are unable to attend after registering you may send a substitute up to and including the day of the course. Please provide a name and email address for name tag and records.
-CANS reserves the right to cancel any course and will, in such an event, provide a full refund of registrations fees. Every effort will be made to give registrants a reasonable notice of cancellation.
-No liability is assumed by the organization for changes in course dates, content, speakers, or venue.