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 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
"Good examples; Greg is a wonderful instructor–allows time for questions and is very patient with the class members. Hands-on learning is very helpful. Thank you!" — Jennifer Becker, United Healthcare
"Greg is the best instructor I have ever had for a computer class. He makes things interesting and makes it easy to follow along with him. Usually when I know something I tend to lose focus, but Greg is great at keeping me focused on the class. I learned a few different things from all 3 classes. I would highly recommend this class to others. Thank you Greg and Joel for all that you do!" — Participant, 2018
All sessions are Face-to-Face unless otherwise noted.
Date: Wed, Nov 6
Time: 8:30am-4:30pm
Location: UWM School of Continuing Education
Instructor: Greg Patterson
Fee:
$249 by Wed., Oct. 23.
$274 after Wed., Oct. 23.
CEUs: 0.7
Enrollment Limit: 20
Program Number: 5070-12272
Registration Deadline: Wed., Nov. 6
Date: Tue, Mar 10, 2020
Time: 8:30am-4:30pm
Location: UWM School of Continuing Education
Instructor: Greg Patterson
Fee:
$249 by Tue., Feb. 25, 2020.
$274 after Tue., Feb. 25, 2020.
CEUs: 0.7
Enrollment Limit: 20
Program Number: 5070-12567
Registration Deadline: Tue., Mar. 10, 2020
Date: Wed, June 17, 2020
Time: 8:30am-4:30pm
Location: UWM School of Continuing Education
Instructor: Greg Patterson
Fee:
$249 by Wed., June 3, 2020.
$274 after Wed., June 3, 2020.
CEUs: 0.7
Enrollment Limit: 20
Program Number: 5070-12553
Registration Deadline: Wed., June 17, 2020
