MOS: Microsoft Office OneNote 2010

Audience Profile
The audience profile for the OneNote Exam is a student, office worker or instructor who needs to navigate the Office software at the feature and functionality level.
These users use OneNote as a digital notebook to facilitate their work and use it to integrate with other Microsoft 2010 Office applications. They have the ability to use it for project management, organizing research, collaboration, and to access information from multiple locations. They have the skills and knowledge to effectively problem solve many issues that arise. They effectively use many of the common features and functions to organize and display digital information.

The core OneNote 2010 user typically:
    • is accustomed to making decisions about his or her own work
    • is a competent user of Microsoft 2010 Office applications
    • knows how to leverage his or her work for multiple purposes
    • knows how to use the major features and functions of OneNote to enhance project and task management
    • understands how to collaborate via OneNote
Credit Toward CertificationWhen you pass Exam 77-853: OneNote 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): OneNote 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office 365

Audience Profile
This exam validates the skills students, office workers or instructors need to navigate Office 365 at the feature and functionality level. The Office 365 User should be able to navigate Office 365 software at the feature and functionality level, including: Outlook Web App (OWA), Lync collaboration functionality, SharePoint online, and Office web apps.

They should be familiar with and know how to use at least 80% of the features and capabilities of Office 365, including but not limited to: Simultaneously edit documents with colleagues, Conduct online meetings with colleagues, partners, and customers, including audio, video, and screen sharing; Share calendar with colleagues, partners, and customers; and Manage and share documents, task lists, and schedules to keep workgroups in sync using My Sites and TeamSites.
Credit Toward CertificationWhen you pass Exam 77-891: Office 365, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Microsoft Office 365
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft SharePoint 2010

Audience Profile
Candidates for this exam are users who provide structure for information, extend out-of-the-box site features, solve business problems through composite applications, and facilitate collaboration with other site users.

Users perform all site user tasks. They optimize Web Part pages for team use by adding and configuring Web Parts from the Web Part gallery. They customize dashboards to target the information presented. Users focus on adapting SharePoint sites to their teams’ needs and improving productivity.
Credit Toward CertificationWhen you pass Exam 77-886: SharePoint 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): SharePoint 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Access 2010

Preparing for an Exam
The typical candidate for the exam works as a user support professional, trainer, teacher, professor, database user, or database creator who needs to create or maintain a basic Access database. Users can create, modify, and extend functionality of basic database objects, including tables, queries, forms, and reports. Users can also construct and modify basic relationships among database entities and can instruct others in basic Access functionality and usage.
 
 
Credit Toward CertificationWhen you pass Exam 77-885: Access 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Access 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office PowerPoint 2010

Preparing for an Exam
The typical candidate for the exam is a student, office worker, or instructor who needs to navigate PowerPoint 2010 at the feature and functionality level.
Exam Topics Covered
Users create complex slide shows, such as product plans, reports, and marketing materials. They create slide shows based on custom templates generated by others and frequently reuse slides. Their slides include sophisticated data presented in visual formats.  These users know how to pause and move back and forth in slide shows, jump to specific slides, drill down to supporting data, and mark up slides.
 
Credit Toward CertificationWhen you pass Exam 77-883: PowerPoint 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): PowerPoint 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Outlook 2010

Preparing for an Exam
The typical candidate for the exam is a student, office worker, or instructor who is able to navigate Outlook 2010 at the feature and functionality level.
Exam Topics Covered
Users can format message content by using character and paragraph formatting, use graphic elements such as charts and tables, and create contact records, tasks, and appointments from incoming messages. They create contact groups, schedule meetings, and share schedules to facilitate communication with other Outlook users.
 
Credit Toward CertificationWhen you pass Exam 77-884: Outlook 2010, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Outlook 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Excel 2010 Expert

Preparing for an Exam
The Microsoft Certification website and this preparation guide contain a variety of resources to help you prepare for an exam.Preparing for and Taking an Exam — FAQ provides answers to frequently asked questions about exam registration,preparationscoring, and policies, including:
  • The most effective way to prepare to take an exam.
  • The relationship between Microsoft training materials and exam content.
  • Microsoft policy concerning the incorporation of service pack and revision updates into exam content.
  • Exam question types and formats.
  • Exam time limits and number of questions asked.
