Find the Microsoft Certification exams you need to highlight your skills and further your career from the IT certification list. Explore our newest and updated exam list and select your course and start preparing today. You can prepare for the Microsoft MOS certification exam with the Microsoft Excel 2013 course and performance-based labs. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. The course and labs provide complete coverage of the 77-420 exam and give knowledge of the essential components of Excel 2013 with practical examples. The course and lab contain a good balance between the basics that every Excel user needs to know and more complex topics that will appeal to power users.
Here are the exam topics covered in the study guide:
- Using Data Validation
- Worksheet Formatting
- Understanding Excel Files
- Creating Sparkline Graphics
- Learning Advanced Charting
- Importing and Exporting Data
- Using and Creating Templates
- Using Custom Number Formats
- Using Custom Number Formats
- Essential Worksheet Operations
- Including Formulas and Functions
- Entering and Editing Worksheet Data
- Creating Formulas That Count and Sum
- Creating Formulas That Manipulates Text
The following are the resources offered in the cert guide:
- 26+ Lessons
- 75+ Quizzes
- 109+ Exercises
- 143+ Flashcards
- 2+ Full-length Tests
- 15+ Pre-assessments
- 40+ Post assessments
- 143+ Glossary of Terms
- 33+ Performance-based Labs
About The Exam
The Microsoft Office Specialist 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.
So, start your prep for the Microsoft 77-420 exam with the uCertify complete course and pass the exam in your first attempt.