MOS-2013

MOS: Microsoft Office 2013 with Word, Excel and PowerPoint

Prepare for the MOS certification. Master Word, Excel, and PowerPoint with hands-on Microsoft Office 2013 training.

Practice in 131 Hands-On Labs — nothing to install
41 Interactive Lessons and 315 topics mapped to the official exam objectives
337 Practice Test Questions and 3 Full Length Tests

Beginner Self-paced · 1 year access 4.3/5 (121 Reviews)

131 Hands-On LiveLabs

Practice real IT tasks in guided environments.

Real environments
Auto-graded
No installation

41Interactive Lessons

315Topics

131LiveLab

337Practice Test Questions

200Videos

265Flashcards

265Glossary of terms

01 / Skills you'll get

What you will be able to do

Try Free → No credit card required

Enroll in our in-depth Microsoft Office Specialist 2013 course, designed for today’s learners and tomorrow’s professionals.

This course offers a complete walkthrough of Microsoft Word, Excel, and PowerPoint 2013, covering everything from creating polished documents and presentations to working efficiently with data and visuals. Whether you're formatting reports, designing impactful slides, or organizing information with charts and tables, you’ll gain practical experience through real-world tasks.

Ideal for upskilling or reskilling, this course helps you improve your workflow, and earn a certification that adds real value to your resume.

Professional Document Creation: Master the art of designing clean, structured, and impactful documents using Microsoft Word tools like styles, formatting, and templates.
Data Management & Analysis: Develop practical skills in Excel; work with formulas, tables, charts, and conditional formatting to organize and analyze data.
Effective Presentation Design: Create compelling PowerPoint presentations using themes, layouts, SmartArt, and multimedia elements that engage and inform your audience.
Productivity Tools & Automation: Streamline everyday tasks by using features like Quick Access Toolbar, AutoCorrect, and macros to save time and boost efficiency.
Collaborative Editing & File Management: Learn to manage and share documents securely with tools like version tracking, comments, and document protection.
Integrated Office Proficiency: Understand how Word, Excel, and PowerPoint work together, so you can move between tools seamlessly and produce professional outputs across the suite.

Course Highlights

41 Structured Lessons Comprehensive coverage of core course objectives
131 Hands-On LiveLabs Interactive guided scenarios with instant evaluation
337 Practice Questions Assessment tests with detailed answer rationales
1 Year Full Access Self-paced learning accessible anytime on all devices

02 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

41 Interactive Lessons · 315 topics

01 Taking Your First Steps with Word 10 topics

Welcome to a New Word
The Office Look
Using the Word Start Screen
Touring the Word Screen
Exploring the File Tab
Undoing and Redoing Actions
Setting Word Options
Getting Help
Exiting Word
Summary

02 Diving Into Document Creation 11 topics · 4 LiveLab

Creating a Blank File
Creating a File from a Template
Opening an Existing File
Saving and File Formats
Compatibility with Previous Versions of Word
Choosing the Right Word View for the Task at Hand
Printing a Document
Achieving Attractive Documents with Styles
Constructing Documents Faster with Outlining
Cleaning Up Content with AutoCorrect
Summary

4 LiveLab in this lesson — see the labs panel →

03 Font/Character Formatting 7 topics · 12 LiveLab

Working with Document Style and Content
Reviewing the Ways You Can Format Text in Word
Applying Character Formatting
Structuring Text with Paragraph Formatting
Setting Off Text with Paragraph Decoration
Using the Styles Group to Apply Styles
Checking Spelling and Grammar

12 LiveLab in this lesson — see the labs panel →

04 Cutting, Copying, and Pasting Using the Clipboard 7 topics · 2 LiveLab

Adding and Moving Document Content with Cut, Copy, and Paste
Managing Pasting Options
Searching with the Navigation Pane
Starting an Advanced Find from the Ribbon
Replacing Text via the Ribbon
Jumping to a Document Location with Go To (Ctrl+G)
Summary

2 LiveLab in this lesson — see the labs panel →

05 Cleaning Up with AutoCorrect and AutoFormat 10 topics · 2 LiveLab

Revisiting AutoCorrect
Using Quick Parts and Building Blocks
Inserting a Cover Page
Printing Envelopes and Labels Automatically
Printing an Envelope
Creating Labels
Creating PDF or XPS Output
Emailing a Document
Blogging
Summary

