Microsoft Office Excel 2016 (with Expert Exam)

Start your preparation for Microsoft Office Specialist Excel 2016 exam by LO-Excel-2016 - Microsoft Office Excel 2016 course. The course focuses on the objectives covered in Microsoft Excel 77-727 and Microsoft Excel Expert 77-728 exams. The course helps in leveraging the power of data analysis and presentation in order to make informed, intelligent organizational decisions and also in working with functions, lists, analyzing data, visualizing data with charts and using PivotTables and PivotCharts. The Microsoft Office Specialist Excel 2016 certification exam is intended for information workers and brings performance-based format for better testing of the understanding and skills of IT professionals to use the Microsoft 2016 programs.

Here's what you will get

Microsoft Office Specialist 2016 exam validates the candidate's understanding 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 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. Along with this the successful candidates can create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They customize their Excel environments to meet project needs and to enhance productivity.

Glossary of terms
Test prep
Pre-assessment Questions
Full Length Tests
Post-Assessment Questions
Exam FAQs
Where do I take the exam? Certiport
What is the format of the exam? Exams are mostly performance-based and conducted in a "live" or simulated environment.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 90 minutes
What is the passing score? 70%

(on a scale of 0-1000)

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 LO-77-727-77-728, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Editor
  • Data Analyst
  • Microsoft System Administrator

Here's what you will learn

  • TOPIC A: Navigate the Excel User Interface
  • TOPIC B: Use Excel Commands
  • TOPIC C: Create and Save a Basic Workbook
  • TOPIC D: Enter Cell Data
  • TOPIC E: Use Excel Help
  • Summary
  • TOPIC A: Create Worksheet Formulas
  • TOPIC B: Insert Functions
  • TOPIC C: Reuse Formulas and Functions
  • Summary
  • TOPIC A: Insert, Delete, and Adjust Cells, Columns, and Rows
  • TOPIC B: Search for and Replace Data
  • TOPIC C: Use Proofing and Research Tools
  • Summary
  • TOPIC A: Apply Text Formats
  • TOPIC B: Apply Number Formats
  • TOPIC C: Align Cell Contents
  • TOPIC D: Apply Styles and Themes
  • TOPIC E: Apply Basic Conditional Formatting
  • TOPIC F: Create and Use Templates
  • Summary
  • TOPIC A: Preview and Print a Workbook
  • TOPIC B: Set Up the Page Layout
  • TOPIC C: Configure Headers and Footers
  • Summary
  • TOPIC A: Manage Worksheets
  • TOPIC B: Manage Workbook and Worksheet Views
  • TOPIC C: Manage Workbook Properties
  • Summary
  • TOPIC A: Add Borders and Colors to Worksheets
  • TOPIC A: Customize General Options and the Excel UI
  • Mastery Builder 1-1: Creating and Saving a Workbook Activity
  • Mastery Builder 2-1: Creating and Reusing Formulas and Functions
  • Mastery Builder 3-1: Modifying a Worksheet
  • Mastery Builder 4-1: Formatting a Worksheet
  • Mastery Builder 5-1: Printing Workbooks
  • Mastery Builder 6-1: Managing Workbooks
  • TOPIC A: Work with Ranges
  • TOPIC B: Use Specialized Functions
  • TOPIC C: Work with Logical Functions
  • TOPIC D: Work with Date & Time Functions
  • TOPIC E: Work with Text Functions
  • Summary
  • TOPIC A: Sort Data
  • TOPIC B: Filter Data
  • TOPIC C: Query Data with Database Functions
  • TOPIC D: Outline and Subtotal Data
  • Summary
  • TOPIC A: Create and Modify Tables
  • TOPIC B: Apply Intermediate Conditional Formatting
  • TOPIC C: Apply Advanced Conditional Formatting
  • Summary
  • TOPIC A: Create Charts
  • TOPIC B: Modify and Format Charts
  • TOPIC C: Use Advanced Chart Features
  • Summary
  • TOPIC A: Create a PivotTable
  • TOPIC B: Analyze PivotTable Data
  • TOPIC C: Present Data with PivotCharts
  • TOPIC D: Filter Data by Using Timelines and Slicers
  • Summary
  • TOPIC A: Insert Graphical Objects
  • TOPIC B: Modify Graphical Objects
  • TOPIC C: Work with SmartArt
  • Mastery Builder 1-1: Working with Functions
  • Mastery Builder 2-1: Working with Lists
  • Mastery Builder 3-1: Analyzing Data
  • Mastery Builder 4-1: Visualizing Data with Charts
  • Mastery Builder 5-1: Using PivotTables and PivotCharts
  • TOPIC A: Use Links and External References
  • TOPIC B: Use 3-D References
  • TOPIC C: Consolidate Data
  • Summary
  • TOPIC A: Use Lookup Functions
  • TOPIC B: Trace Cells
  • TOPIC C: Watch and Evaluate Formulas
  • Summary
  • TOPIC A: Collaborate on a Workbook
  • TOPIC B: Protect Worksheets and Workbooks
  • Summary
  • TOPIC A: Apply Data Validation
  • TOPIC B: Search for Invalid Data and Formulas with Errors
  • TOPIC C: Work with Macros
  • Summary
  • TOPIC A: Create Sparklines
  • TOPIC B: Map Data
  • Summary
  • TOPIC A: Determine Potential Outcomes Using Data Tables
  • TOPIC B: Determine Potential Outcomes Using Scenarios
  • TOPIC C: Use the Goal Seek Feature
  • TOPIC D: Forecasting Data Trends
  • Summary
  • TOPIC A: Internationalize Workbooks
  • TOPIC A: Work with Forms and Controls
  • Mastery Builder 1-1: Working with Multiple Worksheets and Workbooks
  • Mastery Builder 2-1: Using Lookup Functions and Formula Auditing
  • Mastery Builder 3-1: Sharing and Protecting Workbooks
  • Mastery Builder 4-1: Automating Workbook Functionality
  • Mastery Builder 5-1: Creating Sparklines and Mapping Data
  • Mastery Builder 6-1: Forecasting Data
Microsoft Office Excel 2016 (with Expert Exam)
ISBN : 9781616919801
Rating :