Microsoft

Microsoft Excel 2013 (MOS) Expert Part 2

(77-428-complete) / ISBN : 978-1-61691-586-5
Lessons
Lab
TestPrep
244 Reviews
Get A Free Trial

About This Course

Prepare for the Microsoft 77-428 exam with the MOS Excel 2013 Expert Part 2 course and lab. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The Microsoft Office training course covers the Excel expert exam objectives and provides skills to manage and share workbooks, apply custom formats and layouts, and more. The Microsoft Excel certification course and lab also include topics such as custom business templates, multiple axis financial charts, and more.

Skills You’ll 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 Microsoft Excel expert exam validates the candidate's ability to create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations, as well as customize their Excel environment to enhance productivity.
Download Course Outline

1

Linking and Consolidating Worksheets

  • Linking Workbooks
  • Creating External Reference Formulas
  • Working with External Reference Formulas
  • Avoiding Potential Problems with External Reference Formulas
  • Consolidating Worksheets
2

Protecting Your Work

  • Types of Protection
  • Protecting a Worksheet
  • Protecting a Workbook
  • VB Project Protection
  • Related Topics
3

Making Your Worksheets Error Free

  • Finding and Correcting Formula Errors
  • Using Excel Auditing Tools
  • Searching and Replacing
  • Spell-Checking Your Worksheets
  • Using AutoCorrect
4

Using Custom Number Formats

  • About Number Formatting
  • Creating a Custom Number Format
  • Custom Number Format Examples
5

Using and Creating Templates

  • Exploring Excel Templates
  • Understanding Custom Excel Templates
6

Creating Formulas That Count and Sum

  • Counting and Summing Worksheet Cells
  • Basic Counting Formulas
  • Advanced Counting Formulas
  • Summing Formulas
  • Conditional Sums Using a Single Criterion
  • Conditional Sums Using Multiple Criteria
7

Performing Spreadsheet What-If Analysis

  • A What-If Example
  • Types of What-If Analysis
8

Analyzing Data Using Goal Seeking and Solver

  • What-If Analysis, in Reverse
  • Single-Cell Goal Seeking
  • Introducing Solver
  • Solver Examples
9

Creating Formulas for Financial Applications

  • The Time Value of Money
  • Loan Calculations
  • Investment Calculations
  • Depreciation Calculations
10

Introducing Pivot Tables

  • About Pivot Tables
  • Creating a Pivot Table Automatically
  • Creating a Pivot Table Manually
  • More Pivot Table Examples
  • Learning More
11

Analyzing Data with Pivot Tables

  • 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

1

Protecting Your Work

  • Checking a workbook for compatibility issues
  • Adding a digital signature
2

Making Your Worksheets Error Free

  • Displaying formulas instead of values
  • Enabling the error checking rules for formulas
  • Evaluating and correcting a formula
  • Configuring error checking rules for formulas
3

Creating Formulas That Count and Sum

  • Using multiple criteria in the COUNTIFS function
  • Using multiple criteria with the SUMIFS function
4

Creating Formulas for Financial Applications

  • Configuring a calculation option for formulas

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

There are no technical prerequisites for this certification exam.

USD 100

Certiport

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.

The exam contains 40-60 questions.

50 minutes

The passing score varies from exam to exam and is provided on the score report.

Microsoft Office Specialist (MOS) exam retake policy

  1. 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.
  2. If a candidate does not achieve a passing score the second time, the candidate must wait 2 days (48 hours) before retaking the exam a third time.
  3. A two-day waiting period will be imposed between each subsequent exam retake.
  4. There is no annual limit on the number of attempts on the same exam.
  5. If a candidate achieves a passing score on an Office exam, the candidate may take it again.

For life

Know more about the 77-428

Microsoft Excel 2013 (MOS) Expert Part 2

$ 441.29

Buy Now

Related Courses

All Course
Microsoft Office Word 2016 Expert (77-725 & 77-726)
77-725-77-726 - Microsoft Office Word 2016 Expert (77-725 & 77-726)
Lessons Lab TestPrep AI Tutor
Microsoft Office Word 2016 Expert (77-725 & 77-726)

Microsoft Office Word 2016 Expert (77-725 & 77-726)

ISBN: 9781644591505
77-725-77-726
Buy Now
Microsoft Office Excel 2016 Expert (77-727-77-728)
77-727-77-728 - Microsoft Office Excel 2016 Expert (77-727-77-728)
Lessons Lab TestPrep AI Tutor
Microsoft Office Excel 2016 Expert (77-727-77-728)

Microsoft Office Excel 2016 Expert (77-727-77-728)

ISBN: 9781644591406
77-727-77-728
Buy Now
Microsoft PowerPoint 2016
77-729 - Microsoft PowerPoint 2016
Lessons Lab TestPrep AI Tutor
Microsoft PowerPoint 2016

Microsoft PowerPoint 2016

ISBN: 9781644591062
77-729
Buy Now
Microsoft Access 2016 (77-730)
77-730 - Microsoft Access 2016 (77-730)
Lessons Lab TestPrep AI Tutor
Microsoft Access 2016 (77-730)

Microsoft Access 2016 (77-730)

ISBN: 9781644591543
77-730
Buy Now
Microsoft Azure Administration (AZ-104)
AZ-104.AP2 - Microsoft Azure Administration (AZ-104)
Lessons Lab TestPrep AI Tutor
Microsoft Azure Administration (AZ-104)

Microsoft Azure Administration (AZ-104)

ISBN: 9781644593226
AZ-104.AP2
Buy Now
Developing Solutions for Microsoft Azure
AZ-204.AP1 - Developing Solutions for Microsoft Azure
Lessons Lab TestPrep AI Tutor
Developing Solutions for Microsoft Azure

Developing Solutions for Microsoft Azure

ISBN: 9781644593639
AZ-204.AP1
Buy Now
Designing Microsoft Azure Infrastructure Solutions
AZ-305.AP1 - Designing Microsoft Azure Infrastructure Solutions
Lessons Lab TestPrep AI Tutor
Designing Microsoft Azure Infrastructure Solutions

Designing Microsoft Azure Infrastructure Solutions

ISBN: 9781644594216
AZ-305.AP1
Buy Now
scroll to top