Microsoft Excel 2013 (MOS) Expert Part 1
(77-427-complete)
/ ISBN: 9781616917555
This course includes
Lessons
TestPrep
Lab
Microsoft Excel 2013 (MOS) Expert Part 1
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.
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
Lab
-
5+ Performance lab
-
49+ Video tutorials
-
23+ Minutes
Video Lessons
-
20+ Videos
-
12+ Minutes
- 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
Hands on Activities (Performance Labs)
- Applying conditional formatting
- Using icons in conditional formatting
- Showing cell dependency
- Enabling background error checking for formulas
- Printing the current date and time
| What are the prerequisites for this exam? | There are no technical prerequisites for this certification. |
|---|---|
| What is the exam registration fee? | USD 100 |
| Where do I take the exam? | Certiport |
| 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. |
| How many questions are asked in the exam? | The exam contains 40-60 questions. |
| What is the duration of the exam? | 50 minutes |
| What is the passing score? | The passing score varies from exam to exam and is provided on the score report. |
| What is the exam's retake policy? | Microsoft Office Specialist (MOS) exam retake policy
|
| What is the validity of the certification? | For life |
| Where can I find more information about this exam? | To know more about the 77-427, click here. |
| What are the career opportunities after passing this exam? |
|
×