We recommend that you review this preparation guide in its entirety and familiarize yourself with the FAQs and resources on the Microsoft Certification website before you schedule your exam.
 
Audience Profile
Candidates for this exam should have Expert-level Microsoft Office Excel 2010 users are able to efficiently and confidently use Excel 2010 software at the feature and functionality levels. Expert users are proficient with advanced formulas, functions, and data analysis tools. Expert users can manipulate data for analysis, presentation, and collaboration. In addition, expert users can manipulate Excel options to customize their environment to meet varying needs and enhance their productivity.
Credit Toward CertificationWhen you pass Exam 77-888: Excel 2010 Expert, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Microsoft Excel 2010 Expert
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Word 2010 Expert

Preparing for an Exam
The Microsoft Certification website and this preparation guide contain a variety of resources to help you prepare for an exam.Preparing for and Taking an Exam — FAQ provides answers to frequently asked questions about exam registration,preparationscoring, and policies, including:
  • The most effective way to prepare to take an exam.
  • The relationship between Microsoft training materials and exam content.
  • Microsoft policy concerning the incorporation of service pack and revision updates into exam content.
  • Exam question types and formats.
  • Exam time limits and number of questions asked.
We recommend that you review this preparation guide in its entirety and familiarize yourself with the FAQs and resources on the Microsoft Certification website before you schedule your exam.
 
Audience Profile
Expert-level Microsoft Office Word 2010 users are able to proficiently and confidently use Word 2010 software at the feature and functionality levels.  Expert users work with the advanced features of Word 2010 to enhance professional documents, create documents ready for publication, and collaborate effectively on group editing projects. Expert users manipulate Word options to customize their environment to meet varying needs and enhance their productivity.
Credit Toward CertificationWhen you pass Exam 77-887: Word 2010 Expert, you complete the requirements for the following certification(s):
Microsoft Office Specialist (MOS): Microsoft Word 2010 Expert
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Excel 2010

Preparing for an Exam
This exam validates the skills needed to be proficient in Excel 2010.
 
Audience Profile
The Core-level Microsoft Office Excel 2010 User should be able to navigate Microsoft Office Excel 2010 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Excel 2010. The core-level user should be able to use Microsoft Office Excel 2010 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to:

•       Accountants
•       Clerical, Office professionals
•       Consultants
•       Executives/Managers
•       Help desk personnel
•       Instructors/Trainers
•       Program/Project Managers
•       Sales
•       Students
•       Other members of the general population

Tasks that might be undertaken or work products created by members of the Microsoft Excel 2010 Core-level User Target Audience might include, but would not be limited to:

•       Charting
•       Create analytical, financial, etc. reports
•       Data entry
•       Family budget
•       Format numerical (financial, statistical, etc.) reports
•       Forms
•       Graphing
•       Process data
•       Reporting
•       Technical support
•       Trending
Credit Toward CertificationWhen you pass Exam 77-882: Excel 2010, you complete the requirements for the following certification(s):Microsoft Office Specialist: Microsoft Excel 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.

MOS: Microsoft Office Word 2010

Preparing for an Exam
This exam validates the skills needed for proficiency in Word 2010.
 
Audience Profile
The Core-level Microsoft Office Word 2010 User should be able to navigate Microsoft Office Word 2010 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Word 2010. The core-level user should be able to use Microsoft Office Word 2010 to create and edit professional-looking documents for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to, the following:

•       Clerical, Office professionals
•       Consultants
•       Executives/Managers
•       Help desk personnel
•       Instructors/Trainers
•       Marketing personnel
•       Product developers
•       Sales
•       Students
•       Writers
•       Other members of the general population

Tasks that might be undertaken or work products created by members of the Microsoft Word 2010 Core-level User Target Audience might include, but are not be limited to, the following:

•       Blogging
•       Business plans
•       Business reports
•       Case studies
•       Creating Forms
•       Documentation
•       Journals
•       Letters
•       Marketing materials
•       Outlining
•       Papers
•       Publications (books, articles)
•       Recipes
•       Reports
•       Scrapbooking
•       Studies
•       User manuals
•       Web info/papers
•       White papers
Credit Toward CertificationWhen you pass Exam 77-881: Word 2010, you complete the requirements for the following certification(s):Microsoft Office Specialist: Microsoft Office 2010
Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft. Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.