2 LiveLab in this lesson — see the labs panel →

06 Building Tables, Charts, and SmartArt to Show Data and Process 6 topics · 4 LiveLab

Illustrating Your Story with Graphics
Getting a Quick Start with Quick Tables
Table Basics
Working with Table Layout and Design
Inserting SmartArt
Summary

4 LiveLab in this lesson — see the labs panel →

07 Adding Pictures and WordArt to Highlight Information 7 topics · 7 LiveLab

Inserting Pictures from a File
Adding an Online Picture
Pasting or Snapping a Picture
Manipulating Inserted Pictures (and Other Graphics)
Creating WordArt
Arranging Pictures and Other Objects
Summary

7 LiveLab in this lesson — see the labs panel →

08 Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations 5 topics · 3 LiveLab

Adding a Drop Cap for Drama
Why Use Text Boxes?
Inserting a Text Box
Inserting a Shape
Summary

3 LiveLab in this lesson — see the labs panel →

09 Setting Up the Document with Sections, Headers/Footers, and Columns 10 topics · 5 LiveLab

Improving Document Setup and Look
Changing Basic Page Setup
Section Formatting
Headers and Footers Overview
Header and Footer Navigation and Design
Adding Header and Footer Material
Considering the Need for Columns
Changing the Number of Columns
Special Column Formatting
Summary

5 LiveLab in this lesson — see the labs panel →

10 Changing Other Page Features 8 topics · 4 LiveLab

Adding and Removing Page Borders
Formatting the Page Background
Applying Page Background Colors, Patterns, Textures, or Pictures
Adding a Watermark
Removing Watermarks and Page Backgrounds
Working More Effectively with Themes
Working with Bookmarks
Hyperlinks

4 LiveLab in this lesson — see the labs panel →

11 Identifying the Contents and Terms in Your Document: TOCs, Captions, and Indexing 13 topics · 4 LiveLab

Automating Table of Contents Creation
Working with TOC Styles
Manually Creating a Table of Contents
Updating or Deleting a Table of Contents
Captions and Tables of Captioned Items
Indexing a Document
Footnotes and Endnotes Basics
Working with Footnote and Endnote Styling
Separators and Continuation
Making a Bibliography
Identifying the Sources for Your Bibliography
Editing Citations
Compiling the Citations into a Bibliography

4 LiveLab in this lesson — see the labs panel →

12 Data Documents and Mail Merge 9 topics · 2 LiveLab

Making Documents Work for You
Previewing the Mail Merge Process
Data Considerations
Reviewing Data File Formats
Choosing the Data Document Type
Attaching a Data Source
Assembling a Merge Document
Mail Merge Pane/Wizard
Summary

2 LiveLab in this lesson — see the labs panel →

13 Managing Document Security, Comments, and Tracked Changes 4 topics · 2 LiveLab

Protection Types
Comments and Tracked Changes
Accepting and Rejecting Changes
Summary

2 LiveLab in this lesson — see the labs panel →

14 Customizing the Quick Access Toolbar and Ribbon 6 topics

The QAT?
Changing the Buttons on the Quick Access Toolbar
The Customize Quick Access Toolbar Dialog Box
Making Changes to the Ribbon
Importing and Exporting Ribbon Customizations
Summary

15 Word Options and Settings 8 topics · 2 LiveLab

Opening Word Options
General
Display (and Printing)
Proofing
Save
Language
Advanced
Summary

2 LiveLab in this lesson — see the labs panel →

16 Macros: Recording, Editing, and Using Them 7 topics · 3 LiveLab

Displaying Macro Tools and Creating a Macro
Managing Macros
Understanding More about Macro Security
Macro Storage
Automatic Macros
Visual Basic for Applications: Quick and Dirty Answers
Summary

3 LiveLab in this lesson — see the labs panel →

17 A First Look at PowerPoint 6 topics · 2 LiveLab

Who Uses PowerPoint and Why?
Learning Your Way around PowerPoint
Changing the View
Zooming In and Out
Customizing the Quick Access Toolbar
Summary

2 LiveLab in this lesson — see the labs panel →

18 Creating and Saving Presentation Files 4 topics · 5 LiveLab

Starting a New Presentation
Saving Your Work
Setting Passwords for File Access
Summary

5 LiveLab in this lesson — see the labs panel →

