We are currently experiencing technical issues related to discount code usage on registrations. The issue is being investigated. If you intend to use a discount code, please delay your registration until this message is removed from our website. If you are not using a discount code, you will not be impacted and can register immediately.

Share

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.

This class is taught in Microsoft Office 2013. The UWM-SCE computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.

Instructor

Greg Patterson

Greg Patterson

Greg Patterson is president and CEO of Great Lakes Training and Consulting. As president, Greg has conducted training for many companies, including several Fortune 500 companies. Mr. Patterson has trained small and large companies within the Unites States and internationally. ... read more

Course Outline/Topics

Course Content Microsoft Excel Level III

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously

Use 3-D References
Use Links and External References
Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

Collaborate on a Workbook
Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

Apply Data Validation
Work with Forms and Controls
Work with Macros

Lesson 4: Applying Conditional Logic

Use Lookup Functions
Combine Functions
Use Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets

Trace Cells
Search for Invalid Data and Formulas with Errors
Watch and Evaluate Formulas

Lesson 6: Using Automated Analysis Tools

Determine Potential Outcomes Using Data Tables
Determine Potential Outcomes Using Scenarios
Use the Goal Seek Feature
Activate and Use the Solver Tool
Analyze Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually

Use Advanced Chart Features
Create Sparklines

Prerequisites

Excel 2010/2013 – Level II (or equivalent experience)

Notes

Public courses on Microsoft Excel and Access are taught in Office 2013. If you are using Office 2010 – the functions and features you  learn are similar to 2013 and can be applied in the 2010 environment. If you would like group training on any MS Office 2010 programs, please contact Pam Nellen at nellenp@uwm.edu or 414-227-3208.

Testimonials

"Love the instructor’s ability to tailor the educational process to meet the needs of the students in the class."  —  Program Policy and Analyst, 2019

"Greg Patterson was very detailed and understandable. I really appreciated that we were able to focus on personal needs as well as cover class materials. We were able to get all questions answered and still completed all the material."  —  International Sales Analyst, 2019

All sessions are Face-to-Face unless otherwise noted.

Date: Tue, Mar 10

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee:

$249 by Tue., Feb. 25.
$274 after Tue., Feb. 25.

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-12567

Registration Deadline: Tue., Mar. 10

Register Now

Date: Wed, June 17

Time: 8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee:

$249 by Wed., June 3.
$274 after Wed., June 3.

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-12553

Registration Deadline: Wed., June 17

Register Now

Share