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.
Course Content Microsoft Excel Level III
Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
Use 3-D References
Use Links and External References
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
Use Formulas and Functions to Apply Conditional Formatting
Lesson 5: Auditing Worksheets
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
Excel 2010/2013 – Level II (or equivalent experience)
Public courses on Microsoft Excel and Access are taught in Office 2013. If you are using Office 2010 – the functions and features you will 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 firstname.lastname@example.org or 414-227-3208.
Greg was very knowledgeable and made class enjoyable. I am definitely interested in taking another class with him. The skills that I learned throughout this class will help me at my workplace. I am very excited to share what I have learned today with my coworkers!
— Student, 2015
I think this program was structured/tailored to equip us with tools we need to start solving some real world problems.
The instructor was ready to assist everyone to ensure they understood the material.
— Student, 2014
Tue., Apr. 5, 2016
Location: UWM School of Continuing Education
Instructor: Greg Patterson
Enrollment Limit: 20
Program Number: 5070-8503
Registration Deadline: Mon., Apr. 4, 2016