19 Creating Slides and Text Boxes 14 topics · 6 LiveLab

Creating New Slides
Inserting Content from External Sources
Managing Slides
Using Content Placeholders
Creating Text Boxes Manually
Working with Text Boxes
Understanding Layouts and Themes
Changing a Slide's Layout
Applying a Theme
Managing Themes
Changing Colors, Fonts, and Effects
Changing the Background
Managing Slide Masters
Summary

6 LiveLab in this lesson — see the labs panel →

20 Formatting Text 12 topics · 4 LiveLab

Changing the Font
Changing the Font Size
Changing Font Color/Text Fill
Applying Text Attributes
Applying WordArt Styles
Applying Text Effects
Finding and Replacing Text
Correcting Your Spelling and Grammar
Using AutoCorrect to Fix Common Problems
Using the Research Tools
Summary
Finding and Replacing Text

4 LiveLab in this lesson — see the labs panel →

21 Formatting Paragraphs and Text Boxes 4 topics · 1 LiveLab

Formatting Bulleted Lists
Formatting Numbered Lists
Formatting Text Boxes
Summary

1 LiveLab in this lesson — see the labs panel →

22 Creating and Formatting Tables 7 topics · 2 LiveLab

Creating a New Table
Moving around in a Table
Selecting Rows, Columns, and Cells
Editing a Table's Structure
Applying Table Styles
Formatting Table Cells
Summary

2 LiveLab in this lesson — see the labs panel →

23 Drawing and Formatting Objects 11 topics

Working with the Drawing Tools
Understanding Object Formatting
Resizing Objects
Arranging Objects
Merging Shapes
Applying Shape or Picture Styles
Understanding Color Selection
Applying an Object Border
Applying an Object Fill
Applying Object Effects
Summary

24 Creating SmartArt Graphics 10 topics · 9 LiveLab

Understanding SmartArt Types and Their Uses
Inserting a SmartArt Graphic
Formatting a SmartArt Graphic
Inserting Clip Art
Inserting Photos
Sizing and Cropping Photos
Adjusting and Correcting Photos
Compressing Images
Creating a Photo Album Layout
Summary

9 LiveLab in this lesson — see the labs panel →

25 Working with Charts 7 topics · 2 LiveLab

Understanding the Parts of a Chart
Starting a New Chart
Working with Chart Data
Chart Types and Chart Layout Presets
Working with Chart Elements
Formatting a Chart
Summary

2 LiveLab in this lesson — see the labs panel →

26 Adding Sound Effects, Music, and Soundtracks 10 topics · 2 LiveLab

How PowerPoint Uses Audio
When to Use Sounds - and When Not To
Inserting an Audio Clip as an Icon on a Slide
Assigning a Sound to an Object
Configuring Sound Playback
Understanding Video Types
Placing a Video on a Slide
Changing the Video's Formatting
Specifying Playback Options
Summary

2 LiveLab in this lesson — see the labs panel →

27 Creating Animation Effects and Transitions 3 topics · 4 LiveLab

Assigning Transitions to Slides
Animating Slide Content
Summary

4 LiveLab in this lesson — see the labs panel →

28 Creating Support Materials 3 topics · 3 LiveLab

The When and How of Handouts
Creating Handouts
Summary

3 LiveLab in this lesson — see the labs panel →

29 Preparing for a Live Presentation 7 topics · 5 LiveLab

Starting and Ending a Show
Using the On-Screen Show Controls
Using the On-Screen Pen
Using Custom Shows
Creating and Using Sections
Recording Narration and Timings
Summary

5 LiveLab in this lesson — see the labs panel →

30 Sharing and Collaborating 3 topics · 2 LiveLab

Working with Comments
Comparing and Merging Presentations
Summary

2 LiveLab in this lesson — see the labs panel →

31 Introducing Excel 10 topics

Identifying What Excel Is Good For
Seeing What's New in Excel 2013
Understanding Workbooks and Worksheets
Moving Around a Worksheet
Using the Ribbon
Customizing Your Quick Access Toolbar
Creating Your First Excel Workbook
Customizing the Quick Access Toolbar
Customizing the Ribbon
Summary

32 Entering and Editing Worksheet Data 6 topics · 1 LiveLab

