This series will help you take your data analysis capabilities to the next level by teaching you how to compare different data scenarios and to predict future trends in Excel. You will learn how to use pivot tables to summarize data in flexible ways, look up related data from other worksheets, use conditional logic to summarize, count, or format specific data, and use the data table, Goal Seek, and Solver tools to solve complex data analysis problems. In addition, you will learn how to create sophisticated macros to automate your work.

Earn the certificate

1. Sign up for the certificate (below) to indicate that you are interested in earning this certificate.
2. Register for and attend each workshop in the series within one year. Receive a 10% discount if you register for all the workshops at one time. Workshops and schedules are listed below. Or, read about workshop charges and policies.
3. You can keep track of your progress in your customer profile.
4. The IT Training & Education office will contact you when you have completed the certificate.

Workshops in this series

Excel: Analyzing Data with Pivot Tables

Participants will learn how to create, format, and modify pivot tables and perform various summary techniques when displaying data. Pivot charts will also be covered.

Excel: Looking Up Data with VLOOKUP & Using Conditional Functions

This workshop will cover arrays and conditional functions used to summarize or count data, VLOOKUP, and various types of conditional formats.

Excel: Performing What-If Analysis & Creating Named Scenarios

Learn how to use data tables, Goal Seek, and Solver to analyze complex data. The Scenario Manager feature makes automating what-if models easy by allowing participants to store and compare different data scenarios and to predict future trends.

Excel: Advanced Macros & User Defined Functions

In this workshop, participants will learn how to use advanced macro capabilities to automate complex workflows and how to write and assign user-defined functions.

Register for workshops in this series

• Schedules for individual workshops are listed below.
• Receive a 10% discount when you register for all the workshops in this series (requires login) at one time. Or, read about workshop charges and policies.
• If you have already attended one or more of these workshops, your attendance will automatically be applied toward your certificate.
• To earn the Certificate, you must attend all workshops in a series within one year period.