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 ProgramsFaculty & Staff

Microsoft Excel Level II


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 II, click on Course Outline/Topics below:

Course Outline/Topics

Course Content Microsoft Excel Level II

Lesson 1: Calculating Data with Advanced Formulas

Apply Cell and Range Names

Calculate Data Across Worksheets

Use Specialized Functions

Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

Create and Modify Tables

Format Tables

Sort or Filter Data

Use Functions to Calculate Data

Lesson 3: Presenting Data Using Charts

Create a Chart

Modify Charts

Format Charts

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

Create a PivotTable Report

Filter Data Using Slicers

Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

Insert and Modify Pictures and ClipArt

Draw and Modify Shapes

Illustrate Workflow Using SmartArt Graphics

Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing the Excel Environment

Customize the Excel Environment

Customize Workbooks

Manage Themes

Create and Use Templates

Close ▲

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

"Greg is a great instructor! The program was well taught and easy to follow. The workbook will prove to be a valuable resource going forward to reinforce the lessons from class."
student, 2014

"This was probably the best and most useful training that I have ever attended!"
student, 2014

"This course is very useful for the type of data analysis I do on a daily basis. I learned many new tips to help me create, sort, slice and dice data to create useful reports, which will help make better business decisions."
Student, 2015

Tue., June 23
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
Enrollment Limit: 20
Program No. 5070-7370
Register Now
  Related Courses  
Microsoft Excel Level III
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs,, 414-227-3208


Marketing & Technology Spring 2015 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf