Excel: Advanced

Excel: Advanced

Date(s): November 1, 2024

Time: 8:30 a.m. – 4 p.m.

Duration: One eight-hour session

Format: In-person (134 Eileen Stubbs Ave. Unit 103 Dartmouth, NS B3B 0A9)

 

Pricing:

 

Member Price: $400.00 + HST (WIPSI Discount $200.00 + HST FOR ELIGIBLE MEMBERS)

Non-Member Price: $525.00 + HST

 

Overview:

Perfect for anyone working in an office environment, this course is designed for people who have a strong history of using Microsoft Excel and feel comfortable utilizing the program. for basic and intermediate tasks. Students taking this course will expand their knowledge from basic math functionality to advanced computational data manipulation and analysis.

 

Learning Outcomes:

After taking this course you will be up to date with the latest and greatest excel functions and be able to manipulate substantial amounts of data and organize it in quickly adjustable visual representations using Pivot Tables. Using the Advanced Excel functionalities is all about saving you time. Macros are an Excel tool that takes user inputs and converts them to a code that can be run whenever you need, no longer will you need to manually adjust and write out repeat tasks. Power Queries will help you import or connect to external data and shape that data in a way that is functional for you.

 

Who Should Attend: This course is perfect for anyone who works in an office environment. Developing an understanding of Microsoft Excel will allow you to become more effective, more efficient, and more confident.

 

Facilitator: Andrew Smith 



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.