E-mail List Archives

Thread: excel best practices

for

Number of posts in this thread: 3 (In chronological order)

From: Sarah Ferguson
Date: Fri, Jan 11 2019 9:05AM
Subject: excel best practices
No previous message | Next message →

I've been asked to create an excel sheet that can be used like a form. I've
never really had to make accessible excel sheets before. High-contrast need
is a given. I applied table style to the two sections of the sheet that are
meant to be filled, but not the parts with the sheet title or the
directions for filling the form. I used the locked and hidden features so
you can tab to all cells with text or cells meant to be filled out, but not
to surrounding blank cells. I only used merging in the cells with
directions, not in any of the "table" cells. Is this how I should be
treating this document? Anything I should keep in mind as best practices or
things I am doing that will actually make it harder to use?

Thanks

Sarah Ferguson
Web Accessibility Specialist

From: R.U. Steinberg
Date: Fri, Jan 11 2019 9:25AM
Subject: Re: excel best practices
← Previous message | Next message →

There is a tutorial for Excel forms by State of Texas
https://gov.texas.gov/organization/disabilities/accessibledocs2013-16

How to Make Accessible Excel Forms, Part 1

[image: YouTube Video: How to Make Accessible Excel Forms, Part 1]
<http://www.youtube.com/watch?v=71EuSZwCtVE&;feature=plcp>This is the first
of a two-part set of Excel forms modules. This module covers the basics
for creating accessible Excel forms, as well as a brief review of Excel
accessibility best practices.



- Watch YouTube Video: How to Make Accessible Excel Forms, Part 1
<http://www.youtube.com/watch?v=71EuSZwCtVE&;feature=plcp>
- Download Audio MP3 File: How to Make Accessible Excel Forms, Part 1
<https://gov.texas.gov/uploads/files/organization/disabilities/16_ExcelForms_01.mp3>
- Download Instructional Word Document: How to Make Accessible Excel
Forms, Part 1
<https://gov.texas.gov/uploads/files/organization/disabilities/16_ExcelForms_01.docx>
- Download Instructional Adobe PDF: How to Make Accessible Excel Forms,
Part 1
<https://gov.texas.gov/uploads/files/organization/disabilities/16_ExcelForms_01.pdf>


How to Make Accessible Excel Forms, Part 2

[image: YouTube Video: How to Make Accessible Forms, Part 2]
<http://www.youtube.com/watch?v=VMQPeUqB258&;feature=plcp>This is the second
of a two-part set of Excel forms modules. This module gives more advanced
instructions on controlling the type of data being entered, and also
locking and protecting your form.


- Watch YouTube Video: How to Make Accessible Excel Forms, Part 2
<http://www.youtube.com/watch?v=VMQPeUqB258&;feature=plcp>
- Download Audio MP3 File: How to Make Accessible Excel Forms, Part 2
<https://gov.texas.gov/uploads/files/organization/disabilities/17_ExcelForms_02.mp3>
- Download Instructional Word Document: How to Make Accessible Excel
Forms, Part 2
<https://gov.texas.gov/uploads/files/organization/disabilities/17_ExcelForms_02.docx>
- Download Instructional Adobe PDF: How to Make Accessible Excel Forms,
Part 2
<https://gov.texas.gov/uploads/files/organization/disabilities/17_ExcelForms_02.pdf>



On Fri, Jan 11, 2019 at 10:05 AM Sarah Ferguson < = EMAIL ADDRESS REMOVED = > wrote:

> I've been asked to create an excel sheet that can be used like a form. I've
> never really had to make accessible excel sheets before. High-contrast need
> is a given. I applied table style to the two sections of the sheet that are
> meant to be filled, but not the parts with the sheet title or the
> directions for filling the form. I used the locked and hidden features so
> you can tab to all cells with text or cells meant to be filled out, but not
> to surrounding blank cells. I only used merging in the cells with
> directions, not in any of the "table" cells. Is this how I should be
> treating this document? Anything I should keep in mind as best practices or
> things I am doing that will actually make it harder to use?
>
> Thanks
>
> Sarah Ferguson
> Web Accessibility Specialist
> > > > >

