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 ▲

Prerequisites
Excel 2007/2010 - Level II (or equivalent experience)
Notes
Due to the close similarities, this course will be taught from 2010 with differences of 2007 explained.

"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

  Sessions  
Thu., Nov. 20
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
Fee: $224
Enrollment Limit: 20
Program No. 5070-7364
Register Now
 
Wed., Mar. 25, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
Fee: $224
Enrollment Limit: 20
Program No. 5070-7385
Register Now
 
Wed., July 22, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
Fee: $224
Enrollment Limit: 20
Program No. 5070-7372
Register Now
 
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

Spring 2014 Business Programs Catalog

Or download the pdf


Center for the Study of the Workplace
Learn about the real-world impact of workplace changes. Hear what leaders in both business and academia have to say and help propel yourself or your company into the future.
Learn more>>