Skip to Main Content

Mastering the Microsoft Office Suite Including Accessibility Features  (MSOF101)

Time: 9am - 4pm
Duration: 5 days

Compatible with 2007, 2010, 2013

Description:

In this course you will learn how to: Create and edit Microsoft Word, Excel and PowerPoint documents; Add accessibility features and test for compliance; Use Long document management techniques in Word; Insert footnotes, endnotes, cross-references and bookmarks; Create an index and a table of figures; Use advanced formulas and functions in Excel; Create and manage Pivot tables; Apply advanced chart formatting; Employ advanced slide design in PowerPoint; Create custom slide shows; Insert sections for slide management; Create versions of a presentation.

Prerequisites:

None

This course is currently available in another city, on demand or for private classes only. Call us at 888.484.2933 to learn more about our flexible scheduling options or complete our Information Request Form and we will contact you to arrange a class date that is suitable to your availability.

Course Outline

  • Working with Microsoft Word
    • Orientation to Word
    • Use the Word Backstage
    • Edit text
    • Format text
    • Format paragraphs
    • Use styles for more effective formatting
    • Work with tables
    • Working with graphics
    • Document building blocks
    • Modify Page Layout
    • Proof documents
  • Creating accessible Microsoft Word documents
    • Adding additional accessibility features
    • Testing for accessibility and repairing issues
    • Working wirh accessible templates
  • Working with Microsoft Excel
    • Explore the Excel interface
    • Enter data
    • Create formulas and functions
    • Format cells
    • Apply conditional formatting
    • Print worksheets
    • Create charts
    • Adjust worksheet views
    • Work with multiple worksheets and workbooks
    • Add accessibility features
  • Working with Microsoft PowerPoint
    • Explore the PowerPoint interface
    • Create and save presentations
    • Print presentations
    • Design presentations
    • Work with text
    • Work with pictures and multimedia
    • Add movement to slides
    • Work with tables and charts
    • View presentations
    • Share your presentations
    • Add accessibility features
  • Mastering Word
    • Use Long document management techniques
    • Sectioning documents
    • Using advanced header and footer functions
    • Insert footnotes, endnotes, cross-references and bookmarks
    • Mastering styles
    • Mail-merging
    • Using building blocks and field codes
    • Creating an index and a table of figures
    • Advanced Find and Replace for document formatting
    • Considering macros
  • Mastering Excel
    • Use advanced formulas and functions
    • Use data validation techniques
    • Manage and analyze data
    • Create and manage Pivot tables
    • Apply advanced chart formatting
    • Use financial and business functions
  • Mastering PowerPoint
    • Employ advanced slide design
    • Use shapes to mask images and videos
    • Include hidden slides
    • Create custom shows
    • Create handouts
    • Insert sections for slide management
    • Add headers, footers, and dates
    • Work with slide and handout masters
    • Create versions of a presentation

Private training is available for this course.

Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.

© 2017 Eliquo, Inc. All rights reserved.