Spreadsheet Accessibility Features

Welcome to myCPE

Learning Objectives

To explain which feature in Excel can read text aloud to users.
To discuss how to add alternate text to floating objects in Excel spreadsheets to improve accessibility.
To analyze the purpose of cell styles.

Course Description

In this webinar, David shows you how you can make spreadsheets accessible for users relying on assistive technology. Not surprisingly doing so actually makes spreadsheets more accessible for all users. David will show you how to make spreadsheets that are compatible with Section 508 of the United States federal law that requires all users to have equal access to government documents. You’ll learn design strategies, shortcuts, and how to use the Accessibility Checker in certain Excel versions to check for issues before sharing a workbook.

Excel expert David H. Ringstrom demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.

Major topics covered in this CPE course on Excel:

Adding descriptive text to hyperlinks so that the user can determine the purpose or destination through context.
Assigning descriptive file names when saving documents in the. XLSX file format for compatibility with screen readers and accessible testing software.
Assigning meaningful sheet names so that users have a sense of what data is being presented.
Avoid storing vital info in headers and footers, such as Confidential or Do Not Distribute because it falls outside of the reading order and doesn’t appear on the worksheet.
Checking that color contrast is sufficient to ensure accessibility for all.
Complying with the United States federal law known as Section 508 which governs equal access to government information for people with and without disabilities.
Creating a logical reading order for spreadsheets so that they can be navigated cell by cell with arrow keys.
Creating title and heading levels with cell styles.
Disabling the start-up screen in Microsoft 365 so that you can get to a blank spreadsheet faster.
Double-check manual inputs easily by having Excel read numbers aloud to you.
Eliminating pictures of data in spreadsheets because the information is inaccessible via assistive technology.
Enabling users utilizing assistive technology to safely disregard stylistic elements of a spreadsheet by marking them as decorative.

Webinar Qualifies For

2 CPE Credit of Computer Software and Applications for Certified Public Accountants (CPA-US)
2 General Credit of Computer Software and Applications for Accountant/Bookkeeper/Tax Professionals
2 CPE Credit of Computer Software and Applications for Certified Fraud Examiner (CFE)
2 CPE Credit of Information Technology for Certified Government Financial Manager (CGFM)
2 CE Credit of Information Technology (inc. Excel) for Certified FP&A Professional (FP&A)
2 CPE Credit of Computer Software and Applications for Iowa Licensed Public Accountant (IA-LPA)
2 CPE Credit of Computer Software and Applications for Maine Licensed Public Accountant (ME-LPA)
2 CPE Credit of Computer Software and Applications for Delaware Licensed Public Accountant (DE-LPA)

About Instructor

David Ringstrom, CPA (US)

President, EXCEL Accountant

I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:

Microsoft Excel
Microsoft Access
Sage 50/Peachtree Accounting
QuickBooks

Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:

National Association of Certified Valuators and Analysts
Institute of Real Estate Managers
Georgia Society of CPAs
South Carolina Society of CPAs
Georgia Government Finance Officers Association
Atlanta chapter, American Society of Women CPAs
Perimeter Chapter, Georgia Society of CPAs

I teach over 200 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.

I am the co-author of Idiot's Guide to Introductory Accounting. I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.

I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more.

Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting

Additional Information

Duration

2 Hours

Course Level

Basic

Instructional Method

Group Internet Based

Pre-requisites

None

Advance Preparation

None

FAQ’s

Click Here to View

NASBA APPROVED

MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478

MY-CPE LLC (Sponsor Id#: 143597) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.

Ratings and Review

4.5

Excellent

Very Good

Average

Poor

Terrible

Bryan Cheney, CPA (US)

Very good seminar on how to use these features in Excel.

Seymour Finder, CPA (US)

I reinforced my skills. Great prestation.

Kendra Irving, CPA (US)

The seminar was very informative.

Dawn Burdsall, CPA (US)

Very informative!

Rongjie Gao, CPA (US)

good

2 Credits

Add to Watchlist

Subject Area

Computer Software and Applications

Unlimited Access Plan

Access to 13,000+ Hours of Continuing Education Approved Content Know More

Subscribe To Register

Inclusions

Continuing Education Certificates for Multiple Qualifications View
Instant Certificates
Multiple Dates
Access on Mobile, Tablet and Desktop

Didn’t received verification email? Resend Email

Live Webinars

On Demand Webinars

Virtual Conferences

Specialized Packages

Advanced Certification Programs

myCPE Shorts Trending

Preparer Course

Practical Training Courses

U.S. Business Tax Preparer Course

Exam Prep Course

EA Exam Prep Course

Teams Subscription (Per User)

Individual Subscription

Contact Sales Team

646-688-2884

inquiry@my-cpe.com

Schedule a Call

Flat $300 Off

Flat $640 Off

Flat $1000 Off

6 Million+

100K+

"Steven was knowledgeable and thorough…”

Crystal lovejoy

"Great Customer Service”

Lori corry

"It is what it advertised to be”

Brian Carey

"Great customer service”

Steve

Get 60% Off

Get 64% Off

Get 67% Off

Verification Code

Spreadsheet Accessibility Features

Course Details

Learning Objectives

Course Description

Qualifies for

Webinar Qualifies For

Presenter Details

About Instructor

David Ringstrom, CPA (US)

Other Details

Additional Information

2 Hours

Basic

Group Internet Based

None

None

FAQ’s

NASBA APPROVED

Ratings and Review

4.5

Bryan Cheney, CPA (US)

Seymour Finder, CPA (US)

Kendra Irving, CPA (US)

Dawn Burdsall, CPA (US)

Rongjie Gao, CPA (US)

Subject Area

Unlimited Access Plan

Inclusions

Recommended Webinars

Quickbooks for Not-for-Profits

Reconciling in QBO

QuickBooks for Advanced Learners Information - Analysis and better Decisions