Entering Text and Values into Your Worksheets
Entering Text and Values into Your Worksheets
Entering Dates and Times into Your Worksheets
Modifying Cell Contents
Applying Number Formatting
Summary

1 LiveLab in this lesson — see the labs panel →

33 Essential Worksheet Operations 4 topics · 6 LiveLab

Learning the Fundamentals of Excel Worksheets
Controlling the Worksheet View
Working with Rows and Columns
Summary

6 LiveLab in this lesson — see the labs panel →

34 Working with Cells and Ranges 5 topics · 2 LiveLab

Understanding Cells and Ranges
Copying or Moving Ranges
Using Names to Work with Ranges
Adding Comments to Cells
Summary

2 LiveLab in this lesson — see the labs panel →

35 Introducing Tables 17 topics · 5 LiveLab

What Is a Table?
Creating a Table
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
Working with Titles in a Chart
Working with a Legend
Working with Gridlines
Working with Data Series
Sparkline Types
Creating Sparklines
Customizing Sparklines
Summary

5 LiveLab in this lesson — see the labs panel →

36 Worksheet Formatting 8 topics · 1 LiveLab

Getting to Know the Formatting Tools
Using Different Fonts to Format Your Worksheet
Changing Text Alignment
Using Colors and Shading
Adding Borders and Lines
Understanding Document Themes
About Number Formatting
Summary

1 LiveLab in this lesson — see the labs panel →

37 Understanding Excel Files 8 topics · 2 LiveLab

Creating a New Workbook
Saving a Workbook
Password-Protecting a Workbook
Closing Workbooks
Safeguarding Your Work
Excel File Compatibility
Exploring Excel Templates
Summary

2 LiveLab in this lesson — see the labs panel →

38 Printing Your Work 9 topics · 5 LiveLab

Basic Printing
Changing Your Page View
Adjusting Common Page Setup Settings
Adding a Header or Footer to Your Reports
Types of Protection
Protecting a Worksheet
Protecting a Workbook
Exporting Data
Summary

5 LiveLab in this lesson — see the labs panel →

39 Introducing Formulas and Functions 9 topics · 5 LiveLab

Understanding Formula Basics
Entering Formulas into Your Worksheets
Editing Formulas
Using Cell References in Formulas
Correcting Common Formula Errors
Counting and Summing Worksheet Cells
Basic Counting Formulas
Summing Formulas
Summary

5 LiveLab in this lesson — see the labs panel →

40 Visualizing Data Using Conditional Formatting 4 topics

About Conditional Formatting
Specifying Conditional Formatting
Working with Conditional Formats
Summary

41 Enhancing Your Work with Pictures and Drawings 6 topics · 1 LiveLab

Using Shapes
Using SmartArt
Using WordArt
Working with Other Graphic Types
Working with Hyperlinks
Summary

1 LiveLab in this lesson — see the labs panel →

Hands-On Labs Our edge

131 LiveLabs

Creating a document using a template
Saving a document as a Word Template
Applying the Draft view
Changing orientation and margin spacing
Applying font attributes
Customizing the line and character spacing

