Microsoft

Excel 2013 Level 3

(77-420-L3-30bird) / ISBN : 978-1-61691-666-4

Lessons

Lab

300 Reviews

Get A Free Trial

This course includes:

Free pre-assessment and first 2 lessons

8+ Interactive Lessons | 44+ Exercises

Accessible on mobile and tablet too

Certificate of completion

$139.99

Buy Now

Are you an instructor?

Access detailed information about the course content, learning objectives, activities, and assessments before adding it to your curriculum.

Skills You’ll Get

The MOS: Excel 2013 is a standalone certification from Microsoft with the exam code 77-420. This certification is targeted at professionals who can create and manage worksheets & workbooks with Microsoft Office Excel 2013 and may have experience with previous versions of Microsoft Office Excel. They can also perform tasks like creating tables, applying formulas and functions, creating charts & objects. This exam is an upgrade of Microsoft Office Excel 2010.

Interactive Lessons

8+ Interactive Lessons | 44+ Exercises |

Download Course Outline

Introduction

Logical and Lookup Functions

Module A: Decision-making functions
Module B: Lookup and reference functions
Summary: Logical and lookup functions

Advanced Formulas

Module A: Auditing and error-trapping
Module B: Formula options
Module C: Arrays
Summary: Advanced formulas

Special Functions

Module A: Date and time functions
Module B: Text functions
Module C: Other functions
Summary: Special functions

Importing and Exporting

Module A: External data
Module B: Exporting data
Summary: Importing and exporting

Analysis

Module A: What-if analysis
Module B: The Analysis Toolpak
Summary: Analysis

Macros and Forms

Module A: Recording macros
Module B: Running macros
Module C: Forms
Summary: Macros and forms

Internationalization and Accessibility

Preparing workbooks for internationalization and accessibility
Summary: Internationalization and accessibility

Logical and Lookup Functions

Using a nested function
Using the SUMIF function
Using multiple criteria with the SUMIFS function
Using the VLOOKUP function
Using the HLOOKUP function

Advanced Formulas

Showing cell dependency
Evaluating and correcting a formula
Enabling the error checking rules for formulas
Transposing a cell range

Special Functions

Printing the current date and time
Printing the current date
Concatenating text
Using the MIN and MAX functions

Analysis

Adding watch options for cell values
Using the Goal Seek feature

Internationalization and Accessibility

Checking accessibility issues

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

There are no technical pre-requisites for this certification.

USD 96

Pricing and taxes may vary from country to country.

The Microsoft 77-420 exam is administered by Certiport at testing centers worldwide. Click here to find a testing center near you.

The exam consists of performance based questions. It 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.

The exam contains 40-60 questions.

50 minutes

700

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.

Know more about the 77-420