Scroll to top button

77-888 : MOS: Microsoft Excel 2010 Expert

77-888
MOS: Microsoft Excel 2010 Expert
ISBN : 978-1-61691-267-3
Gain hands-on expertise in Microsoft 77-888 exam with MOS: Microsoft Excel 2010 Expert course. This course covers all the objectives of 77-888 exam which includes sharing and maintaining workbooks, applying formulas and functions, creating and manipulating data, formatting data and content, creating and modifying formulas and functions, presenting data visually, and working with macros and forms and so on.

Here's what will you get

The Microsoft Office Specialist: Excel 2010 Expert certification is an industry recognized credential. This certification is proof of a person's competence across a spectrum of skills which measures your knowledge and efficiency especially at sharing and maintaining workbooks, applying formulas and functions, creating and manipulating data, formatting data and content, creating and modifying formulas and functions, presenting data visually, and working with macros and forms and so on.

The Excel 2010 Expert exam is a standalone certification from Microsoft with the exam code 77-888. The certification is targeted at creating business deliverable with Microsoft Office Excel 2010 Expert and might have experience with previous versions of Microsoft Office Excel. This exam is an upgrade of Microsoft Office Excel 2007 Expert.

Lessons
9+
Exercises
22+
Quizzes
58+
Flashcards
35+
Glossary of terms
35+
Pre-assessment Questions
15+
Full Length Tests
3+
Post-Assessment Questions
15+

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
26+
Minutes
39+
Exam FAQs
What are the prerequisites for this exam? There are no technical prerequisites for this certification.
What is the exam registration fee? USD 96
Where do I take the exam? The Microsoft 77-888 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.
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? 700

(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:

  • 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.
What is the validity of the certification? Microsoft Office Specialist does not expire. This 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-888, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Information Workers
  • Office Professionals
  • Accountants
  • Financial Analysts
  • Data Analysts
  • Commercial Bankers
  • Program/Project Managers
  • Sales Professionals

Here's what will you learn

  • Topic A: About the manual
  • Topic B: Setting student expectations
  • Topic C: Classroom requirements and setup instructions
  • Review Questions
  • Topic A: Logical functions
  • Topic B: Math and statistical functions
  • Unit summary: Logical and statistical functions
  • Review Questions
  • Topic A: Financial functions
  • Topic B: Date and time functions
  • Topic C: Array formulas
  • Topic D: Displaying and printing formulas
  • Unit summary: Financial and date functions
  • Review Questions
  • Topic A: Using lookup functions
  • Topic B: Using MATCH and INDEX
  • Topic C: Creating data tables
  • Unit summary: Lookups and data tables
  • Review Questions
  • Topic A: Validating cell entries
  • Topic B: Exploring database functions
  • Unit summary: Advanced data management
  • Review Questions
  • Topic A: Exporting and importing text files
  • Topic B: Exporting and importing XML data
  • Topic C: Getting external data
  • Unit summary: Exporting and importing
  • Review Questions
  • Topic A: Goal Seek and Solver
  • Topic B: The Analysis ToolPak
  • Topic C: Scenarios
  • Unit summary: Analytical tools
  • Review Questions
  • Topic A: Running and recording a macro
  • Topic B: Working with VBA code
  • Topic C: Creating functions
  • Unit summary: Macros and custom functions
  • Review Questions
  • Topic A: Course summary
  • Topic B: Continued learning after class

Copyright © 2002-2017 uCertify / All Rights Reserved.