Microsoft

MOS: Microsoft Office 2013 with Word, Excel and PowerPoint

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

About This Course

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.

Skills You’ll Get

Microsoft Office Specialist 2013 exam combines cloud and web technologies to extend your method of creating and consuming information and brings a new cloud app model for you to build secure and flexible apps which is discoverable from the familiar Office interface. This exam validates a professional's Microsoft Office skills and abilities.
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

Still have unanswered questions and need to get in touch?

Contact Us Now

Certiport

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

The exam contains 40-60 questions.

50 minutes

700

(on a scale of 1-1000)

  • Retake vouchers can only be used to retake the same exam that was failed.
  • All vouchers must be used prior to their expiration dates, without exception.
  • Retake vouchers must be used within 30 days of the initial failed exam.
  • As of July 1, 2014, the 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.

MOS: Microsoft Office 2013 with Word, Excel and PowerPoint

$239.99

Buy Now

Related Courses

All Course