[Athen] Excel accessibility wizard needed!

[Karen McCall]

One of the things I recommend I is using named ranges or a defined name for a cell to create links to specific topics in an Excel worksheet or workbook.

I typically teach that row 1 is reserved for accessibility support: cell A1 contains a description of the worksheet with any oddities. Cells B1 horizontally across row 1 contains links to specific cells in the worksheet so that someone can easily get to the point that they want.

Cheers, Karen

From: athen-list <athen-list-bounces at mailman12.u.washington.edu> On Behalf Of Monica Olsson
Sent: Friday, May 27, 2022 10:31 AM
To: Access Technology Higher Education Network <athen-list at u.washington.edu>
Subject: [Athen] Excel accessibility wizard needed!

ATHEN colleagues,

I need your help!

Are you or anyone you know an Excel accessibility wizard? I am working with an Accounting professor that has done an incredible job redesigning her materials to be accessible to a blind student in her class. She has sent me specific questions about her excel files and there is a need for deeper support that is beyond my current knowledge.

Her question is below and I have attached the mentioned files as well.


>From professor:


While we have recently discovered a feature that lets a student efficiently use range names to create formulas (eliminating the need to know WHERE a given piece of data is actually located), there are times when naming ranges is not efficient.  So there are still times when we need to be able to refer to a specific location in the process of creating a formula.  If the data is located on a sheet other than where the formula resides, the only way we have been able to enter the cell address in the formula is by PRE-locating the cell, then eventually typing the cell address into the formula.  This is cumbersome, time-consuming and a distraction from the flow of accounting thought.  So we are still hoping for a better way.

I've attached two of our accounting files, (both the original file and the completed file) in case you want to forward them to your contact, but I'm not sure how useful they are without some explanation.




[Title: SBCTC logo - Description: Compass]Monica M. Olsson (she/her/hers)

Policy Associate - Accessible IT Coordinator

Washington State Board for Community and Technical Colleges

molsson at sbctc.edu<mailto:molsson at sbctc.edu> * o: 360-704-3922 * c: 206-914-7187

sbctc.edu<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sbctc.edu%2F&data=05%7C01%7C%7C6c645de5ecd946a9521808da3fede6c4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637892588264305706%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=hyVk4nt7mW%2F33cgyoWN9PimWAeNB%2BCdv9eGNANBGxxk%3D&reserved=0> * Twitter: @SBCTCWashington<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FSBCTCWashington&data=05%7C01%7C%7C6c645de5ecd946a9521808da3fede6c4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637892588264305706%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3yQBji295ZTA4Il7ZN%2Bky07Lg9r94nOenXQdYe6MrNg%3D&reserved=0> * Facebook: @WASBCTC<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Fwasbctc%2F&data=05%7C01%7C%7C6c645de5ecd946a9521808da3fede6c4%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637892588264305706%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=CBpbFbuQUhWQDrd3r43%2F5xplrBcR7AKmTQVWwAVeoNw%3D&reserved=0>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman12.u.washington.edu/pipermail/athen-list/attachments/20220527/74f273f9/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 22672 bytes
Desc: image001.png
URL: <http://mailman12.u.washington.edu/pipermail/athen-list/attachments/20220527/74f273f9/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 10667 bytes
Desc: image003.png
URL: <http://mailman12.u.washington.edu/pipermail/athen-list/attachments/20220527/74f273f9/attachment-0001.png>