Mar 11, 2026  
2022-2023 Catalog 
    
2022-2023 Catalog [ARCHIVED CATALOG]


SYLLABUS

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
Lab Hours: 0
Prerequisite(s): BSAD 1020  or OFFT 2720 .