Scroll to top button

Microsoft Excel 2016

ISBN : 9781616917982

Learn the skills for passing Microsoft Excel 2016 certification exam with the Microsoft MOS 77-727 cert guide. The study guide is suitable for people at all levels of proficiency in Microsoft Excel and covers all the objectives of the MOS 77-727 exam such as creating, navigating, and formatting the worksheets and workbooks, customizing options and views, inserting data in cells and ranges, summarizing and organizing data, creating tables, creating charts, and formatting objects.

The Microsoft Excel 77-727 exam measures and validates the individuals' skills in data analysis, manipulation, and presentation who have a fundamental understanding of the Excel environment and are able to complete the task independently. The Microsoft MOS 77-727 certification helps individuals to exhibit the accurate application of the key features of Microsoft Excel 2016, create and modify the workbook with numerous sheets, and utilize a graphic component to represent data. Workbook examples incorporate financial statements, invoices, entry logs, and performance charts.

Glossary of terms
Pre Assessment Questions
Full Length Tests
Post Assessment Questions
Performance lab
Video tutorials

Videos and How To

uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.

Video Lessons
Exam related FAQs
What is the exam registration fee? USD 165
Where do I take the exam? Certiport
What is the format of the exam? Single choice, multiple choice, drag-and-drop, active screen, build list, case studies, and short answer.
How many questions are asked in the exam? The exam contains 40-60 The number may vary depending on the exam. questions.
What is the duration of the exam? 150 minutes
Where can I find more information about this exam? To know more about the MS-EXCEL-2016, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

Microsoft Excel 2016 certification qualifies you for a variety of exciting job roles including

  • Data Analyst
  • Office Manager
  • Office Administrator
  • Management Analyst
  • Administrative Assistant
  • Identifying What Excel Is Good For
  • Seeing What's New in Excel 2016
  • Understanding Workbooks and Worksheets
  • Moving Around a Worksheet
  • Using the Ribbon
  • Customizing the Ribbon
  • Creating Your First Excel Workbook
  • Customizing the Quick Access Toolbar
  • Summary
  • Entering Text and Values into Your Worksheets
  • Entering Dates and Times into Your Worksheets
  • Modifying Cell Contents
  • Applying Number Formatting
  • Summary
  • Learning the Fundamentals of Excel Worksheets
  • Controlling the Worksheet View
  • Working with Rows and Columns
  • Summary
  • Understanding Cells and Ranges
  • Copying or Moving Ranges
  • Using Names to Work with Ranges
  • Adding Comments to Cells
  • Summary
  • What Is a Table?
  • Creating a Table
  • Changing the Look of a Table
  • Working with Tables
  • What Is a Chart?
  • Understanding How Excel Handles Charts
  • Creating a Chart
  • Hands On: Creating and Customizing a Chart
  • Working with Charts
  • Understanding Chart Types
  • Working with Titles in a Chart
  • Working with a Legend
  • Working with Gridlines
  • Working with Data Series
  • Sparkline Types
  • Creating Sparklines
  • Customizing Sparklines
  • Summary
  • Getting to Know the Formatting Tools
  • Using Different Fonts to Format Your Worksheet
  • Changing Text Alignment
  • Using Colors and Shading
  • Adding Borders and Lines
  • Understanding Document Themes
  • About Number Formatting
  • Summary
  • Creating a New Workbook
  • Saving a Workbook
  • Password-Protecting a Workbook
  • Closing Workbooks
  • Safeguarding Your Work
  • Excel File Compatibility
  • Exploring Excel Templates
  • Summary
  • Basic Printing
  • Changing Your Page View
  • Adjusting Common Page Setup Settings
  • Adding a Header or Footer to Your Reports
  • Types of Protection
  • Protecting a Worksheet
  • Protecting a Workbook
  • Exporting Data
  • Importing Data
  • Summary
  • Understanding Formula Basics
  • Entering Formulas into Your Worksheets
  • Editing Formulas
  • Using Cell References in Formulas
  • Correcting Common Formula Errors
  • Counting and Summing Worksheet Cells
  • Basic Counting Formulas
  • Summing Formulas
  • Basic Lookup Formulas
  • Summary
  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Working with Conditional Formats
  • Summary
  • Using Shapes
  • Using SmartArt
  • Using WordArt
  • Working with Other Graphic Types
  • Working with Hyperlinks
  • Summary
  • About Data Validation
  • Specifying Validation Criteria
  • Types of Validation Criteria You Can Apply
  • Creating a Drop-Down List
  • Using Formulas for Data Validation Rules
  • Understanding Cell References
  • Data Validation Formula Examples
  • Summary
  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Summary
  • A What-If Example
  • Types of What-If Analysis
  • Single-Cell Goal Seeking
  • Summary
  • Certification Objectives Map

Hands on Activities (Labs)

  • Identifying elements of Excel
  • Identifying keys of Worksheet
  • Modifying worksheet in MS Excel 2016
  • Modifying cell contents
  • Identifying key combinations
  • Changing date format in MS Excel 2016
  • Freezing the top row in MS Excel 2016
  • Inserting a column in MS Excel 2016
  • Understanding cell range address
  • Understanding paste options
  • Adding comments in MS Excel 2016
  • Formatting data as table in MS Excel 2016
  • Removing duplicates in MS Excel 2016
  • Sorting data in MS Excel 2016
  • Filtering data in MS Excel 2016
  • Inserting a chart in MS Excel 2016
  • Changing chart style in MS Excel 2016
  • Changing chart color in MS Excel 2016
  • Customizing a chart in MS Excel 2016
  • Identifying chart types
  • Removing gridlines and headings in MS Excel 2016
  • Creating Sparklines in MS Excel 2016
  • Formatting heading in MS Excel 2016
  • Wrapping text in MS Excel 2016
  • Applying border on the MS Excel 2016 sheet
  • Saving a workbook in MS Excel 2016
  • Understanding Workbook
  • Understanding file compatibility
  • Setting page margin in MS Excel 2016
  • Printing an area in MS Excel 2016
  • Adding header in MS Excel 2016
  • Protecting a workbook in MS excel 2016
  • Using the Concatenate function in MS Excel 2016
  • Using the Average function in MS Excel 2016
  • Using the SUMIF function in MS Excel 2016
  • Using the SUM function in MS Excel 2016
  • Using VLOOKUP in MS Excel 2016
  • Applying conditional formatting in MS Excel 2016
  • Inserting and configuring shape
  • Understanding graphic types
  • Hiding column in MS Excel 2016
  • Adding data validation in MS Excel 2016
  • Understanding pivot table
  • Understanding the Scenarios dropdown-list

Customer Testimonials

Almir Budalica
uCertify Microsoft Excel 2016 Exam Preparation Kit is focused to the exam objectives, so the course (along with hands-on experience) gives a student an excellent preparation for an exam. What impressed me most was level of details objectives were explained, as well as a variety of content types (figures, quizzes, etc.), so an absolute beginner can easily follow it, while preparing for an exam and future use of an application.
Almir Budalica
uCertify Microsoft Excel 2016 Exam Preparation Kit is focused on the exam objectives, so the course (along with hands-on experience) gives a student an excellent preparation for an exam.