The Excel 2016 Expert course (exam 77-728) is a course that specializes in managing Excel and data analysis, two very important skills for one’s employability for any job requiring taking large amounts of data and summarizing the data in a tidy fashion. The course, which simulates analyzing data from a worldwide bike shop, will take you through the major exam domains: Managing Workbooks and Settings, Applying Custom Data Formats and Layouts, Creating Advanced Formulas, and Creating Advanced Charts and Tables. After completing this course, you will indeed be able to call yourself an Excel expert.

Topics 

• Manage Workbooks
• Manage Workbook Review
• Apply Custom Data Formats and Validation
• Apply Advanced Conditional Formatting and Filtering
• Create and Modify Custom Workbook Elements
• Prepare a Workbook for Internationalization
• Apply Functions in Formulas
• Look up data by using Functions
• Apply Advanced Date and Time Function
• Perform Data Analysis and Business Intelligence
• Troubleshoot Formulas
• Define Named Ranges and Objects

Requirements

• Windows Vista, Windows 7, Windows 8, Windows 8.1, or Windows 10
• Full installation of Excel 2016 (not compatible with Office Mobile or Office Online)
• GMetrix SMS current version 6.1 installed
• High-speed Internet connection

Certification

This course bundle is preparation for the official Microsoft Excel Expert (Office 2016) 77-728 certification exam.