MS Excel Accessibility
MS Excel Accessibility
Technical level: Beginner
Duration: 135 minutes (estimate)
IAAP CAECs: 2.25 (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.
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