The Management Sherpa
Excel 2016 Expert
Excel 2016 Expert
Couldn't load pickup availability
![Excel 2016 Expert](http://the-management-sherpa.com/cdn/shop/products/Excel_ce0ccb29-6cc7-4bd5-9fbc-76c5f9d170a1.webp?v=1670701323&width=1445)
About the Course
Participants will gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers.
Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.
Course Outline
Module One: Manage Workbook Options and Settings
- Manage Workbooks
- Manage Workbook Review
Module Two: Apply Custom Data Formats and Layouts
- Apply Custom Data Formats and Validation
- Apply Advanced Conditional Formatting and Filtering
- Create and Modify Custom Workbook Elements
- Prepare a Workbook for Internationalization
Module Three: Create Advanced Formulas
- Apply Functions in Formulas
- Look up data using Functions
- Apply Advanced Date and Time Functions
- Perform Data Analysis and Business Intelligence
- Troubleshoot Formulas
- Define Named Ranges and Objects
Module Four: Create Advanced Charts and Tables
- Create Advanced Charts
- Create and Manage Pivot Tables
- Create and Manage PivotCharts