av¸£ÀûÒ»¶þÇø

Home > Programs > Continuing Ed and Part Time Studies > Course Details

Microsoft Office: Excel Intermediate


Course Section: CECOMP-MSEI-1029

Description
In this intermediate Excel course, you will master complex functionalities to improve data management and analysis efficiency. You'll learn advanced worksheet management, including grouping and linking, and enhance your formula skills with relative, absolute, and mixed references. The course covers advanced functions like SUM, AVERAGE, MIN, MAX, and COUNT, and teaches data analysis and visualization through sorting, analyzing, and creating charts. An introduction to Pivot Tables will be provided, as well as data validation and security techniques and the use of Excel add-ins. Essential keyboard shortcuts to boost workflow efficiency are also included. By the end of this course, you'll be proficient in managing, analyzing, and visualizing data with intermediate Excel features.

Additional Information

Credit Related Information:
This is an Industry Standard Credit.

Instructor:
Juliana MacEwen

Course Cost
$150.00 + HST

Duration
7 hour(s)

Course Details
Start Date End Date Location
Oct 29, 2025 Nov 12, 2025 Prince of Wales Campus
Day(s) From To Room
Wednesday 9:00:00 AM 4:00:00 PM 110W