MS Excel Accessibility

Technical level: Beginner

Duration: 120 minutes (estimate)

IAAP CAECs: 2.0 (This class counts toward renewal of IAAP certification)

Course Synopsis:

This course focuses on creating accessible Excel workbooks. Topics include tables, graphs and charts, forms, equations and formulas, macros, and more. A hands-on activity to practice the concepts learned is available, including a tutorial video with guidance and explanations.

Pricing for Online Class

Each class is $45 for a full year of access, or lower for group enrollment, or when purchasing multi-course curriculum packages. See the the full set of curriculum options for details.

Enroll in "MS Excel Accessibility"

You may also subscribe via a Purchase order.

Course Topics: MS Excel Accessibility

  • Table of Contents
  • Introduction
  • Style and Appearance
    • Color to Convey Meaning
    • Color Contrast
    • Excel Cell Styles
  • Structure and Semantics
    • Data Flow
    • Worksheet Names
    • Removing and Marking Blanks
    • Cell A1 and Worksheet & Workbook Summaries
    • Index Sheet
    • Headers and Footers
    • Hidden Rows and Columns
  • Text and Font
    • Font Style and Size
    • Text Formatting
    • Text Visibility
    • Symbols and Special Characters
  • Tables
    • Creating Tables
    • Table Identification and Placement
    • Table Headers
    • Cell Formatting
    • Video Tutorial: Accessible Excel Tables
  • Graphs, Charts, Objects, and Other Visuals
    • Graphs and Charts
    • Images
    • Embedded Files
    • Word Art, SmartArt, Text Boxes, and Other Floating Objects
    • Background Images and Watermarks
  • Multimedia
    • Video and Audio
    • Flashing Content
  • Forms
    • Form Title and Placement
    • Form Design
    • Data Validation
    • Form Controls and ActiveX Controls
    • Locking and Protecting
  • Links
    • Links in General
    • Website Links
    • Links Within Same Excel Workbook
    • Links to Files
    • E-mail Address Links
  • Math, Equations, and Formulas
    • Inserted Equations and Formulas
    • Math in the Cell Layer
    • Excel Functions
  • Macros
  • VBA
  • Navigation
    • Focus Indicator
    • Comments
    • Frozen Rows and Columns
    • Data Filters
    • Names
    • Protecting and Locking
    • Keyboard Navigation Shortcuts
  • Saving
  • Exporting
  • Different Excel Versions
  • Other Spreadsheet Programs