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

(77-727-77-728)/ISBN:978-1-64459-140-6

This course includes
Lessons
TestPrep
Hands-On Labs
AI Tutor (Add-on)

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.

Here's what you will get

To be Microsoft Excel certified, you need to pass the 77-727 and 77-728 certification exams. The 77-727 exam objectives include creating and managing worksheets and workbooks; managing data cells and ranges; and creating tables, charts, and objects. The 77-728 exam objectives are managing workbook options and settings; applying custom data formats and layouts; and creating advanced formulas, charts, and tables.

Lessons

10+ Lessons | 84+ Quizzes | 56+ Flashcards | 56+ Glossary of terms

TestPrep

25+ Pre Assessment Questions | 25+ Post Assessment Questions |

Hands-On Labs

50+ LiveLab | 100+ Video tutorials | 03:27+ Hours

Video Lessons

128+ Videos | 05:48+ Hours

Here's what you will learn

Download Course Outline

Lessons 1: Introduction

  • 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

Hands-on LAB Activities

Creating and Formatting Worksheets

  • Creating a New Workbook
  • Inserting a Column
  • Creating a Workbook from a Template
  • Printing a Workbook
  • Importing Data from a File
  • Copying and Pasting Contents
  • Exploring the Format Task Pane
  • Auto-Hiding the Ribbon
  • Entering the Date and Time
  • Adding Worksheets to Workbooks
  • Understanding Cell References
  • Changing the Workbook View
  • Setting and Saving the Print Area
  • Changing the Width of the Column to Automatically Fit the Contents
  • Changing the Row Height to Fit Contents
  • Adding Commands to a New Group
  • Modifying a Worksheet
  • Adding New Commands to the Quick Access Toolbar
  • Hiding a Column
  • Formatting Numbers
  • Hiding or Unhiding the Content

Configuring and Managing Workbooks

  • Arranging Excel Windows
  • Protecting a Worksheet
  • Freezing the Top Row
  • Protecting a Workbook's Structure

Applying Custom Data Formats and Layouts

  • Changing Date Format

Managing Data Cells and Ranges

  • Entering Text and Values
  • Using Relative, Absolute, and Mixed References
  • Changing the Text Color
  • Using the Middle Align and Center Command
  • Formatting a Heading

Creating Tables

  • Deleting and Editing the Cell Content
  • Converting a Table to a Cell Range
  • Changing the Table Style

Performing Operations with Formulas and Functions

  • Using the UPPER Function
  • Using the PROPER Function

Creating Advanced Formulas

  • Using the INDEX Function
  • Using the MATCH Function
  • Using the DATE Function
  • Using the WORKDAY Function
  • Using the TODAY Function
  • Creating a Data Table
  • Creating Names for Cell Ranges

Creating Charts and Objects

  • Removing Gridlines and Headings
  • Changing the Chart Title
  • Inserting and Configuring a Shape
  • Inserting SmartArt
  • Inserting WordArt
  • Inserting and Modifying an Image

Creating Advanced Charts and Tables

  • Creating a PivotTable Automatically

Exam FAQs

There are no technical pre-requisites for this certification exam.

USD 100

The exam consists of performance based questions and is conducted in a live or simulated environment. MOS 2013 presents the candidate with a project to build tasks and steps that build on each other.

The exam contains 40-60 questions.

50 minutes

The passing score varies from exam to exam and is provided on the score report.

Microsoft Office Specialist (MOS) exam retake policy

  1. If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
  2. If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
  3. A two-day waiting period will be imposed between each subsequent exam retake.
  4. There is no annual limit on the number of attempts on the same exam.
  5. If a candidate achieves a passing score on an Office exam, the candidate may take it again.

For life