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 ▲

Prerequisites
Excel 2007/2010 - Level I (or equivalent experience)
Notes
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 an excellent program that will help me complete my day-to-day responsibilities. I am very appreciative of the opportunity to take this course. The instructor made things easy to understand and was patient with everyone."
student, 2014

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

  Sessions  
Wed., Oct. 15
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$224
Enrollment Limit: 20
Program No. 5070-7361
Register Now
 
Thu., Feb. 19, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$224
Enrollment Limit: 20
Program No. 5070-7388
Register Now
 
Tue., June 23, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$224
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, nellenp@uwm.edu, 414-227-3208
 

Features

Marketing & Technology Fall 2014 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf

In Partnership with
American Marketing Association


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>>