OFAD 2410 Excel II

4 Credit Hour(s)

This course teaches the advanced Microsoft Excel features needed for the expert user. Topics include custom and conditional formatting, importing and exporting data, using range names, use of templates, managing multiple workbooks, consolidating worksheets, workgroup functions and security, auditing features, and macros. Also included are use of Excel databases, PivotTables, and data analysis tools such as Goal Seek, Solver, and Scenarios. This course meets Expert MOS certification requirements.

Prerequisite(s): OFAD 1410