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 exams.

Learning Objectives
Learning Time: 17 hours

• 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