Excel - Advanced

Code: COMP1912

Course description

This course builds on the knowledge gained in the Excel course. Emphasis will be placed on organizing and consolidating data with efficient multi-sheet models; applying arrays and formulas to new and powerful uses; working in an OLE (Object-Linking and Embedding) environment; recording and editing macros; advanced charting; utilizing scenarios; pivot tables; and finding the best solution using Solver.

Course details

Hours: 36
Credits: 3
Prerequisites: None
Corequisites: None

Want to complete a program?

Learn how to build courses into a credential. This course is part of the following program(s):


 
Start Date
Day/Time
Delivery
Campus
Cost
Availability
Start Date: Jan. 15, 2019
Day/Time: Tues. 6:30pm – 9:30pm
Delivery: Classroom
Campus: Doon (Kitchener)
Cost: $288.48
 
End date: Apr. 2, 2019
Hours: 36
Credits: 3
Prerequisites: None
Corequisites: None
Equivalent to: OLRN1303
Start Date: Jan. 21, 2019
Day/Time:
Delivery: Mixed
Campus: Doon (Kitchener)
Cost: $288.48
 
End date: Apr. 8, 2019
Hours: 36
Credits: 3
Prerequisites: None
Corequisites: None
Equivalent to: OLRN1303

Mandatory in-class dates:

2019-01-21 Mon. 6:30pm – 9:30pm

2019-02-25 Mon. 6:30pm – 9:30pm

2019-04-08 Mon. 6:30pm – 9:30pm

Not all courses are offered each term. Spring 2019 registration opens February 4, 2019. Fall 2019 registration opens July 8, 2019.