70-727: Microsoft Office Excel 2016


SKU: LPL-153 Category:

The 77-727 Practice Lab will provide you with the necessary platform to gain hands on skills in Excel 2016. By completing the lab tasks you will improve your practical skills in creating and managing Worksheets and Workbooks, managing data cells and ranges, creating tables, performing operations with formulas and functions, creating charts and objects, applying custom data formats and layouts and creating advanced formulas, pivot tables and pivot charts.

These same tasks will help you understand the objectives and competencies required by the Microsoft 77-727 and 77-728 certification exam.

About Practice Labs

In today’s world of complex computer systems and technologies it’s essential that both those new to IT and seasoned professionals alike gain hands on experience. Our state-of-the-art platform brings training theory to life giving the user greater depth of technology ensuring their ability to demonstrate how to use and understand vendor products and software.

Get the hands on learning you need without spending significant amounts of money on your own equipment. We deliver real equipment with the ease and convenience of your web browser, allowing you to develop real world IT skills.


  • Risk free platform to develop practical IT skills in all the latest technologies
  • Real world and exam related practical tasks
  • Real equipment NOT simulations
  • Simply accessed from a web browser, anytime, anywhere – 24/7

Learning Objectives

Create Worksheets and Workbooks
Navigating Excel
Modifying a Worksheet
Customizing Excel
Printing Workbooks and Worksheets
Understand Workbook Properties
Manage Data Entry
Format Cells and Ranges
Summarize, Organize and Format Data
Create and Manage Tables
Manage Table Styles and Options
Understand Cell References and Formulas
Performing Calculations using SUM MIN MAX Functions
Performing Conditional Operations Using Functions
Format and Modify Text Using Functions
Create Charts
Insert and Format Objects