MS Excel Level III, CMP959

Learn advanced features of MS Excel 2007 -- how to create and edit macros and apply conditional formatting to streamline workflow. Modify workbook and file properties and use Excel’s web publisher and XML exchange features.  Master complex decision-making functions with a click of the mouse.  Work with multiple workbooks and files to consolidate data.

Prerequisites: MS Excel--Levels I and II or equivalent experience.

Textbook: Purchase at the Rockville Campus Bookstore, bring textbook to first class along with a USB Flash Drive/memory stick (at least 512 MB).

Classroom Hours: 10

Course Content

Lesson 1 - Streamlining Workflow

Lesson 2: Collaborating With Others

Lesson 3: Auditing Worksheets

Lesson 4: Analyzing Data

Lesson 5: Working with Multiple Workbooks

Lesson 6: Importing and Exporting Data

Lesson 7: Using Excel and Exporting Data

Lesson 8: Structuring XML Workbooks