Scroll to top button

MOS: Microsoft Office 2013 with Word, Excel and PowerPoint

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
Lessons
41+
Exercises
51+
Quizzes
145+
Flashcards
265+
Glossary of terms
265+
TestPrep
Pre-assessment Questions
15+
Full Length Tests
3+
Post-Assessment Questions
24+
Lab
Performance lab
131+
Exam FAQs
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.
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 50 minutes
What is the passing score? 700

(on a scale of 0-1000)

What is the exam's retake policy?
  • 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.
Which certification covers this exam?

Here's what you will learn

  • 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
  • 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
  • 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
  • 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
  • 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
  • Illustrating Your Story with Graphics
  • Getting a Quick Start with Quick Tables
  • Table Basics
  • Working with Table Layout and Design
  • Inserting SmartArt
  • Summary
  • 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
  • Adding a Drop Cap for Drama
  • Why Use Text Boxes?
  • Inserting a Text Box
  • Inserting a Shape
  • Summary
  • 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
  • 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
  • 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
  • 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
  • Protection Types
  • Comments and Tracked Changes
  • Accepting and Rejecting Changes
  • Summary
  • 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
  • Opening Word Options
  • General
  • Display (and Printing)
  • Proofing
  • Save
  • Language
  • Advanced
  • Summary
  • 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
  • Who Uses PowerPoint and Why?
  • Learning Your Way around PowerPoint
  • Changing the View
  • Zooming In and Out
  • Customizing the Quick Access Toolbar
  • Summary
  • Starting a New Presentation
  • Saving Your Work
  • Setting Passwords for File Access
  • Summary
  • 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
  • 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
  • Formatting Bulleted Lists
  • Formatting Numbered Lists
  • Formatting Text Boxes
  • Summary
  • 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
  • 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
  • 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
  • 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
  • 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
  • Assigning Transitions to Slides
  • Animating Slide Content
  • Summary
  • The When and How of Handouts
  • Creating Handouts
  • Summary
  • 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
  • Working with Comments
  • Comparing and Merging Presentations
  • Summary
  • 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
  • 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
  • Learning the Fundamentals of Excel Worksheets
  • Controlling the Worksheet View
  • Working with Rows and Columns
  • Summary
  • Understanding Cells and Ranges
  • Copying or Moving Ranges
  • Using Names to Work with Ranges
  • Adding Comments to Cells
  • Summary
  • 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
  • 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
  • Creating a New Workbook
  • Saving a Workbook
  • Password-Protecting a Workbook
  • Closing Workbooks
  • Safeguarding Your Work
  • Excel File Compatibility
  • Exploring Excel Templates
  • Summary
  • 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
  • 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
  • About Conditional Formatting
  • Specifying Conditional Formatting
  • Working with Conditional Formats
  • Summary
  • Using Shapes
  • Using SmartArt
  • Using WordArt
  • Working with Other Graphic Types
  • Working with Hyperlinks
  • Summary

Hands on Activities (Labs)

  • 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
  • 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
MOS-2013 MOS-2013
MOS-2013
MOS: Microsoft Office 2013 with Word, Excel and PowerPoint
ISBN : 9781616917050
Rating :
(16)