Customizing character spacing
Applying effects to the text
Customizing text effects
Formatting a paragraph as a numbered list
Formatting paragraphs as a bulleted list
Increasing the indent
Setting the space before paragraphs
Customizing tab settings
Displaying document words count and using Word's Thesaurus features
Applying a heading style
Searching for a word within a document
Finding and replacing a word
Inserting a cover page using Quick Parts
Publishing a document as a PDF
Converting text into a table
Adding a table and then an additional row
Configuring height and width of a table
Inserting SmartArt
Inserting an image and creating its caption
Inserting and customizing images
Changing the brightness and contrast of an image
Applying a picture style to an image
Applying picture effects to an image
Applying artistic effects to an image
Inserting WordArt
Applying a Drop Cap
Inserting text boxes
Inserting symbols
Inserting a page break
Configuring columns
Inserting a section break
Changing the location of the header and footer
Formatting a heading
Changing the color and effects of a page
Inserting a watermark
Inserting a custom text watermark
Inserting a hyperlink
Formatting a table of contents
Customizing a table of contents
Inserting an Endnote
Adding a footnote
Creating a Mail Merge letter
Creating an address list
Marking a document as Final
Specifying editing restrictions
Showing gridlines and hiding rulers
Inserting a page number
Enabling all macros
Creating a macro
Disabling macros
Zooming in the Slide Sorter View
Changing the view settings
Creating file using template
Creating a New Presentation using a Template
Saving a File in XPS Format
Saving a Slide as a JPEG
Finalizing Presentation
Inserting Additional Slides
Customizing Slide Size
Customizing footer
Applying footer
Applying themes
Showing Gridlines
Changing text to WordArt
Hyperlinking a text
Finding and replacing text
Correcting the Spelling Error
Applying bullets
Modifying columns
Applying a table style
Changing color of SmartArt
Reversing the direction of SmartArt
Converting list to SmartArt
Inserting an online picture
Inserting a Picture in a Slide
Cropping an image
Cropping a picture to a shape
Adding an image as a background
Applying picture styles
Modifying chart type
Changing chart type
Setting audio options
Compressing Media
Applying Transition
Applying animation to text strings
Adding paths to animations
Applying animation to shapes
Changing the print outline
Printing handouts in Grayscale
Changing the Print Settings
Starting slide show from the current slide
Starting the slide show from the beginning
Creating a Custom Slide Show
Looping a Slide Show
Setting up slide show
Inserting a comment
Adding a Comment
Using the Cut and Paste functions
Moving a worksheet
Copy a sheet to another workbook
Create a new sheet and color the sheet tab
Set column width and row height
Split a worksheet horizontally
Adding and hiding a column and a row
Deleting data in a cell range
Applying a cell style to a cell range
Sorting a table
Filtering data
Deleting duplicate rows and sorting the table
Applying a Table Style
Using Sparklines to illustrate data trends
Merging and centering cell text
Creating a blank workbook
Creating a workbook using a template
Printing an individual worksheet
Configuring Page Setup for printing
Specifying a print area and checking its layout
Printing repeated header rows
Adding a header and footer
Using the MIN and MAX functions
Using the AVERAGE function
Using the CONCATENATE function
Concatenating text
Using the COUNTIF function
Inserting SmartArt

Labs run in your browser — nothing to install.

03 / Exam details

MOS: Microsoft Office 2013 with Word, Excel and PowerPoint Details

Gain hands-on expertise MOS 2013: 77-418, 77-422 and 77-420 exams with MOS-2013 course. This course covers all the objectives of MOS-2013 exams which includes creating and managing documents, presentations, worksheets and workbooks; formatting text paragraphs, sections, shapes and slides; creating tables, cells and ranges and much more.

Questions 40-60 (per exam)

Duration 50 minutes (per exam)

Passing Score 700 (on a scale of 1000)

Delivered by Certiport (in-person or online)

Question Format Multiple choice, Best answer, Short answer, Case study... single/multiple choice, performance-based

Practice Tests 337 Practice Questions (mapped to official exam objectives)

Certification MOS-2013 Microsoft credential

Ready to take the exam?

Add your official MOS-2013 exam voucher to your order.

Official Voucher · Fast delivery · Retake bundle available

Add Exam Voucher →

Exam voucher is sold separately and not included with standard course.

04 / FAQs

Questions before you start

When did the Microsoft Office Specialist (MOS) certification retire?

The MOS 2013 certification fully retired on June 30, 2024.

How do I get MOS certification?

To obtain the MOS 2013 certification, you need to follow the steps mentioned below:

Select the desired certification level (core, expert & master)
Prepare for the examination by enrolling in a hands-on Office 2013 course
Schedule and take the exam using Pearson VUE center

How long does a MOS take?

You can complete your preparation for the MOS: Microsoft Office 2013 certification in 2-3 months, but the time duration varies depending on your needs.

Where do I take the exam?

Certiport

What is the format of the exam?

Multiple choice, Best answer, Short answer, Case study and so on.

Prepare for Office 2013 Certification

This Microsoft Office 2013 training helps you to create professional documents, automate workflow, and conduct data analysis.

1 year of full access
131 LiveLab included
Certificate of completion

Buy Now — $239.99 Try Free

No credit card required

MOS: Microsoft Office 2013 with Word, Excel and PowerPoint

131 Hands-On LiveLabs

What you will be able to do

Course Highlights

See exactly what you will learn and practice

Lessons

Hands-On Labs Our edge

MOS: Microsoft Office 2013 with Word, Excel and PowerPoint Details

Ready to take the exam?

Questions before you start

You might also like

Prepare for Office 2013 Certification