OFAD-285 - MS Excel 3

Minimum Credits: 1.5 Length: 45 hours Prerequisites: OFAD 155 or keyboarding placement assessment, OFAD 157, OFAD 158, OFAD 181, OFAD 281 Delivery Method: Online Cost: $175.56 Course Outline: https://sps.cotr.bc.ca/Outlines/Course Outlines/OFAD285.pdf

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.