Target Audience:  This course was designed for students desiring to gain the skills necessary to create macros, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Upon successful completion of this course, students will be able to:

·         enhance productivity and efficiency by streamlining the workflow.

·         collaborate with other workbook users.

·         audit worksheets.

·         analyze data.

·         work with multiple workbooks.

·         import and export data.

·         integrate Excel data with the web.

·         structure workbooks with XML.

Course Content:

Lesson 1: Streamlining Workflow

Lesson 2: Collaborating with Other Users

Lesson 3: Auditing Worksheets

Lesson 4: Analyzing Data

Lesson 5: Working with Multiple Workbooks

Lesson 6: Importing and Exporting Data

Lesson 7: Integrating Excel Data with the Web

Lesson 8: Structuring Workbooks with XML