Mar 13, 2026  
2020-2021 Catalog 
    
2020-2021 Catalog [ARCHIVED CATALOG]

OFFT 2810 - 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
Credits: 3
Classroom Lecture Hours: 45
Prerequisite(s): BSAD 1020  or OFFT 2720 .