Des Moines Area Community College.

Course Descriptions

For a course description, enter course number(i.e. DATA103):   

If you don't know the entire Course Number,  please enter as much as you know. For example, if you are interested in Computer Science courses, enter COMS. 

Course
Number:
Course
Title:
Contact
Hours:
Description:
DATA507 Excel Advanced, 2007 7 Improve and expand your spreadsheet capabilities. You will create macros to streamline workflow; set up a workbook for multiple users; verify data validity with the auditing features; use data analysis tools to create scenarios and perform what-if analysis with the goal seek and solver features; quickly compare data in large worksheets using a Pivot Table; and work with multiple workbooks to consolidate data, create formulas to link different workbooks, and save the workspace. Prerequisites: Excel Intermediate or equivalent experience. Textbook included.