MOS: Microsoft Excel 2013 Expert Part 1
Gain hands-on expertise in Microsoft 77-427 certification exam with MOS: Microsoft Excel 2013 Expert Part 1 course. The course covers all the objectives of the 77-427 exam and provides 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 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
9+
Exercises
68+
Quizzes
50+
Flashcards
42+
Glossary of terms
42+
Pre-assessment Questions
10+
Full Length Tests
2+
Post-Assessment Questions
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
20+
Minutes
12+
|
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-427 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. The MOS 2013 certification 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:
|
| 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 their policy. Click here for more information. |
| Where can I find more information about this exam? | To know more about the 77-427, click here. |
| Which certification covers this exam? | |
| What are the career opportunities after passing this exam? |
|
Here's what you will learn
- About Conditional Formatting
- Specifying Conditional Formatting
- Conditional Formats That Use Graphics
- Creating Formula-Based Rules
- Working with Conditional Formats
- Adding Comments to Cells
- Finding and Correcting Formula Errors
- Using Excel Auditing Tools
- Searching and Replacing
- Spell-Checking Your Worksheets
- Using AutoCorrect
- 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
- Introducing Lookup Formulas
- Functions Relevant to Lookups
- Basic Lookup Formulas
- Specialized Lookup Formulas
- How Excel Handles Dates and Times
- Date-Related Worksheet Functions
- Time-Related Functions
- 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
- 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
- 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
77-427
uCertify provides courses, simulator, labs, test prep kits for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, IC3, Adobe, and many more.
© 2002-2018 uCertify.
All Rights Reserved
Know Us
- About us
- Careers
- Partners
- Sitemap
- Contact us
- Terms & Conditions
- Privacy Statement