×

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 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 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 nellenp@uwm.edu or 414-227-3208.

Greg Patterson was very entertaining and knowledgeable about the subject and how to apply it. The examples were well written to show how to use the techniques.

— student, 2014

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

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

Tue., Nov. 17

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8544

Registration Deadline: Mon., Nov. 16

Register Now

Tue., Apr. 5, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8503

Registration Deadline: Mon., Apr. 4, 2016

Register Now

Wed., July 20, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8546

Registration Deadline: Tue., July 19, 2016

Register Now

FacebookTwitterGoogle+Share