CMAP 252 - Spreadsheet Applications

Provides study in the creation, design, and use of spreadsheets for business applications. Emphasis focuses on formatting and enhancing spreadsheets, maintaining workbooks, working with lists, using appropriate functions, interpreting data, and template design. PREREQUISITE(S): CMAP 120 or consent of department. Three hours each week. Formerly CA 252.

3 semester hours

Course Outcomes:
Upon course completion, a student will be able to:

Create named ranges and reference range names in formulas and functions
Link data between multiple worksheets and workbooks
Perform financial calculations with functions such as PMT and FV
Provide varied results based on spreadsheet conditions by utilizing IF, nested IF, and LOOKUP functions as well as conditional formats
Answer “what if” questions with tools such as PivotTables, the Scenario Manager, Goal Seek, and Data Tables
Sort, filter, and query data from a list or table, and ensure correct information is entered with data validation
Automate document formatting and multi-step procedures with templates and macros
Import data from and export data to other applications and web pages

View Schedule of Classes