Microsoft Office Excel 2016 Expert (77-727-77-728)
(77-727-77-728)
/ ISBN: 978-1-64459-140-6
This course includes
Lessons
TestPrep
LiveLab
Mentoring (Add-on)
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.
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
LiveLab
-
50+ LiveLab
-
100+ Video tutorials
-
03:27+ Hours
Video Lessons
-
128+ Videos
-
05:48+ Hours
- 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 (Live 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
| 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
|
| What is the validity of the certification? | For life |
| Where can I find more information about this exam? | Know more about the 77-727 & 77-728 |
| What are the career opportunities after passing this exam? |
|
×
