$199.80
or 6 vouchers
  • Video Presentations
  • Readings
  • Exercises and Quizzes
  • 1 Year Subscription
Overview

This Microsoft Office Specialist (MOS) 2013 Expert Certification Training course helps prepare students to take the following certification exams:

This course has been tested and approved by ProCert labs, the official tester of Microsoft courseware. The course has been found to meet the highest industry standards of instructional quality.

Goals
  1. Learn to create and edit Microsoft Word documents.
  2. Learn about the Ribbon.
  3. Learn about the File tab.
  4. Learn to create new documents and use Word templates.
  5. Learn to format Word documents.
  6. Learn to add page numbers, headers and footers, and spell and grammar check documents.
  7. Learn to use Word 2013's advanced editing tools.
  8. Learn to work with images, including placing and sizing images, wrapping text around images, and using borders and effects.
  9. Learn to adjust page orientation and layout.
  10. Learn to work with columns.
  11. Learn to work with page and section breaks.
  12. Learn about document views, using the navigation pane, and viewing multiple windows.
  13. Learn to work with tables of contents.
  14. Learn to work with footnotes and endnotes.
  15. Learn to insert bibliographies and indexes.
  16. Learn to use comments.
  17. Learn to use track changes including accepting and rejecting changes.
  18. Learn to compare and combine documents.
  19. Learn to use Mail Merge and create envelopes and labels.
  20. Learn to protect documents.
  21. Learn to use bookmarks, add watermarks, and customize the Ribbon.
  22. Create basic worksheets using Microsoft Excel 2013.
  23. Perform calculations in an Excel worksheet.
  24. Modify an Excel worksheet.
  25. Modify the appearance of data within a worksheet.
  26. Manage Excel workbooks.
  27. Print the content of an Excel worksheet.
  28. Learn to use formulas and functions.
  29. Create and modify charts.
  30. Convert, sort, filter, and manage lists.
  31. Insert and modify illustrations in a worksheet.
  32. Learn to work with tables.
  33. Learn to use conditional formatting and styles.
  34. Create pivot tables and charts.
  35. Learn to trace precedents and dependents.
  36. Convert text and validate and consolidate data.
  37. Collaborate with others by protecting worksheets and workbooks.
  38. Create, use, edit, and manage macros.
  39. Import and export data.
