OFFT2810 — Advanced Spreadsheet Applications
Advanced spreadsheet skills needed in the workplace using Microsoft Excel. Topics covered are basic & advanced formulas, financial functions, statistical functions, what-if analysis, sorting and querying a table, extracting records from a table, PivotTable reports & charts, Scenario Manager, templates, data validation and basic macros. Location: L/O Classroom
Prerequisites: BSAD1020, OFFT2720