Course Curriculum

Microsoft Word (Word and Word 2019): Exam MO-100

Manage Documents

1.1 Navigate within documents

1.2 Format documents

1.3 Save and share documents

1.4 Inspect documents for issues

Insert and Format Text, Paragraphs, and Sections

2.1 Insert text and paragraphs

2.2 Format text and paragraphs

2.3 Create and configure document sections

Manage Tables and Lists

3.1 Create tables

3.2 Modify tables

3.3 Create and modify lists

Create and Manage References

4.1 Create and manage reference elements

4.2 Create and manage reference tables

Insert and Format Graphic elements

5.1 Insert illustrations and text boxes

5.2 Format illustrations and text boxes

5.3 Add text to graphic elements

5.4 Modify graphic elements

Manage Document

6.1 Add and manage comments

6.2 Manage change tracking

Microsoft Excel (Excel and Excel 2019): Exam MO-200

Manage Worksheets and Workbooks

1.1 Import data into workbooks

1.2 Navigate within workbooks

1.3 Format worksheets and workbooks

1.4 Customize options and views

1.5 Configure content for collaboration

Manage Data Cells and Ranges

2.1 Manipulate data in worksheets

2.2 Format cells and ranges

2.3 Define and reference named ranges

2.4     Summarize data visually

Manage Tables and Table Data

3.1     Create and format tables

3.2 Modify tables

3.3 Filter and sort table data

Perform Operations by using Formulas and Functions

4.1 Insert references

4.2 Calculate and transform data

4.3 Format and modify text

Manage Charts

5.1     Create charts

5.2     Modify charts

5.3     Format charts

Microsoft PowerPoint (PowerPoint and PowerPoint 2019): Exam MO-300

Manage Presentations

1.1 Modify slide masters, handout masters, and note masters

1.2 Change presentation options and views

1.3 Configure print settings for presentations

1.4     Configure and present slide shows

1.5 Prepare presentations for collaboration

Manage Slides

2.1 Insert slides

2.2 Modify slides

2.3 Order and group slides

Insert and Format Text, Shapes, and Images

3.1 Format text

3.2 Insert links

3.3 Insert and format images

3.4 Insert and format graphic elements

3.5 Order and group objects on slides

Insert Tables, Charts, SmartArt, 3D Models, and Media

4.1 Insert and format tables

4.2 Insert and modify charts

4.3 Insert and format SmartArt graphics

4.4 Insert and modify 3D models

4.5 Insert and manage media

Apply Transitions and Animations

5.1     Apply and configure slide transitions

5.2 Animate slide content

5.3 Set timing for transitions

Exam & Certification

1. Word Associate (Word and Word 2019)

2. Word Expert (Word and Word 2019)

3. Excel Associate (Excel and Excel 2019)

4.  Excel Expert (Excel and Excel 2019)

5. PowerPoint Associate (PowerPoint and PowerPoint 2019)

6. Access Expert (Access and Access 2019)

7. Outlook Associate (Outlook and Outlook 2019)

8. OneNote 2013

9. SharePoint 2013

Who should attend?

If you're thinking about switching careers to become a graphic designer, then let me tell you – there has never been a better time. The world is your oyster if you know how to communicate ideas that inspire, inform or engage people.

• Freshers

• Working Professionals

• Entrepreneurs

FAQ's

1. What is Microsoft Office Specialist Certificate?

Microsoft Office Specialist (MOS) certificate is an industry-standard certification from Microsoft, and it is a way to showcase your proficiency in using Microsoft Office products. MOS Certificate shows that an individual has attained a certain level of expertise with Microsoft Office. It involves an examination to measure the competency in the selected Microsoft Office product (Word, Excel, PowerPoint, Access, and Outlook).

2. What are the benefits of the MOS Certification?

The MOS Certification measures the expertise of an individual in using Microsoft Office products (Word, Excel, PowerPoint, Access, and Outlook). The Certificate can help an individual improve confidence in today’s competitive job market, and result in higher earning potential. The MOS Certification also helps employee increase their productivity, and credibility with their colleagues and clients. As an employer, Certification helps them find the right individual for the project with the right skill level and capabilities. Following is a list of some of the benefits of obtaining a Microsoft Certificate:

• Validate your skills as a job seeker
• Differentiate yourself from competitors
• Get your resume noticed
• Gain recognition from your employer
• Leverage the power of the Microsoft brand

3. Are there different levels of MOS Certification?

The MOS certificate consists of 3 levels of certifications: Specialist, Expert, and Master.

To be classified as a MOS Specialist, you must pass any one of the following exams:

• MOS Exam 77-725: Microsoft Office Word 2016
• MOS Exam 77-727: Microsoft Office Excel 2016
• MOS Exam 77-729: Microsoft Office PowerPoint 2016
• MOS Exam 77-730: Microsoft Office Access 2016
• MOS Exam 77-731: Microsoft Office Outlook 2016

To be classified as a MOS Expert, you must pass any one of the following exams:

• MOS Exam 77-726: Microsoft Office Word 2016 Expert
• MOS Exam 77-728: Microsoft Office Excel 2016 Expert

To be classified as MOS Master, you must pass all of the following exams:

• MOS Exam 77-726: Microsoft Office Word 2016 Expert
• MOS Exam 77-728: Microsoft Office Excel 2016 Expert
• MOS Exam 77-729: Microsoft Office PowerPoint 2016

AND one of the following exam:

• MOS Exam 77-730: Microsoft Office Access 2016
• MOS Exam 77-731: Microsoft Office Outlook 2016