Microsoft Office Excel 2016 Expert (77-727-77-728)
(77-727-77-728)/ISBN:978-1-64459-140-6
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 |
Hand on lab
50+ LiveLab | 100+ Video tutorials | 03:27+ Hours
Video Lessons
128+ Videos | 05:48+ Hours
Need guidance and support? Click here to check our Instructor Led Course.
Here's what you will learn
Download Course OutlineLessons 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
- 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.
- 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.
- A two-day waiting period will be imposed between each subsequent exam retake.
- There is no annual limit on the number of attempts on the same exam.
- If a candidate achieves a passing score on an Office exam, the candidate may take it again.
For life