Microsoft Excel 2016

Gain hands-on expertise in MOS: Microsoft Office Excel 2016 Core certification exam with Microsoft Excel 2016 course and performance-based labs. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. Microsoft Excel 2016 certification program validates the skills and expertise of information workers to create and manage worksheets and workbooks; manage data cells and ranges; create tables; perform operations with formulas and functions; create charts and objects.

Here's what you will get

Microsoft Excel 2016 exam provides the candidates the basic idea of the Excel environment and the skill to deliver tasks without any help. The exam helps the candidates in demonstrating the correct application of the basic features of MS Excel 2016 by making and editing workbook with multiple sheets, and they use a graphic element to represent data visually, for example, sales invoices, financial statements,professional-looking budgets, team performance charts, and data-entry logs.

Glossary of terms
Test prep
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 FAQs
Where do I take the exam? Certiport
What is the format of the exam? Multiple choice, Best answer, Short answer, Case study and so on.
How many questions are asked in the exam? The exam contains 40-50 questions.
What is the exam's retake policy?

Microsoft Office Specialist (MOS) exam retake policy is as follows:

  • Retake vouchers can only be used to retake the same exam that was failed.
  • All vouchers must be used prior to their expiration dates, without exception.
  • Retake vouchers must be used within 30 days of the initial failed exam.
  • As of July 1, 2014, the retake policy changed to the following:
    • 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 48 hours before retaking the exam.
    • A two-day waiting period is imposed for each subsequent exam retake.
    • If a candidate achieves a passing score on an exam, the candidate may take it again.

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?
  • Data Analyst
  • Project Manager
  • Product Developer
  • Office Professional

Here's what you will learn

  • 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
ms-excel-2016 ms-excel-2016
Microsoft Excel 2016
ISBN : 9781616917982
Rating :