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

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

MOS: Microsoft Office 2013 with Word, Excel and PowerPoint

$239.99

Buy Now

Related Courses

All Course