Microsoft Excel 2013 (MOS) Expert Part 1

(77-427-complete)/ISBN:978-1-61691-755-5

This course includes
Lessons
TestPrep
Lab

Pass the MOS 77-427 exam with the Microsoft Excel 2013 (MOS) Expert Part 1 course and lab. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any text-book, course, or training. The Microsoft Office training course and lab cover the 77-427 exam objectives 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 you will 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.

Lessons

9+ Lessons | 69+ Exercises | 50+ Quizzes | 42+ Flashcards | 42+ Glossary of terms

TestPrep

10+ Pre Assessment Questions | 2+ Full Length Tests | 30+ Post Assessment Questions | 60+ Practice Test Questions

Hand on lab

5+ LiveLab | 49+ Video tutorials | 23+ Minutes

Video Lessons

20+ Videos | 12+ Minutes

Here's what you will learn

Download Course Outline

Lessons 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

Lessons 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

Lessons 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

Lessons 4: Creating Formulas That Look Up Values

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

Lessons 5: Working with Dates and Times

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

Lessons 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

Lessons 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

Lessons 8: Introducing Pivot Tables

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

Lessons 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

Hands-on LAB Activities (Performance Labs)

Visualizing Data Using Conditional Formatting

  • Applying conditional formatting
  • Using icons in conditional formatting

Manage and Share Workbook

  • Showing cell dependency
  • Enabling background error checking for formulas

Working with Dates and Times

  • Printing the current date and time

Exam FAQs

There are no technical prerequisites for this certification.

USD 100

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