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

  Sessions  
Wed., Oct. 21
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8500
Register Now
 
Thu., Feb. 25, 2016
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8501
Register Now
 
Tue., June 21, 2016
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8549
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 Spring 2015 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf