OFFT-2290 - Spreadsheet & Database Apps
Prerequisite: BSAD1020. Advanced skills are needed in the workplace for Microsoft Excel and Microsoft Access. Topics covered in Microsoft Excel are Formulas, Financial Functions, What-If Analysis, Sorting and Querying a Table, VLOOKUP Function, PivotTable Reports, and Macros. Topics covered in Microsoft Access are Querying a Database, Maintaining a Database, and Creating Reports and Forms.