<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:"Franklin Gothic Book";
panose-1:2 11 5 3 2 1 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle26
{mso-style-type:personal-reply;
font-family:"Cambria",serif;
color:#1F3864;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1028" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864">This is the file I use in my accessible Excel training.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864">I also recommend creating a linked TOC as the first worksheet.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864"><o:p> </o:p></span></p>
<p class="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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864">Cheers, Karen<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="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!<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="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.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="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!<o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
<div id="Signature">
<div>
<div>
<p style="background:white"><span style="color:#201F1E"> <o:p></o:p></span></p>
<div>
<p style="background:white"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter" />
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0" />
<v:f eqn="sum @0 1 0" />
<v:f eqn="sum 0 0 @1" />
<v:f eqn="prod @2 1 2" />
<v:f eqn="prod @3 21600 pixelWidth" />
<v:f eqn="prod @3 21600 pixelHeight" />
<v:f eqn="sum @0 0 1" />
<v:f eqn="prod @6 1 2" />
<v:f eqn="prod @7 21600 pixelWidth" />
<v:f eqn="sum @8 21600 0" />
<v:f eqn="prod @7 21600 pixelHeight" />
<v:f eqn="sum @10 21600 0" />
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect" />
<o:lock v:ext="edit" aspectratio="t" />
</v:shapetype><v:shape id="Picture_x0020_2" o:spid="_x0000_s1027" type="#_x0000_t75" alt="Title: SBCTC logo - Description: Compass" style='position:absolute;margin-left:0;margin-top:0;width:45pt;height:84.75pt;z-index:251658240;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:0;mso-wrap-distance-top:0;mso-wrap-distance-right:0;mso-wrap-distance-bottom:0;mso-position-horizontal:left;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:line;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page' o:allowoverlap="f">
<v:imagedata src="cid:image001.png@01D871DB.B67D6F80" o:title=" Compass" />
<w:wrap type="square" anchory="line"/>
</v:shape><![endif]--><![if !vml]><img width="60" height="113" style="width:.625in;height:1.177in" src="cid:image002.png@01D871DC.29EF92E0" align="left" alt="Title: SBCTC logo - Description: Compass" v:shapes="Picture_x0020_2"><![endif]><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"><o:p></o:p></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"><o:p></o:p></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"><o:p></o:p></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"><o:p></o:p></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"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="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> <o:p>
</o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="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><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864"> </span><o:p></o:p></p>
<p class="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><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864"> </span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864">Cheers, Karen</span><o:p></o:p></p>
<p class="xmsonormal"><span style="font-size:14.0pt;font-family:"Cambria",serif;color:#1F3864"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="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!<o:p></o:p></p>
</div>
</div>
<p class="xmsonormal"> <o:p></o:p></p>
<div>
<p class="xmsonormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black">ATHEN colleagues,</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black">I need your help!</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:12.0pt;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="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><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:12.0pt;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="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><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:12.0pt;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:12.0pt;color:black">From professor:</span><o:p></o:p></p>
</div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:12.0pt;color:black"> </span><o:p></o:p></p>
</div>
<div>
<p class="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><o:p></o:p></p>
</div>
<div>
<div>
<p class="xmsonormal" style="background:white"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<p class="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><o:p></o:p></p>
</div>
<div>
<div>
<p class="xmsonormal"><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:black"> </span><o:p></o:p></p>
</div>
<div id="x_Signature">
<div>
<div>
<p style="background:white"><span style="color:#201F1E"> </span><o:p></o:p></p>
<div>
<p style="background:white"><!--[if gte vml 1]><v:shape id="Picture_x0020_3" o:spid="_x0000_s1026" type="#_x0000_t75" alt="Title: SBCTC logo - Description: Compass" style='position:absolute;margin-left:0;margin-top:0;width:45pt;height:84.75pt;z-index:251659264;visibility:visible;mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;mso-wrap-distance-left:0;mso-wrap-distance-top:0;mso-wrap-distance-right:0;mso-wrap-distance-bottom:0;mso-position-horizontal:left;mso-position-horizontal-relative:text;mso-position-vertical:absolute;mso-position-vertical-relative:line;mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;mso-height-relative:page' o:allowoverlap="f">
<v:imagedata src="cid:image003.png@01D871DB.B67D6F80" o:title=" Compass" />
<w:wrap type="square" anchory="line"/>
</v:shape><![endif]--><![if !vml]><img width="60" height="113" style="width:.625in;height:1.177in" src="cid:image003.png@01D871DB.B67D6F80" align="left" alt="Title: SBCTC logo - Description: Compass" v:shapes="Picture_x0020_3"><![endif]><b><span style="font-size:14.0pt;font-family:"Franklin Gothic Book",sans-serif;color:#002060">Monica
M. Olsson (she/her/hers)</span></b><o:p></o:p></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><o:p></o:p></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><o:p></o:p></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><o:p></o:p></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><o:p></o:p></p>
</div>
<p class="xmsonormal"><span style="font-size:12.0pt;color:black"> </span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>