Microsoft

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.

(MOS-2013) / ISBN : 978-1-61691-705-0
Lessons
Lab
TestPrep
121 Reviews
Get A Free Trial

About This Course

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.

Skills You’ll Get

  • 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.
Download Course Outline

1

Taking Your First Steps with Word

  • 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
2

Diving Into Document Creation

  • 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
3

Font/Character Formatting

  • 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
4

Cutting, Copying, and Pasting Using the Clipboard

  • 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
5

Cleaning Up with AutoCorrect and AutoFormat

  • 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
6

Building Tables, Charts, and SmartArt to Show Data and Process

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

Adding Pictures and WordArt to Highlight Information

  • 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
8

Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations

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

Setting Up the Document with Sections, Headers/Footers, and Columns

  • 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
10

Changing Other Page Features

  • 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
11

Identifying the Contents and Terms in Your Document: TOCs, Captions, and Indexing

  • 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
12

Data Documents and Mail Merge

  • 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
13

Managing Document Security, Comments, and Tracked Changes

  • Protection Types
  • Comments and Tracked Changes
  • Accepting and Rejecting Changes
  • Summary
14

Customizing the Quick Access Toolbar and Ribbon

  • 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

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

Macros: Recording, Editing, and Using Them

  • 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
17

A First Look at PowerPoint

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

Creating and Saving Presentation Files

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

Creating Slides and Text Boxes

  • 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
20

Formatting Text

  • 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
21

Formatting Paragraphs and Text Boxes

  • Formatting Bulleted Lists
  • Formatting Numbered Lists
  • Formatting Text Boxes
  • Summary
22

Creating and Formatting Tables

  • 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
23

Drawing and Formatting Objects

  • 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

  • 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
25

Working with Charts

  • 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
26

Adding Sound Effects, Music, and Soundtracks

  • 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
27

Creating Animation Effects and Transitions

  • Assigning Transitions to Slides
  • Animating Slide Content
  • Summary
28

Creating Support Materials

  • The When and How of Handouts
  • Creating Handouts
  • Summary
29

Preparing for a Live Presentation

  • 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
30

Sharing and Collaborating

  • Working with Comments
  • Comparing and Merging Presentations
  • Summary
31

Introducing Excel

  • 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

  • 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
33

Essential Worksheet Operations

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

Working with Cells and Ranges

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

Introducing Tables

  • 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
36

Worksheet Formatting

  • 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
37

Understanding Excel Files

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

Printing Your Work

  • 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
39

Introducing Formulas and Functions

  • 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
40

Visualizing Data Using Conditional Formatting

  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Working with Conditional Formats
  • Summary
41

Enhancing Your Work with Pictures and Drawings

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

1

Diving Into Document Creation

  • Creating a document using a template
  • Saving a document as a Word Template
  • Applying the Draft view
  • Changing orientation and margin spacing
2

Font/Character Formatting

  • 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
3

Cutting, Copying, and Pasting Using the Clipboard

  • Searching for a word within a document
  • Finding and replacing a word
4

Cleaning Up with AutoCorrect and AutoFormat

  • Inserting a cover page using Quick Parts
  • Publishing a document as a PDF
5

Building Tables, Charts, and SmartArt to Show Data and Process

  • Converting text into a table
  • Adding a table and then an additional row
  • Configuring height and width of a table
  • Inserting SmartArt
6

Adding Pictures and WordArt to Highlight Information

  • 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
7

Adding Drop Caps, Text Boxes, Shapes, Symbols, and Equations

  • Applying a Drop Cap
  • Inserting text boxes
  • Inserting symbols
8

Setting Up the Document with Sections, Headers/Footers, and Columns

  • Inserting a page break
  • Configuring columns
  • Inserting a section break
  • Changing the location of the header and footer
  • Formatting a heading
9

Changing Other Page Features

  • Changing the color and effects of a page
  • Inserting a watermark
  • Inserting a custom text watermark
  • Inserting a hyperlink
10

Identifying the Contents and Terms in Your Document: TOCs, Captions, and Indexing

  • Formatting a table of contents
  • Customizing a table of contents
  • Inserting an Endnote
  • Adding a footnote
11

Data Documents and Mail Merge

  • Creating a Mail Merge letter
  • Creating an address list
12

Managing Document Security, Comments, and Tracked Changes

  • Marking a document as Final
  • Specifying editing restrictions
13

Word Options and Settings

  • Showing gridlines and hiding rulers
  • Inserting a page number
14

Macros: Recording, Editing, and Using Them

  • Enabling all macros
  • Creating a macro
  • Disabling macros
15

A First Look at PowerPoint

  • Zooming in the Slide Sorter View
  • Changing the view settings
16

Creating and Saving Presentation Files

  • 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
17

Creating Slides and Text Boxes

  • Inserting Additional Slides
  • Customizing Slide Size
  • Customizing footer
  • Applying footer
  • Applying themes
  • Showing Gridlines
18

Formatting Text

  • Changing text to WordArt
  • Hyperlinking a text
  • Finding and replacing text
  • Correcting the Spelling Error
19

Formatting Paragraphs and Text Boxes

  • Applying bullets
20

Creating and Formatting Tables

  • Modifying columns
  • Applying a table style
21

Creating SmartArt Graphics

  • 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
22

Working with Charts

  • Modifying chart type
  • Changing chart type
23

Adding Sound Effects, Music, and Soundtracks

  • Setting audio options
  • Compressing Media
24

Creating Animation Effects and Transitions

  • Applying Transition
  • Applying animation to text strings
  • Adding paths to animations
  • Applying animation to shapes
25

Creating Support Materials

  • Changing the print outline
  • Printing handouts in Grayscale
  • Changing the Print Settings
26

Preparing for a Live Presentation

  • 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
27

Sharing and Collaborating

  • Inserting a comment
  • Adding a Comment
28

Entering and Editing Worksheet Data

  • Using the Cut and Paste functions
29

Essential Worksheet Operations

  • 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
30

Working with Cells and Ranges

  • Deleting data in a cell range
  • Applying a cell style to a cell range
31

Introducing Tables

  • Sorting a table
  • Filtering data
  • Deleting duplicate rows and sorting the table
  • Applying a Table Style
  • Using Sparklines to illustrate data trends
32

Worksheet Formatting

  • Merging and centering cell text
33

Understanding Excel Files

  • Creating a blank workbook
  • Creating a workbook using a template
34

Printing Your Work

  • 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
35

Introducing Formulas and Functions

  • Using the MIN and MAX functions
  • Using the AVERAGE function
  • Using the CONCATENATE function
  • Concatenating text
  • Using the COUNTIF function
36

Enhancing Your Work with Pictures and Drawings

  • Inserting SmartArt

Any questions?
Check out the FAQs

  Want to Learn More?

Contact Us Now

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

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

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. 

Prepare for Office 2013 Certification

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

$239.99

Buy Now

Related Courses

All Courses