From: Sarah Ferguson
Date: Fri, Jan 11 2019 2:03PM
Subject: Re: excel best practices
← Previous message | No next message

thanks!

Sarah Ferguson
Web Accessibility Specialist
Office of Digital Communications
Brandeis University *|* 781.736.4259

*Web Accessibility Help Desk < = EMAIL ADDRESS REMOVED = >*
*Web Accessibility at Brandeis <http://www.brandeis.edu/web-accessibility>;*
*Sign up for Training
<https://www.brandeis.edu/web-accessibility/training/index.html> | **Email
to set up a 1-on-1*




On Fri, Jan 11, 2019 at 11:26 AM R.U. Steinberg < = EMAIL ADDRESS REMOVED = >
wrote:

> There is a tutorial for Excel forms by State of Texas
> https://gov.texas.gov/organization/disabilities/accessibledocs2013-16
>
> How to Make Accessible Excel Forms, Part 1
>
> [image: YouTube Video: How to Make Accessible Excel Forms, Part 1]
> <http://www.youtube.com/watch?v=71EuSZwCtVE&;feature=plcp>This is the first
> of a two-part set of Excel forms modules. This module covers the basics
> for creating accessible Excel forms, as well as a brief review of Excel
> accessibility best practices.
>
>
>
> - Watch YouTube Video: How to Make Accessible Excel Forms, Part 1
> <http://www.youtube.com/watch?v=71EuSZwCtVE&;feature=plcp>
> - Download Audio MP3 File: How to Make Accessible Excel Forms, Part 1
> <
> https://gov.texas.gov/uploads/files/organization/disabilities/16_ExcelForms_01.mp3
> >
> - Download Instructional Word Document: How to Make Accessible Excel
> Forms, Part 1
> <
> https://gov.texas.gov/uploads/files/organization/disabilities/16_ExcelForms_01.docx
> >
> - Download Instructional Adobe PDF: How to Make Accessible Excel Forms,
> Part 1
> <
> https://gov.texas.gov/uploads/files/organization/disabilities/16_ExcelForms_01.pdf
> >
>
>
> How to Make Accessible Excel Forms, Part 2
>
> [image: YouTube Video: How to Make Accessible Forms, Part 2]
> <http://www.youtube.com/watch?v=VMQPeUqB258&;feature=plcp>This is the
> second
> of a two-part set of Excel forms modules. This module gives more advanced
> instructions on controlling the type of data being entered, and also
> locking and protecting your form.
>
>
> - Watch YouTube Video: How to Make Accessible Excel Forms, Part 2
> <http://www.youtube.com/watch?v=VMQPeUqB258&;feature=plcp>
> - Download Audio MP3 File: How to Make Accessible Excel Forms, Part 2
> <
> https://gov.texas.gov/uploads/files/organization/disabilities/17_ExcelForms_02.mp3
> >
> - Download Instructional Word Document: How to Make Accessible Excel
> Forms, Part 2
> <
> https://gov.texas.gov/uploads/files/organization/disabilities/17_ExcelForms_02.docx
> >
> - Download Instructional Adobe PDF: How to Make Accessible Excel Forms,
> Part 2
> <
> https://gov.texas.gov/uploads/files/organization/disabilities/17_ExcelForms_02.pdf
> >
>
>
>
> On Fri, Jan 11, 2019 at 10:05 AM Sarah Ferguson < = EMAIL ADDRESS REMOVED = >
> wrote:
>
> > I've been asked to create an excel sheet that can be used like a form.
> I've
> > never really had to make accessible excel sheets before. High-contrast
> need
> > is a given. I applied table style to the two sections of the sheet that
> are
> > meant to be filled, but not the parts with the sheet title or the
> > directions for filling the form. I used the locked and hidden features so
> > you can tab to all cells with text or cells meant to be filled out, but
> not
> > to surrounding blank cells. I only used merging in the cells with
> > directions, not in any of the "table" cells. Is this how I should be
> > treating this document? Anything I should keep in mind as best practices
> or
> > things I am doing that will actually make it harder to use?
> >
> > Thanks
> >
> > Sarah Ferguson
> > Web Accessibility Specialist
> > > > > > > > > >
> > > > >