MOS: Microsoft Office 2013 with Word, Excel and PowerPoint

(MOS-2013)/ISBN:978-1-61691-705-0

This course includes
Lessons
TestPrep
Lab

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.

Here's what you will 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.

Lessons

41+ Lessons | 51+ Exercises | 145+ Quizzes | 265+ Flashcards | 265+ Glossary of terms

TestPrep

15+ Pre Assessment Questions | 3+ Full Length Tests | 24+ Post Assessment Questions | 52+ Practice Test Questions

Here's what you will learn

Download Course Outline

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 13: Managing Document Security, Comments, and Tracked Changes

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

Lessons 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

Lessons 15: Word Options and Settings

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

Lessons 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

Lessons 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

Lessons 18: Creating and Saving Presentation Files

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

Lessons 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

Lessons 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

Lessons 21: Formatting Paragraphs and Text Boxes

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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 27: Creating Animation Effects and Transitions

  • Assigning Transitions to Slides
  • Animating Slide Content
  • Summary

Lessons 28: Creating Support Materials

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

Lessons 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

Lessons 30: Sharing and Collaborating

  • Working with Comments
  • Comparing and Merging Presentations
  • Summary

Lessons 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

Lessons 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

Lessons 33: Essential Worksheet Operations

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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 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

Lessons 40: Visualizing Data Using Conditional Formatting

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

Lessons 41: Enhancing Your Work with Pictures and Drawings

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

Hands-on LAB Activities (Performance Labs)

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

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

Cutting, Copying, and Pasting Using the Clipboard

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

Cleaning Up with AutoCorrect and AutoFormat

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

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

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

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

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

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

Changing Other Page Features

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

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

Data Documents and Mail Merge

  • Creating a Mail Merge letter
  • Creating an address list

Managing Document Security, Comments, and Tracked Changes

  • Marking a document as Final
  • Specifying editing restrictions

Word Options and Settings

  • Showing gridlines and hiding rulers
  • Inserting a page number

Macros: Recording, Editing, and Using Them

  • Enabling all macros
  • Creating a macro
  • Disabling macros

A First Look at PowerPoint

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

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

Creating Slides and Text Boxes

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

Formatting Text

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

Formatting Paragraphs and Text Boxes

  • Applying bullets

Creating and Formatting Tables

  • Modifying columns
  • Applying a table style

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

Working with Charts

  • Modifying chart type
  • Changing chart type

Adding Sound Effects, Music, and Soundtracks

  • Setting audio options
  • Compressing Media

Creating Animation Effects and Transitions

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

Creating Support Materials

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

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

Sharing and Collaborating

  • Inserting a comment
  • Adding a Comment

Entering and Editing Worksheet Data

  • Using the Cut and Paste functions

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

Working with Cells and Ranges

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

Introducing Tables

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

Worksheet Formatting

  • Merging and centering cell text

Understanding Excel Files

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

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

Introducing Formulas and Functions

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

Enhancing Your Work with Pictures and Drawings

  • Inserting SmartArt

Exam FAQs

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.