Microsoft Excel 2013 (MOS) Expert Part 1
(77-427-complete)/ISBN:978-1-61691-755-5
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
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
Hands-On Labs
5+ LiveLab | 49+ Video tutorials | 23+ Minutes
Video Lessons
20+ Videos | 12+ Minutes
Need guidance and support? Click here to check our Instructor Led Course.
Here's what you will learn
Download Course OutlineLessons 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
- 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 2 days (48 hours) before retaking the exam a third time.
- A two-day waiting period will be imposed between each subsequent exam retake.
- There is no annual limit on the number of attempts on the same exam.
- If a candidate achieves a passing score on an Office exam, the candidate may take it again.
For life