Microsoft

Microsoft Excel 2013 (MOS) Expert Part 1

(77-427-complete) / ISBN : 978-1-61691-755-5
Lessons
Lab
TestPrep
259 Reviews
Get A Free Trial

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-427. The Microsoft Excel expert certification validates that the certified candidates can 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.
Download Course Outline

1

Visualizing Data Using Conditional Formatting

  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Conditional Formats That Use Graphics
  • Creating Formula-Based Rules
  • Working with Conditional Formats
2

Manage and Share Workbook

  • Adding Comments to Cells
  • Finding and Correcting Formula Errors
  • Using Excel Auditing Tools
  • Searching and Replacing
  • Spell-Checking Your Worksheets
  • Using AutoCorrect
3

Introducing Formulas and Functions

  • Understanding Formula Basics
  • Entering Formulas into Your Worksheets
  • Editing Formulas
  • Using Cell References in Formulas
  • Using Formulas in Tables
  • Correcting Common Formula Errors
  • Using Advanced Naming Techniques
  • Working with Formulas
4

Creating Formulas That Look Up Values

  • Introducing Lookup Formulas
  • Functions Relevant to Lookups
  • Basic Lookup Formulas
  • Specialized Lookup Formulas
5

Working with Dates and Times

  • How Excel Handles Dates and Times
  • Date-Related Worksheet Functions
  • Time-Related Functions
6

Getting Started Making Charts

  • 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
  • Learning More
7

Learning Advanced Charting

  • Selecting Chart Elements
  • User Interface Choices for Modifying Chart Elements
  • Modifying the Chart Area
  • Modifying the Plot Area
  • Working with Titles in a Chart
  • Working with a Legend
  • Working with Gridlines
  • Modifying the Axes
  • Working with Data Series
  • Creating Chart Templates
  • Learning Some Chart-Making Tricks
8

Introducing Pivot Tables

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

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

Visualizing Data Using Conditional Formatting

  • Applying conditional formatting
  • Using icons in conditional formatting
2

Manage and Share Workbook

  • Showing cell dependency
  • Enabling background error checking for formulas
3

Working with Dates and Times

  • Printing the current date and time

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.

USD 100

Certiport

The exam consists of performance based questions and is conducted in a live or simulated environment. The MOS 2013 certification 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-427

Related Courses

All Course