This course covers advanced applications for working with large amounts of data through analyzing, validating, formula auditing, complex problem solving, automating and collaborating. PivotTables and PivotCharts are covered, as are trendlines, Solver, Scenario Manager, Visual Basic for Applications code, macros, controls, and the Compare and Merge Workbooks feature.
OFAD-285 - MS Excel 3
Minimum Credits: 1.5
Length: 45 hours
Prerequisites: OFAD 155 or keyboarding placement assessment, OFAD 158, OFAD 180, OFAD 281
Delivery Method:
Online
Cost: $182.64
Course Outline: https://sps.cotr.bc.ca/Outlines/Course Outlines/OFAD285.pdf