<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thank you for sharing, Karen.</div>
<div>
<div style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<p style="color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255); font-size:11pt; font-family:Calibri,sans-serif; margin:0px">
</p>
<div style="margin:0px; font-size:15px; color:rgb(32,31,30); text-align:start; background-color:rgb(255,255,255)">
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0px"><img align="left" alt="Title: SBCTC logo - Description: Compass" style="width: 60px; height: 113px; max-width: initial;" width="60" height="113" data-outlook-trace="F:1|T:1" src="cid:359d8e1a-a5a5-4731-90b7-9fa5ac9c4d1f"></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0px"><b><span style="margin: 0px; font-size: 14pt; font-family: "Franklin Gothic Book", sans-serif, serif, EmojiFont; color: rgb(0, 32, 96);">Monica M. Olsson (she/her/hers)</span></b></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0px"><span style="margin:0px; font-size:12pt; font-family:"Franklin Gothic Book",sans-serif,serif,EmojiFont; color:rgb(0,32,96)">Policy Associate – Accessible IT Coordinator</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0px"><span style="margin:0px; font-size:12pt; font-family:"Franklin Gothic Book",sans-serif,serif,EmojiFont; color:rgb(0,32,96)">Washington State Board for Community and Technical Colleges</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0px"><u><span style="margin:0px; font-size:12pt; font-family:"Franklin Gothic Book",sans-serif,serif,EmojiFont; color:rgb(5,99,193)"><a href="mailto:molsson@sbctc.edu" target="_blank" rel="noopener noreferrer" style="margin:0px"><span style="margin:0px"><b>molsson@sbctc.edu</b></span></a></span></u><span style="margin:0px; font-size:12pt; font-family:"Franklin Gothic Book",sans-serif,serif,EmojiFont; color:rgb(0,32,96)"><span><b> </b></span>•
o: 360-704-3922 • c: 206-914-7187</span></p>
<p style="font-size:11pt; font-family:Calibri,sans-serif; margin:0px"><span style="margin:0px; font-size:12pt; font-family:"Franklin Gothic Book",sans-serif,serif,EmojiFont; color:rgb(0,32,96)"><a href="https://www.sbctc.edu/" target="_blank" rel="noopener noreferrer" style="margin:0px">sbctc.edu</a><span> </span>•
Twitter:<span> </span><a href="https://twitter.com/SBCTCWashington" target="_blank" rel="noopener noreferrer" style="margin:0px"><b>@SBCTCWashington</b></a><span> </span>• Facebook:<b><span> </span><a href="https://www.facebook.com/wasbctc/" target="_blank" rel="noopener noreferrer" style="margin:0px">@WASBCTC</a></b></span></p>
</div>
<br>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> athen-list <athen-list-bounces@mailman12.u.washington.edu> on behalf of Karen McCall <K4mccall@outlook.com><br>
<b>Sent:</b> Friday, May 27, 2022 12:12 PM<br>
<b>To:</b> Access Technology Higher Education Network <athen-list@u.washington.edu><br>
<b>Subject:</b> [SPAM] Re: [Athen] Excel accessibility wizard needed!</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Cambria}
@font-face
{font-family:"Franklin Gothic Book"}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
p.x_xmsonormal, li.x_xmsonormal, div.x_xmsonormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
span.x_EmailStyle26
{font-family:"Cambria",serif;
color:#1F3864}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864">This is the file I use in my accessible Excel training.</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864"> </span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864">I also recommend creating a linked TOC as the first worksheet.</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864"> </span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864">By creating the links, using your example of the instructor already creating named ranges, you could only link to the major topic areas, not all the named ranges.
This would provide flexibility in either seeing all the named ranges or using the links to see/go to specific ones.</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864"> </span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864">Cheers, Karen</span></p>
<p class="x_MsoNormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864"> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b>From:</b> athen-list <athen-list-bounces@mailman12.u.washington.edu>
<b>On Behalf Of </b>Monica Olsson<br>
<b>Sent:</b> Friday, May 27, 2022 3:02 PM<br>
<b>To:</b> Access Technology Higher Education Network <athen-list@u.washington.edu><br>
<b>Subject:</b> Re: [Athen] Excel accessibility wizard needed!</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Arial",sans-serif; color:black">Thanks, Karen. I am mostly tracking your suggestions...and think this may be close to what the professor is already doing.</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Arial",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Arial",sans-serif; color:black">Do you have an example excel file I could look at, please? Or would you consider a brief conversation with me on Zoom? Thanks again!</span></p>
</div>
<div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; font-family:"Arial",sans-serif; color:black"> </span></p>
</div>
<div id="x_Signature">
<div>
<div>
<p style="background:white"><span style="color:#201F1E"> </span></p>
<div>
<p style="background:white"><img width="60" height="113" align="left" alt="Title: SBCTC logo - Description: Compass" style="width:.625in; height:1.177in" data-outlook-trace="F:1|T:1" src="cid:image002.png@01D871DC.29EF92E0"><b><span style="font-size:14.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060">Monica
M. Olsson (she/her/hers)</span></b><span style="color:#201F1E"></span></p>
<p style="background:white"><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060">Policy Associate – Accessible IT Coordinator</span><span style="color:#201F1E"></span></p>
<p style="background:white"><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060">Washington State Board for Community and Technical Colleges</span><span style="color:#201F1E"></span></p>
<p style="background:white"><u><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#0563C1"><a href="mailto:molsson@sbctc.edu" target="_blank"><b>molsson@sbctc.edu</b></a></span></u><b><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060"> </span></b><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060">•
o: 360-704-3922 • c: 206-914-7187</span><span style="color:#201F1E"></span></p>
<p style="background:white"><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sbctc.edu%2F&data=05%7C01%7C%7C90b5891373d341f6ec8508da40139d3a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637892750251043729%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=RaSaJDyfIrbaUAnKPoQMw1iuzI55B3SXIUeWZ8VXyHw%3D&reserved=0" target="_blank">sbctc.edu</a> •
Twitter: <a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FSBCTCWashington&data=05%7C01%7C%7C90b5891373d341f6ec8508da40139d3a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637892750251043729%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=sq99e4SSm4fOZ22iFJGq6i6aOF9xGrwQcXBP8Mw7Zco%3D&reserved=0" target="_blank"><b>@SBCTCWashington</b></a> •
Facebook:<b> <a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Fwasbctc%2F&data=05%7C01%7C%7C90b5891373d341f6ec8508da40139d3a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637892750251043729%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=oNSWmlsZ0hm5xAJEu%2BOc3bo8eo5J4kpp0r%2Fn6PmM1SM%3D&reserved=0" target="_blank">@WASBCTC</a></b></span><span style="color:#201F1E"></span></p>
</div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
</div>
</div>
</div>
<div class="x_MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="x_MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> athen-list <<a href="mailto:athen-list-bounces@mailman12.u.washington.edu">athen-list-bounces@mailman12.u.washington.edu</a>> on behalf of Karen McCall <<a href="mailto:K4mccall@outlook.com">K4mccall@outlook.com</a>><br>
<b>Sent:</b> Friday, May 27, 2022 8:03 AM<br>
<b>To:</b> Access Technology Higher Education Network <<a href="mailto:athen-list@u.washington.edu">athen-list@u.washington.edu</a>><br>
<b>Subject:</b> [SPAM] Re: [Athen] Excel accessibility wizard needed!</span> </p>
<div>
<p class="x_MsoNormal"> </p>
</div>
</div>
<div>
<div>
<p class="x_xmsonormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864">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.</span></p>
<p class="x_xmsonormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864"> </span></p>
<p class="x_xmsonormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864">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.</span></p>
<p class="x_xmsonormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864"> </span></p>
<p class="x_xmsonormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864">Cheers, Karen</span></p>
<p class="x_xmsonormal"><span style="font-size:14.0pt; font-family:"Cambria",serif; color:#1F3864"> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_xmsonormal"><b>From:</b> athen-list <<a href="mailto:athen-list-bounces@mailman12.u.washington.edu">athen-list-bounces@mailman12.u.washington.edu</a>>
<b>On Behalf Of </b>Monica Olsson<br>
<b>Sent:</b> Friday, May 27, 2022 10:31 AM<br>
<b>To:</b> Access Technology Higher Education Network <<a href="mailto:athen-list@u.washington.edu">athen-list@u.washington.edu</a>><br>
<b>Subject:</b> [Athen] Excel accessibility wizard needed!</p>
</div>
</div>
<p class="x_xmsonormal"> </p>
<div>
<p class="x_xmsonormal"><span style="font-size:12.0pt; font-family:"Arial",sans-serif; color:black">ATHEN colleagues,</span></p>
</div>
<div>
<p class="x_xmsonormal"><span style="font-size:12.0pt; font-family:"Arial",sans-serif; color:black"> </span></p>
</div>
<div>
<p class="x_xmsonormal"><span style="font-size:12.0pt; font-family:"Arial",sans-serif; color:black">I need your help!</span></p>
</div>
<div>
<p class="x_xmsonormal" style="background:white"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_xmsonormal" style="background:white"><span style="font-size:12.0pt; color:black">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.</span></p>
</div>
<div>
<p class="x_xmsonormal" style="background:white"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_xmsonormal" style="background:white"><span style="font-size:12.0pt; color:black">Her question is below and I have attached the mentioned files as well.</span></p>
</div>
<div>
<p class="x_xmsonormal" style="background:white"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_xmsonormal" style="background:white"><span style="font-size:12.0pt; color:black">From professor:</span></p>
</div>
<div>
<p class="x_xmsonormal" style="background:white"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
<div>
<p class="x_xmsonormal" style="background:white"><span style="color:#201F1E; background:white">While we have recently discovered a feature that lets a student <i>efficiently</i> 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 <i>in the process of creating a formula</i>. 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.</span></p>
</div>
<div>
<div>
<p class="x_xmsonormal" style="background:white"><span style="font-size:12.0pt; font-family:"Arial",sans-serif; color:black"> </span></p>
</div>
<p class="x_xmsonormal" style="background:white"><span style="color:#201F1E; background:white">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.</span></p>
</div>
<div>
<div>
<p class="x_xmsonormal"><span style="font-size:12.0pt; font-family:"Arial",sans-serif; color:black"> </span></p>
</div>
<div id="x_x_Signature">
<div>
<div>
<p style="background:white"><span style="color:#201F1E"> </span></p>
<div>
<p style="background:white"><img width="60" height="113" align="left" alt="Title: SBCTC logo - Description: Compass" style="width:.625in; height:1.177in" data-outlook-trace="F:1|T:1" src="cid:image003.png@01D871DB.B67D6F80"><b><span style="font-size:14.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060">Monica
M. Olsson (she/her/hers)</span></b></p>
<p style="background:white"><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060">Policy Associate – Accessible IT Coordinator</span></p>
<p style="background:white"><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060">Washington State Board for Community and Technical Colleges</span></p>
<p style="background:white"><u><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#0563C1"><a href="mailto:molsson@sbctc.edu" target="_blank"><b>molsson@sbctc.edu</b></a></span></u><b><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060"> </span></b><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060">•
o: 360-704-3922 • c: 206-914-7187</span></p>
<p style="background:white"><span style="font-size:12.0pt; font-family:"Franklin Gothic Book",sans-serif; color:#002060"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sbctc.edu%2F&data=05%7C01%7C%7C90b5891373d341f6ec8508da40139d3a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637892750251043729%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=RaSaJDyfIrbaUAnKPoQMw1iuzI55B3SXIUeWZ8VXyHw%3D&reserved=0" target="_blank">sbctc.edu</a> •
Twitter: <a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FSBCTCWashington&data=05%7C01%7C%7C90b5891373d341f6ec8508da40139d3a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637892750251200245%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=0mGa1gvR5mgBhunxZ3zegUt6jz3rue%2BdAWyxmJgEOs8%3D&reserved=0" target="_blank"><b>@SBCTCWashington</b></a> •
Facebook:<b> <a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Fwasbctc%2F&data=05%7C01%7C%7C90b5891373d341f6ec8508da40139d3a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637892750251200245%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4gDQ5jCuEtGcZgz5aL2gUVjIwfm9MnRjURTMceKjODk%3D&reserved=0" target="_blank">@WASBCTC</a></b></span></p>
</div>
<p class="x_xmsonormal"><span style="font-size:12.0pt; color:black"> </span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>