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

(77-727-77-728) / ISBN: 9781644591406
This course includes
Lessons
TestPrep
LiveLab
Share
$279.99
Try This Course
Are you an instructor?
Request a free evaluation copy

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.
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
Lab
  • 50+ Performance lab
  • 100+ Video tutorials
  • 03:27+ Hours
Video Lessons
  • 128+ Videos
  • 05:48+ Hours
Here's what you will learn
Download Course Outline
  • Course Overview
  • About 77-727 and 77-728 Exams
  • Prerequisites
  • Creating Worksheets and Workbooks
  • Navigating in Worksheets and Workbooks
  • Formatting Worksheets and Workbooks
  • Customizing Options and Views for Worksheets and Workbooks
  • Summary
  • Configuring Worksheets and Workbooks for Distribution
  • Managing Workbooks
  • Managing Workbook Review
  • Summary
  • Applying Custom Data Formats and Validation
  • Applying Advanced Conditional Formatting and Filtering
  • Creating and Modifying Custom Workbook Elements
  • Preparing a Workbook for Internationalization
  • Summary
  • Inserting Data in Cells and Ranges
  • Formatting Cells and Ranges
  • Summarizing and Organizing Data
  • Summary
  • Creating and Managing Tables
  • Managing Table Styles and Options
  • Filtering and Sorting Tables
  • Summary
  • Summarizing Data by Using Functions
  • Performing Conditional Operations by Using Functions
  • Formatting and Modifying Text by Using Functions
  • Summary
  • 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
  • Creating Charts and Objects
  • Formatting Charts
  • Inserting and Formatting Objects
  • Summary
  • Creating Advanced Charts
  • Creating and Managing PivotTables
  • Creating and Managing PivotCharts
  • Summary

Hands on Activities (Performance Labs)

  • 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
  • Arranging Excel Windows
  • Protecting a Worksheet
  • Freezing the Top Row
  • Protecting a Workbook's Structure
  • Changing Date Format
  • Entering Text and Values
  • Using Relative, Absolute, and Mixed References
  • Changing the Text Color
  • Using the Middle Align and Center Command
  • Formatting a Heading
  • Deleting and Editing the Cell Content
  • Converting a Table to a Cell Range
  • Changing the Table Style
  • Using the UPPER Function
  • Using the PROPER Function
  • 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
  • Removing Gridlines and Headings
  • Changing the Chart Title
  • Inserting and Configuring a Shape
  • Inserting SmartArt
  • Inserting WordArt
  • Inserting and Modifying an Image
  • Creating a PivotTable Automatically
Exam FAQs
What are the prerequisites for this exam? There are no technical pre-requisites for this certification exam.
What is the exam registration fee? USD 100
Where do I take the exam? Certiport
What is the format of the exam? 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.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 50 minutes
What is the passing score? The passing score varies from exam to exam and is provided on the score report.
What is the exam's retake policy?

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.
What is the validity of the certification? For life
Where can I find more information about this exam? To know more about the 77-727 & 77-728, click here.
What are the career opportunities after passing this exam?
  • Editor
  • Data Analyst
  • Microsoft System Administrator
×