School of Continuing EducationRegistration InformationContact UsUWM HomeShopping Cart
UWM logo

SCE HomepageDean's WelcomeCourses & ProgramsCertificate ProgramsDistance EducationCalendarSpecial EventsDepartments & CentersCommunity ResearchInternationalCenter for the Study of the WorkplaceFaculty & StaffCustomized TrainingKeep Me Posted

Connect With Us

HomeCourses & ProgramsCertificate ProgramsCustomized TrainingFaculty & Staff

Microsoft Excel Level III


Microsoft Excel allows users to create and manage spreadsheets to manipulate data used in personal finance, budget preparation, financial and investment analysis, business modeling, sales forecasting and other calculating and analytical applications.

For specific topics covered in Excel Level III, click on Course Outline/Topics below:

Course Outline/Topics

Course Content Microsoft Excel Level III

Lesson 1: Streamlining Workflow

Update Workbook Properties

Create a Macro

Edit a Macro

Apply Conditional Formatting

Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

Protect Files

Share a Workbook

Set Revision Tracking

Review Tracked Revisions

Merge Workbooks

Administer Digital Signatures

Restrict Document Access

Lesson 3: Auditing Worksheets

Trace Cells

Troubleshoot Invalid Data and Formula Errors

Watch and Evaluate Formulas

Create a Data List Outline

Lesson 4: Analyzing Data

Create a Trendline

Create Sparklines

Create Scenarios

Perform a What-If Analysis

Perform a Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

Create a Workspace

Consolidate Data

Link Cells in Different Workbooks

Edit Links

Lesson 6: Importing and Exporting Data

Export Excel Data

Import a Delimited Text File

Lesson 7: Integrating Excel Data with the Web

Publish a Worksheet to the Web

Import Data from the Web

Create a Web Query

Close ▲

Excel 2007/2010 - Level II (or equivalent experience)
This course is taught using Microsoft Office 2010. If you are interested in training using Microsoft Office 2013, please contact us for more information.

"Greg Patterson was very entertaining and knowledgeable about the subject and how to apply it. The examples were well written to show how to use the techniques."
student, 2014

"I think this program was structured/tailored to equip us with tools we need to start solving some real world problems. The instructor was ready to assist everyone to ensure they understood the material."
student, 2014

Wed., July 22
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
Enrollment Limit: 20
Program No. 5070-7372
Register Now
Tue., Apr. 5, 2016
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8503
Register Now
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs,, 414-227-3208


Spring 2015 Business Programs Catalog

Or download the pdf