Scroll to top button

77-428 : MOS: Microsoft Excel 2013 Expert Part 2 (Course & Lab)

77-428-complete
MOS: Microsoft Excel 2013 Expert Part 2 (Course & Lab)
ISBN : 978-1-61691-586-5
Gain hands-on expertise in Microsoft 77-428 certification exam with MOS: Microsoft Excel 2013 Expert Part 2 course and performance-based labs. Performance-based labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. MOS: Microsoft Excel 2013 Expert Part 2 course and performance-based labs cover all the objectives of the 77-428 exam and provide skills to manage and share workbooks, apply custom formats and layouts, create advanced formulas, and create advanced charts and tables.

Here's what will you get

The Microsoft Office Specialist: Excel 2013 Expert certification is an industry recognized credential. It is a standalone certification from Microsoft with the exam code 77-428. The candidates should be able to create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations, as well as customize their Excel environment to meet needs and enhance productivity.

Lessons
11+
Exercises
73+
Quizzes
46+
Flashcards
43+
Glossary of terms
43+
Pre-assessment Questions
5+
Full Length Tests
2+
Post-Assessment Questions
30+
Performance based lab
9+
Video tutorials
57+
Minutes
30+

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.

Videos
5+
Minutes
03+
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification.
Where do I take the exam? The Microsoft 77-428 exam is administered by Certiport at testing centers worldwide. Click here to find a testing center near you.
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 with tasks and steps that build on each other. For more information regarding improved exam format click here.
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? The passing score varies from exam to exam and is provided on the score report.

(on a scale of 0-1000)

What is the exam's retake policy?

As of 1 July 2014, Microsoft's 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.
What is the validity of the certification? Microsoft Office Specialist certification does not expire. The certification holder is certified for life unless the vendor changes its policy. Click here for more information.
Where can I find more information about this exam? To know more about the 77-428-complete, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?

The Microsoft Office Specialist(MOS): Microsoft Office Excel 2013 Expert certified professional has several career opportunities open up to them, including:

  • Accountants
  • Data Analysts
  • Financial Analysts
  • Sales Professionals
  • Information Workers
  • Office Professionals
  • Commercial Bankers
  • Program/Project Managers

Here's what will you learn

  • Linking Workbooks
  • Creating External Reference Formulas
  • Working with External Reference Formulas
  • Avoiding Potential Problems with External Reference Formulas
  • Consolidating Worksheets
  • Types of Protection
  • Protecting a Worksheet
  • Protecting a Workbook
  • VB Project Protection
  • Related Topics
  • Finding and Correcting Formula Errors
  • Using Excel Auditing Tools
  • Searching and Replacing
  • Spell-Checking Your Worksheets
  • Using AutoCorrect
  • About Number Formatting
  • Creating a Custom Number Format
  • Custom Number Format Examples
  • Exploring Excel Templates
  • Understanding Custom Excel Templates
  • Counting and Summing Worksheet Cells
  • Basic Counting Formulas
  • Advanced Counting Formulas
  • Summing Formulas
  • Conditional Sums Using a Single Criterion
  • Conditional Sums Using Multiple Criteria
  • A What-If Example
  • Types of What-If Analysis
  • What-If Analysis, in Reverse
  • Single-Cell Goal Seeking
  • Introducing Solver
  • Solver Examples
  • The Time Value of Money
  • Loan Calculations
  • Investment Calculations
  • Depreciation Calculations
  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Learning More
  • Working with Non-Numeric Data
  • Grouping Pivot Table Items
  • Creating a Frequency Distribution
  • Creating a Calculated Field or Calculated Item
  • Filtering Pivot Tables with Slicers
  • Filtering Pivot Tables with a Timeline
  • Referencing Cells within a Pivot Table
  • Creating Pivot Charts
  • Another Pivot Table Example
  • Producing a Report with a Pivot Table
  • Using the Data Model
  • Learning More about Pivot Tables

Hands on Activities (Labs)

  • Checking a workbook for compatibility issues
  • Adding a digital signature
  • Displaying formulas instead of values
  • Enabling the error checking rules for formulas
  • Evaluating and correcting a formula
  • Configuring error checking rules for formulas
  • Using multiple criteria in the COUNTIFS function
  • Using multiple criteria with the SUMIFS function
  • Configuring a calculation option for formulas

Copyright © 2002-2017 uCertify / All Rights Reserved.