Product Details
Excel 2016 Expert (77-728) Course
LearnKey Courses

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 77-728 certification exam.

$75.00
Quantity:

Your Content Host
GMetrix is the ultimate study platform
Are you a company who has made learning material for a certification? Host it here!
Email us at [email protected]
© Copyright 2019, GMetrix LLC   Privacy Policy  /  Return Policy