Workshop Summary

Workshop Info
Expert-level candidates for the ‘Microsoft Excel 2016’ exam have 18 hrs. of instructions and hands-on experience with the product. They have an advanced understanding of the Excel environment, and the ability to guide others to the proper use of the program’s features.
They will create, manage, and distribute professional
spreadsheets for a variety of specialized purposes and situations. They will customize their Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple axis financial charts, amortization tables, and inventory schedules. Candidate roles may include accountants, financial analysts, data analysts, commercial bankers, and others.

1.     Manage Workbook Options and Settings
2.     Apply Custom Data Formats and Layouts
Apply Custom Data Formats and Validation
Apply Advanced Conditional Formatting and Filtering
Create and Modify Custom Workbook Element
Prepare a Workbook for Internationalization
3.     Create Advanced Formulas
Apply Functions in Formulas
Look up data by using Functions
Apply Advanced Date and Time Functions
Perform Data Analysis and Business Intelligence
Troubleshoot Formulas
Define Named Ranges and Objects
4.     Create Advanced Charts and Tables
Create Advanced Charts
Create and Manage PivotTables
Create and Manage Pivot Charts

18:00 - 21:00
APRIL 2019