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

This course includes:

Free pre-assessment and first 2 lessons

41+ Interactive Lessons | 51+ Exercises

Accessible on mobile and tablet too

Certificate of completion

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.

Interactive Lessons

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

Gamified TestPrep

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

Lesson Plan

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

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

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

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

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

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

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

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

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

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

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

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

Managing Document Security, Comments, and Tracked Changes

Protection Types
Comments and Tracked Changes
Accepting and Rejecting Changes
Summary

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

Word Options and Settings

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

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

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

Creating and Saving Presentation Files

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

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

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

Formatting Paragraphs and Text Boxes

Formatting Bulleted Lists
Formatting Numbered Lists
Formatting Text Boxes
Summary

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

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

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

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

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

Creating Animation Effects and Transitions

Assigning Transitions to Slides
Animating Slide Content
Summary

Creating Support Materials

The When and How of Handouts
Creating Handouts
Summary

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

Sharing and Collaborating

Working with Comments
Comparing and Merging Presentations
Summary

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

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

Essential Worksheet Operations

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

Working with Cells and Ranges

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

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

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

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

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

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

Visualizing Data Using Conditional Formatting

About Conditional Formatting
Specifying Conditional Formatting
Working with Conditional Formats
Summary

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

Lessons Lab TestPrep AI Tutor

Microsoft Office Word 2016 Expert (77-725 & 77-726)

ISBN: 9781644591505
77-725-77-726

Try Buy Now

Lessons Lab TestPrep AI Tutor

Microsoft Office Excel 2016 Expert (77-727-77-728)

ISBN: 9781644591406
77-727-77-728

Try Buy Now

Lessons Lab TestPrep AI Tutor

Microsoft PowerPoint 2016

ISBN: 9781644591062
77-729

Try Buy Now

Lessons Lab TestPrep AI Tutor

Microsoft Access 2016 (77-730)

ISBN: 9781644591543
77-730

Try Buy Now

Lessons Lab TestPrep AI Tutor

Microsoft Azure Administration (AZ-104)

ISBN: 9781644593226
AZ-104.AP2

Try Buy Now

Lessons Lab TestPrep AI Tutor

Developing Solutions for Microsoft Azure

ISBN: 9781644593639
AZ-204.AP1

Try Buy Now

Lessons Lab TestPrep AI Tutor

Designing Microsoft Azure Infrastructure Solutions

ISBN: 9781644594216
AZ-305.AP1

Try Buy Now