Outline
  1. Creating a Microsoft Word Document
    1. Starting Microsoft Word
    2. Creating a Document
    3. Saving a Document
      1. Backward Compatibility Importing a File
    4. The Status Bar
    5. Closing a Document
    6. Exercise: Create a Microsoft Word Document
  2. The Ribbon
    1. The Ribbon
    2. Tabs Groups
    3. Commands
      1. Inserting Symbols Using Commands
    4. Exercise: Exploring the Ribbon
  3. The Backstage View (The File Menu)
    1. Introduction to the Backstage View Opening a Document
    2. Exercise: Open a Document New Documents and Word Templates
    3. Exercise: Write a Thank You Letter Using a Template Letter
    4. Configuring Documents to Print
      1. Print Document Sections
      2. Set Print Scaling
    5. Exercise: Print a Document
    6. Adding Your Name to Microsoft Word
    7. Adding Values to Document Properties
    8. Working with Autosaved Versions of Documents
  4. The Quick Access Toolbar
    1. Adding Common Commands
    2. Adding Additional Commands with the Customize Dialog Box
    3. Adding Ribbon Commands or Groups
    4. Placement
    5. Exercise: Customize the Quick Access Toolbar
  5. Formatting Microsoft Word Documents
    1. Selecting Text
    2. Selecting Fonts
      1. Clear Existing Formatting
      2. Set Indentation
      3. Change Text to WordArt
    3. Exercise: Working with Fonts
    4. Working with Lists
      1. Creating Custom Bullets
      2. Modifying List Indendation
      3. Modifying Line Spacing in a List
      4. Increasing and Decreasing List Levels
      5. Modifying List Numbering
    5. Exercise:Working with Lists
    6. Inserting a Hyperlink in a Document
    7. Exercise: Inserting a Hyperlink
    8. Using Styles
      1. About Styles
      2. Applying Paragraph Styles
      3. Applying Character Styles Changing Document Style Sets
      4. Creating Quick Styles
    9. Exercise: Applying and Creating Custom Styles
    10. Using Themes
    11. Using the Ruler
    12. Exercise: Using Tabs Setting Margins
    13. Exercise: Setting Margins
  6. Editing Documents
    1. Find
    2. Find and Replace
      1. Using a Wildcard to Find and Replace
    3. Find and Replace Tips
      1. Inserting Text Using AutoCorrect
    4. Appending Text to a Document
      1. Exercise: Using Find and Replace
    5. Using the Clipboard
      1. The Clipboard Group
      2. Copying and Pasting Text
      3. The Office Clipboard Task Pane
    6. Exercise Using the Clipboard
  7. Finalizing Microsoft Word Documents
    1. Adding Page Numbers
    2. Exercise: Adding Page Numbers
    3. Headers and Footers
    4. Exercise: Using Headers and Footers
    5. Checking Spelling and Grammar
    6. Exercise: Checking Spelling and Grammar
  8. Microsoft Word 2013 New Features
    1. Using Read Mode The Object Zoom Feature
    2. Exercise: Exploring the Read Mode and Object Zoom Features
  9. Advanced Formatting
    1. Shading and Borders
    2. Exercise: Using Shading and Borders
    3. Setting Line and Paragraph Spacing
    4. Changing Styles
      1. Benefits of Styles
      2. Setting a New Style Set as Default
      3. Resolving Multi-Document Style Conflicts
      4. Customizing Settings for Existing Styles
      5. Creating Character-Specific Styles
      6. Assigning Keyboard Shortcuts to Styles
      7. Copy Styles from Template to Template Using the Styles Organizer
    5. Exercise: Changing Styles
    6. Paragraph Marks and Other Formatting Symbols
    7. Exercise: Using Formatting Symbols
  10. Working with Tables
    1. Inserting a Table
      1. Converting Tables to Text
      2. Adding a Table Title
      3. Modifying Table Fonts
      4. Sorting Table Data
      5. Setting Cell Margins
      6. Modifying Table Dimensions
      7. Merging Cells
      8. Applying Formulas to a Table
    2. Exercise: Insert a Table
    3. Table Styles
    4. Exercise: Adding Styles to a Table
    5. Formatting a Table
    6. Exercise: Formatting a Table
  11. Working with Images
    1. Inserting Images
      1. Adding Quick Styles to Images
    2. Exercise: Insert an Image into a Microsoft Word Document
    3. Placing and Sizing Images
    4. Exercise: Place and Size an Image in a Microsoft Word Document
    5. Wrapping Text around an Image
    6. Exercise: Wrapping Text around an Image
    7. Adjusting Images
    8. Exercise: Adjusting Images in Microsoft Word
    9. Borders and Effects
    10. Exercise: Adding Borders and Effects to Images in Microsoft Word
  12. Page Layout
    1. Orientation and Paper Size
    2. Working with Columns
    3. Exercise: Changing the Page Setup
    4. Advanced Formatting
      1. Set Character Space Options
      2. Set Advanced Character Attributes
      3. Add Linked Text Boxes
    5. Working with Fields
      1. Add Custom Fields
      2. Modify Field Properties
      3. Create Custom Field Formats
      4. Add Field Controls
      5. Link to External Data
    6. Page and Section Breaks
      1. Preventing Orphans
      2. Adding Page and Section Breaks
    7. Exercise: Adding Page and Section Breaks
  13. Working with Illustrations
    1. Adding and Editing Charts
    2. Exercise 14:Working with Charts
    3. Working with Clip Art
    4. Exercise 15:Working with Clip Art
    5. Using Shapes
      1. Positioning Shapes
      2. Wrapping Text Around Shapes
    6. Exercise: Adding Shapes
    7. Working with SmartArt
      1. Inserting SmartArt
      2. Modifying SmartArt
      3. Positioning SmartArt
    8. Exercise: Working with SmartArt
    9. Creating Captions
      1. Changing Caption Formats
      2. Using Cross-References
    10. Using Building Blocks
      1. Inserting Text Boxes
      2. Moving Building Blocks between Documents
      3. Editing Building Block Properties
    11. Exercise: Inserting a Building Block in a Document
  14. Viewing Your Documents
    1. Document Views
    2. Using the Navigation Pane
      1. Use Show/Hide
    3. Exercise: Using the Navigation Pane
    4. Multiple Windows
    5. Exercise 20:Working with Multiple Windows
  15. Microsoft Word 2013 New Features
    1. Editing PDF Documents in Microsoft Word
    2. Exercise: Editing a PDF in Word
    3. Using Live Layout and Alignment Guides
      1. Live Layout
      2. Alignment Guides
  16. Working with Long Documents
    1. Adding a Table of Contents
    2. Updating the Table of Contents
    3. Deleting the Table of Contents
    4. Exercise: Insert and Update a Table of Contents
    5. Footnotes and Endnotes
    6. Exercise:Working with Footnotes
    7. Inserting Citations and a Bibliography
    8. Exercise: Insert Citations and a Bibliography
    9. Adding an Index
    10. Exercise: Inserting an Index
    11. Inserting a Table of Figures
    12. Inserting and Updating a Table of Authorities
    13. Creating an Outline
      1. Promoting Sections in an Outline
      2. Creating a Master Document
  17. Review and Collaborating on Documents
    1. Adding Comments
    2. Exercise: Adding Comments to a Document
    3. Tracking Changes
    4. Exercise: Tracking Changes
    5. Viewing Changes, Additions, and Comments
    6. Exercise: Viewing Markup
    7. Accepting and Rejecting Changes
    8. Exercise: Accepting and Rejecting Changes
  18. Comparing and Combining Documents
    1. Comparing Documents
    2. Exercise: Comparing Documents
    3. Combining Documents
    4. Exercise: Combining Documents
  19. Managing Mailings
    1. Creating Envelopes and Labels
    2. Exercise: Printing an Envelope
    3. Using Mail Merge
    4. Exercise: Using Mail Merge
  20. Protecting Documents
    1. Making Word Documents Read Only
    2. Password Protect Word Documents
    3. Removing Metadata from Files
    4. Restrict Formatting and Editing
    5. Exercise: Protecting a Document
  21. Random Useful Items
    1. Using Bookmarks
    2. Exercise: Using Bookmarks
    3. Adding Watermarks
    4. Exercise: Adding Custom Watermarks
    5. Adding Titles to Sections
    6. Inserting Built-in Fields
    7. Using the Go To Feature
    8. Using Macros
      1. Copy Macros from Document to Document
      2. Macro Security
    9. Exercise: Recording a Macro
    10. Customizing the Ribbon
    11. Assigning Shortcut Keys
    12. Exercise: Customizing the Ribbon
    13. Preparing a Document for Internationalization and Accessibility
      1. Modify Tab Order
      2. Configure Language Options
      3. Add Alt-Text to Document Elements
      4. Create Documents for Use with Accessibility Tools
      5. Manage Multiple Options for +Body and +Heading Fonts
      6. Apply Global Content Standards
  22. Microsoft Word 2013 New Features
    1. Using the Cloud
    2. Exercise: Using the Cloud
    3. The Resume Reading Feature
  23. Creating a Microsoft Excel Workbook
    1. Starting Microsoft Excel
    2. Creating a Workbook
    3. Saving a Workbook
    4. The Status Bar
    5. Adding and Deleting Worksheets
    6. Copying and Moving Worksheets
    7. Changing the Order of Worksheets
    8. Splitting the Worksheet Window
    9. Closing a Workbook
    10. Exercise: Creating a Microsoft Excel Workbook
  24. The Ribbon
    1. Tabs
    2. Groups
    3. Commands
    4. Exercise: Exploring the Ribbon
  25. The Backstage View (The File Menu)
    1. Introduction to the Backstage View
    2. Opening a Workbook
    3. Exercise: Open a Workbook
    4. New Workbooks and Excel Templates
    5. Exercise: Select, Open and Save a Template Agenda
    6. Printing Worksheets
    7. Exercise: Print a Worksheet
    8. Adding Your Name to Microsoft Excel
    9. Managing Workbook Versions
  26. The Quick Access Toolbar
    1. Adding Common Commands
    2. Adding Additional Commands with the Customize Dialog Box
    3. Adding Ribbon Commands or Groups
    4. Placement
    5. Exercise: Customize the Quick Access Toolbar
  27. Entering Data in Microsoft Excel Worksheets
    1. Entering Text
    2. Expand Data across Columns
    3. Adding and Deleting Cells
    4. Adding an Outline
    5. Adding a Hyperlink
    6. Add WordArt to a Worksheet
    7. Using AutoComplete
    8. Exercise: Entering Text and Using AutoComplete
    9. Entering Numbers and Dates
    10. Using the Fill Handle
    11. Exercise: Entering Numbers and Dates
  28. Formatting Microsoft Excel Worksheets
    1. Selecting Ranges of Cells
    2. Hiding Worksheets
    3. Adding Color to Worksheet Tabs
    4. Adding Themes to Workbooks
    5. Exercise: Customize a Workbook Using Tab Colors and Themes
    6. Adding a Watermark
    7. The Font Group
    8. Exercise: Working with Font Group Commands
    9. The Alignment Group
    10. Exercise: Working with Alignment Group Commands
    11. The Number Group
    12. Exercise: Working with Number Group Commands
  29. Using Formulas in Microsoft Excel
    1. Math Operators and the Order of Operations
    2. Entering Formulas
    3. AutoSum (and Other Common Auto-Formulas)
    4. Copying Formulas and Functions
      1. Displaying Formulas
    5. Relative, Absolute, and Mixed Cell References
    6. Exercise: Working with Formulas
  30. Working with Rows and Columns
    1. Inserting Rows and Columns
    2. Deleting Rows and Columns
    3. Transposing Rows and Columns
    4. Setting Row Height and Column Width
    5. Hiding and Unhiding Rows and Columns
    6. Freezing Panes
    7. Exercise: Working with Rows and Columns
  31. Editing Worksheets
    1. Find
    2. Find and Replace
    3. Exercise: Using Find and Replace
    4. Using the Clipboard
    5. Exercise: Using the Clipboard
    6. Managing Comments
      1. Adding Comments
      2. Working with Comments
  32. Finalizing Microsoft Excel Worksheets
    1. Setting Margins
    2. Setting Page Orientation
    3. Setting the Print Area
    4. Print Scaling (Fit Sheet on One Page)
    5. Printing Headings on Each Page/Repeating Headers and Footers
    6. Headers and Footers
    7. Exercise: Preparing to Print
  33. Microsoft Excel 2013 New Features
    1. One Workbook Per Window Feature
    2. Using Flash Fill
    3. Exercise: Using Flash Fill
  34. Advanced Formulas
    1. Using Named Ranges in Formulas
      1. Naming a Single Cell
      2. Naming a Range of Cells
      3. Naming Multiple Single Cells Quickly
    2. Exercise: Using Named Ranges in Formulas
    3. Using Formulas That Span Multiple Worksheets
    4. Exercise: Entering a Formula Using Data in Multiple Worksheets
    5. Using the IF Function
      1. Using AND/OR Functions
      2. Using the SUMIF, AVERAGEIF, and COUNTIF Functions
    6. Exercise: Using the IF Function
    7. Using the PMT Function
    8. Exercise: Using the PMT Function
    9. Using the LOOKUP Function
    10. Using the VLOOKUP Function
    11. Exercise: Using the VLOOKUP Function
    12. Using the HLOOKUP Function
    13. Using the CONCATENATE Function
    14. Exercise: Using the CONCATENATE Function
    15. Using the TRANSPOSE Function
    16. Using the PROPER, UPPER, and LOWER Functions
      1. The UPPER Function
      2. The LOWER function
      3. The TRIM Function
    17. Exercise: Using the PROPER Function
    18. Using the LEFT, RIGHT, and MID Functions
      1. The MID Function
    19. Exercise: Using the LEFT and RIGHT Functions
    20. Using Date Functions
      1. Using the NOW and TODAY Functions
    21. Exercise: Using the YEAR, MONTH, and DAY Functions
    22. Creating Scenarios
      1. Utilize the Watch Window
      2. Consolidate Data
      3. Enable Iterative Calculations
      4. What-If Analyses
      5. Use the Scenario Manager
      6. Use Financial Functions
  35. Working with Lists
    1. Converting a List to a Table
    2. Exercise: Converting a List to a Table
    3. Removing Duplicates from a List
    4. Exercise: Removing Duplicates from a List
    5. Sorting Data in a List
    6. Exercise: Sorting Data in a List
    7. Filtering Data in a List
    8. Exercise: Filtering Data in a List
    9. Adding Subtotals to a List
      1. Grouping and Ungrouping Data in a List
    10. Exercise: Adding Subtotals to a List
  36. Working with Illustrations
    1. Working with Clip Art
    2. Exercise: Working with Clip Art
    3. Using Shapes
    4. Exercise: Adding Shapes
    5. Working with SmartArt
  37. Visualizing Your Data
    1. Inserting Charts
    2. Exercise: Inserting Charts
      1. Editing Charts
      2. Changing the Layout of a Chart
      3. Changing the Style of a Chart
      4. Adding a Shape to a Chart
      5. Adding a Trendline to a Chart
      6. Adding a Secondary Axis to a Chart
      7. Adding Additional Data Series to a Chart
      8. Switch between Rows and Columns in a Chart
      9. Positioning a Chart
      10. Modifying Chart and Graph Parameters
      11. Watching Animation in a Chart
      12. Showing, Hiding, or Changing the Location of the Legend in a Chart
      13. Show or Hiding the Title of a Chart
      14. Changing the Title of a Chart
      15. Show, Hiding, or Changing the Location of Data Labels in a Chart
      16. Changing the Style of Pieces of a Chart
    3. Exercise: Editing Charts
    4. Add and Format Objects
    5. Insert a Text Box
    6. Create a Custom Chart Template
  38. Working with Tables
    1. Format Data as a Table
    2. Move between Tables and Ranges
    3. Modify Tables
      1. Add and Remove Cells within a Table
    4. Define Titles
      1. Band Rows and Columns
      2. Remove Styles from Tables
    5. Exercise: Creating and Modifying a Table in Excel
  39. Advanced Formatting
    1. Applying Conditional Formatting
    2. Exercise: Using Conditional Formatting
    3. Working with Styles
      1. Applying Styles to Tables
      2. Applying Styles to Cells
    4. Exercise: Working with Styles
    5. Creating and Modifying Templates
      1. Modify a Custom Template
  40. Microsoft Excel 2013 New Features
    1. New Functions in Excel 2013
    2. Exercise: Using the New Excel Functions
    3. Using New Chart Tools
    4. Exercise: Using the New Excel 2013 Chart Tools
    5. Using the Quick Analysis Tool
    6. Exercise: Using the Quick Analysis Tool
    7. Using the Chart Recommendation Feature
  41. Using Pivot Tables
    1. Creating Pivot Tables
      1. Preparing Your Data
      2. Inserting a Pivot Table
    2. Inserting Slicers
    3. Working with Pivot Tables
      1. Grouping Data
      2. Using PowerPivot
      3. Managing Relationships
    4. Inserting Pivot Charts
    5. More Pivot Table Functionality
    6. Exercise: Working with Pivot Tables
  42. Auditing Worksheets
    1. Tracing Precedents
    2. Exercise: Tracing Precedents
    3. Tracing Dependents
    4. Exercise: Tracing Dependents
    5. Showing Formulas
  43. Data Tools
    1. Converting Text to Columns
    2. Exercise: Converting Text to Columns
    3. Linking to External Data
    4. Controlling Calculation Options
    5. Data Validation
    6. Exercise: Using Data Validation
    7. Consolidating Data
    8. Exercise: Consolidating Data
    9. Goal Seek
    10. Exercise: Using Goal Seek
  44. Working with Others
    1. Protecting Worksheets and Workbooks
      1. Password Protecting a Workbook
      2. Removing Workbook Metadata
    2. Exercise: Password Protecting a Workbook
      1. Password Protecting a Worksheet
    3. Exercise: Password Protecting a Worksheet
      1. Password Protecting Ranges in a Worksheet
    4. Exercise: Password Protecting Ranges in a Worksheet
    5. Tracking Changes
      1. Accepting or Rejecting Changes
      2. Setting Tracking Options
      3. Merging Multiple Workbooks
    6. Marking a Workbook as Final
    7. Exercise: Tracking Changes
  45. Recording and Using Macros
    1. Recording Macros
      1. Copy a Macro from Workbook to Workbook
    2. Exercise: Recording a Macro
    3. Running Macros
    4. Editing Macros
    5. Adding Macros to the Quick Access Toolbar
      1. Managing Macro Security
    6. Exercise: Adding a Macro to the Quick Access Toolbar
  46. Random Useful Items
    1. Sparklines
      1. Inserting Sparklines
      2. Customizing Sparklines
    2. Exercise: Inserting and Customizing Sparklines
    3. Preparing a Workbook for Internationalization and Accessibility
      1. Display Data in Multiple International Formats
      2. Modify Worksheets for Use with Accessibility Tools
      3. Use International Symbols
      4. Manage Multiple Options for +Body and +Heading Fonts
    4. Importing and Exporting Files
      1. Importing Text Files
    5. Exercise: Importing Text Files
      1. Exporting Worksheet Data to Microsoft Word
    6. Exercise: Copying Data from Excel to Word
      1. Exporting Excel Charts to Microsoft Word
    7. Exercise: Copying Charts from Excel to Word
  47. Microsoft Excel 2013 New Features
    1. Using Slicers to Filter Data
    2. Exercise: Filtering Data with Slicers
    3. Creating a PivotTable Timeline
    4. Exercise: Creating a Timeline
    5. Creating a Standalone PivotChart
    6. Workspaces in Excel 2013
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Office class:

  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
  • Basic Microsoft Word 2013 skills
  • Intermediate Microsoft Word
  • Familiarity with using a personal computer, mouse, and keyboard.
  • Comfortable in the Windows environment.
  • Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
  • Basic Excel 2013
  • Basic and Intermediate Excel 2013

Experience in the following would be useful for this Microsoft Office class:

  • Basic Microsoft Word skills
Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

72,554

Students who have taken Live Online Training

15,169

Organization who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.42

Students rated our trainers 9.42 out of 10 based on 5,211 reviews

Contact Us or call 1-877-932-8228