Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

Microsoft Office Excel 2016 Expert (77-727-77-728)

Get certified for the Microsoft Excel certification exams with the Microsoft Office Excel 2016 Expert (77-727-77-728) course and lab. The lab provides a hands-on learning experience in a safe, online environment. The Microsoft Excel training course covers the Excel expert exam objectives and teaches you how to create and manage worksheets and workbooks; manage data cells and ranges; create tables; perform operations with formulas and functions; create charts and objects, and create advanced charts and tables.
Test Prep
25+ Pre Assessment Questions | 25+ Post Assessment Questions |
50+ LiveLab | 100+ Video tutorials | 03:27+ Hours
128+ Videos | 05:48+ Hours

Why choose TOPTALENT?


Lessons 1:

  • Course Overview
  • About 77-727 and 77-728 Exams
  • Prerequisites

Lessons 2:
Creating and Formatting Worksheets

  • Creating Worksheets and Workbooks
  • Navigating in Worksheets and Workbooks
  • Formatting Worksheets and Workbooks
  • Customizing Options and Views for Worksheets and Workbooks
  • Summary

Lessons 3:
Configuring and Managing Workbooks

  • Configuring Worksheets and Workbooks for Distribution
  • Managing Workbooks
  • Managing Workbook Review
  • Summary

Lessons 4:
Applying Custom Data Formats and Layouts

  • Applying Custom Data Formats and Validation
  • Applying Advanced Conditional Formatting and Filtering
  • Creating and Modifying Custom Workbook Elements
  • Preparing a Workbook for Internationalization
  • Summary

Lessons 5:
Managing Data Cells and Ranges

  • Inserting Data in Cells and Ranges
  • Formatting Cells and Ranges
  • Summarizing and Organizing Data
  • Summary

Lessons 6:
Creating Tables

  • Creating and Managing Tables
  • Managing Table Styles and Options
  • Filtering and Sorting Tables
  • Summary

Lessons 7:
Performing Operations with Formulas and Functions

  • Summarizing Data by Using Functions
  • Performing Conditional Operations by Using Functions
  • Formatting and Modifying Text by Using Functions
  • Summary

Lessons 8:
Creating Advanced Formulas

  • Applying Functions in Formulas
  • Looking up Data Using Functions
  • Applying Advanced Date and Time Functions
  • Performing Data Analysis and Business Intelligence
  • Troubleshooting Formulas
  • Defining Named Ranges and Objects
  • Summary

Lessons 9:
Creating Charts and Objects

  • Creating Charts and Objects
  • Formatting Charts
  • Inserting and Formatting Objects
  • Summary

Lessons 10:
Creating Advanced Charts and Tables

  • Creating Advanced Charts
  • Creating and Managing PivotTables
  • Creating and Managing PivotCharts
  • Summary