Visit uwm.edu/sce/coronavirus for current protocols and updates.

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

We are now offering both in-person and live online sessions. Check session details for format.

To participate in live online courses, you must have

• a computer
• reliable internet connectivity
• Microsoft Excel version 2016 or later preferably
• computer audio or headphones with microphone
• webcam, built-in or added – strongly recommended for interaction with the instructor and class participants

## Instructor

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

Create Sparklines

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

Date: Wed, Nov 9

Delivery Method: In-person

Time: 8:30am-4:30pm CT

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee:

\$249 by Oct 26
\$274 after Oct 26

CEUs: .7

Enrollment Limit: 15

Program Number: 5070-14646

Date: Tue-Wed, Mar 14-15, 2023

Delivery Method: Live Online

Time: 8am-Noon CT

Platform: Zoom

Instructor: Greg Patterson

Fee:

\$249 by Feb 28, 2023
\$274 after Feb 28, 2023

CEUs: .7

Enrollment Limit: 10

Program Number: 5070-14643

Note: Participants will receive an email with instructions for logging into Canvas to access course materials and Zoom links prior to first class.