Microsoft Excel: Accessible Excel Documents
Excel Training Series | Level 3
Duration: 1 day (9 am – 4 pm)
Microsoft® Excel® Versions: 2010 | 2013 | 2016 | 2019 | 365 (Windows)
Delivery Methods (Instructor-led): Live classroom (LC) | Virtual classroom (VC)
Course Dates: March 18, 2021 (Instructor-led virtual classroom) | View schedule
Course Fee: $245 CDN per person + HST (Virtual classroom), $275 CDN per person + HST (Bring your own device for live classroom courses) or $325 CDN per person + HST (Avantix Learning provides device for live classroom courses)*
Custom training: This course may be delivered at your site or ours as an instructor-led or virtual classroom solution. Contact us at email@example.com for more information including savings for custom group training.
Note: Public scheduled courses are delivered as live instructor-led classroom training or virtual classroom training (as indicated). Bring your own device rates apply to live classroom courses.
In this course, students will learn to create accessible Excel documents using best practices when creating Excel worksheets for users with disabilities. Various tools will be used in Excel to create accessible workbooks including appropriate formatting, tools for navigation, well-designed tables, hyperlinks and graphics such as charts with alternative text. Students will run the accessibility checker and save a file as a PDF (Portable Document Format) or in an alternative format.
Prerequisite: Microsoft Excel: Introduction or equivalent knowledge and skills.
Location and timing: Public scheduled courses are held in downtown Toronto and run from 9:00 am to 4:00 pm (Eastern Time).
Related training: View all Microsoft Excel courses >
Included in this course
- Comprehensive course manual (100+ pages)
- Keyboard shortcuts quick reference
- Sample and exercise files
- Refreshments (for classes conducted in Avantix Learning classrooms)
- Certificate of completion
- Follow-up email support
Key Concepts for Accessible Excel Documents
- Why make Excel files accessible
- How accessibility legislation impacts design of worksheets and workbooks
- Basics of accessibility for users with different types of disabilities
- Understanding how screen readers read digital Excel workbooks
- Integrating best practices when designing accessible files
- Common issues in Excel workbooks
- Naming sheets
Setting up an Accessible Excel Workbook
- Conventions for file names
- Setting a document title metadata using different strategies
- Specifying a document language
Formatting Using Styles
- Formatting using cell heading styles
- Modifying cell styles
- Formatting tables using table styles
- Benefits of naming
- Naming cells and ranges
- Using named cells and ranges to navigate
Working with Fonts
- Selecting fonts based on different criteria to ensure readability
- Best practices in terms of text formatting
- Recommended minimum font sizes
- Issues with specific fonts
Working with Colour
- Considerations when choosing colours
- Issues with colour
- Ensuring sufficient contrast
- Accessible sensory characteristics
- Selecting a colour theme
- Strategies for applying colours in Excel
Working with Images, Charts and Other Non-Text Elements
- Key concepts when working with non-text elements such as images, shapes and charts in accessible documents
- Issues with reading order
- Importance of including alternative text
- Writing alternative text
- Strategies when descriptions are too complex
- Issues with watermarks
- Key concepts when working with charts
Inserting and Formatting Tables
- Recommendations when working with tables
- Common issues with tables
- Formatting with table styles for accessibility
- Specifying a header row
- Including alternative text for tables
Navigating with Hyperlinks
- Inserting hyperlinks
- Best practices for accessibility when using hyperlinks
- Testing hyperlinks
Reading Order and Assistive Technology
- Understanding the importance of reading order
- Reading order issues
- Strategies to check and control reading order
Using Math Equations
- Creating accessible math equations
Creating Accessible Excel Forms
- Key concepts when creating forms in Excel for accessibility
- Alternatives to Excel for form creation
Running the Accessibility Checker
- Checking the document for accessibility issues using the Accessibility Checker in Excel
- Limitations of the Accessibility Checker
Converting an Excel File to PDF or HTML
- Saving a document as a PDF (Portable Document Format) natively
- Specifying options during the saving/export process
- Ensuring the final output includes tags
- Saving a PDF using Acrobat Pro (for users with Acrobat Pro)
- Viewing the PDF file in Acrobat Pro or Reader (for users with Acrobat Pro)
- Saving an Excel file in HTML format
Register Now for a public course at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.
Do you need more information? Contact us!
Related training: View Accessible Documents courses >
To request this page in an alternate format, contact our staff.
*Prices subject to change.
Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some live classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at firstname.lastname@example.org if you'd like to arrange custom training on a date that's convenient for you.
Copyright 2021 Avantix® Learning
Register now for a public scheduled course or contact us at email@example.com for more information about any of our courses or to discuss custom training options (virtual classroom or live classroom).
You may like
During a PowerPoint slide show, you can change your mouse into a laser pointer to focus attention on a specific area on your slide. You can show or hide the built-in laser pointer using keyboard shortcuts or by using the context menu.
You can add audio in PowerPoint from a file on your PC or from a shared drive. Audio is played during a slide show and you can insert music, sound clips, or voice recordings. Since audio files are copied into PowerPoint presentations by default, they can increase file size and may need to be compressed. To play audio, your computer must be equipped with a sound card and speakers.
Check out these three easy ways to copy shape, picture or text formatting quickly and easily in PowerPoint using buttons or keyboard shortcuts.
You can create a pop-up effect in PowerPoint when you hover over or mouse over text, pictures or other objects. When you hover over an object during a slide show, you can have PowerPoint jump to another slide to make it appear that an object is a pop-up.
You can turn off Autofit to stop PowerPoint from changing font size automatically in placeholders, text boxes and shapes containing text. Depending on your preferences, you can turn Autofit off for objects in the current presentation or in all new presentations.
You can insert Excel worksheet data into PowerPoint as an object or a table. Objects can be linked or unlinked. If you insert worksheet data as a table, it cannot be linked but can be formatted in PowerPoint.
You may also like
You can keep text together in several ways in Word. If you want to keep words or characters together, you can use nonbreaking spaces or nonbreaking hyphens or dashes and insert them using a dialog box or a keyboard shortcut. If you want to keep lines or paragraphs together on the same page, you can apply settings in the Paragraph dialog box (which can be built into styles if you use styles).
You can insert the does not equal sign (not equal to sign) in a Word document using Insert Symbol, a keyboard shortcut, an AutoCorrect entry or an Alt shortcut.
If you want to find and replace text or numbers in Word, you can use wildcards if you are not able to find an exact match. To use advanced find and replace techniques in Word, you will need to expand the Find and Replace dialog box.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | firstname.lastname@example.org