Topics

moderated Excel and JAWS Question


Van Lant, Robin
 

This may be a case for using AIRA or asking the person who sent the file for a basic overview.  For example, my manager’s main file she uses for tracking each year’s group of interns has a list of all interns and multiple columns of data across the bottom, but the top of the worksheet has small tables where she is calculating various things like metrics on of hires by gender and school.  It took me a while to navigate around and try to determine each section of information.

 

Also note  I have found certain JAWS commands do not work if freeze panes is turned on.  Many sighted users use this feature to keep the left column visible as they navigate through the various columns to the right.  Similarly, they might turn this on to keep column headers visible.  JAWS wasn’t able to show me all cell comments while freze panes was on.  There must be a technical reason for this, as JAWS actually told me to unfreeze panes to make it work.  I need to email Vispero and ask why this is. 

 

Robin

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Greg Daniel
Sent: Friday, September 18, 2020 11:29 AM
To: main@jfw.groups.io
Subject: Re: Excel and JAWS Question

 

Mike,

 

Spreadsheets can be written in formats from the sublime to the ridiculous.  As a totally blind user, I try to write down the headings and so get an idea of the organization of the spreadsheet.  However, since your co-worker is looking at a full screen and you are accessing the spreadsheet cell by cell, what you can learn depends entirely on the complexity of the spreadsheet itself.  No matter how you choose to learn about the functions of the spreadsheet, it’s going to take you longer than it would take a sighted person.  For complicated financial spreadsheets, even looking at the screen can be a daunting experience.

 

Greg

 

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Walker, Michael E
Sent: Friday, September 18, 2020 12:42 PM
To: jfw@groups.io
Subject: Excel and JAWS Question

 

Hi,

 

What is the fastest way to get familiar with a large spreadsheet for the first time using JAWS, if you have no idea what is in it? My co-worker told me that as soon as she opens a spreadsheet, she can immediately see everything she needs to know on screen. I am trying to learn if there is a way to use a computer as fast as someone who can see in every situation. I am totally blind.

 

Thanks,

Mike

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. No confidentiality or privilege is waived or lost as a result of any transmission errors. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you have received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy.

This communication is for informational purposes only, is not an offer, solicitation, recommendation or commitment for any transaction or to buy or sell any security or other financial product, and is not intended as investment advice or as a confirmation of any transaction. Any market price, indicative value, estimate, view, opinion, data or other information herein is not warranted as to completeness or accuracy, is subject to change without notice, and KeyBanc Capital Markets Inc. accepts no liability for its use or to update or keep it current. Any views or opinions are those of the individual sender, not necessarily of KeyBanc Capital Markets Inc.

The sender of this communication is a licensed securities representative employed by or associated with KeyBanc Capital Markets Inc. Member FINRA/SIPC and may also represent KeyBank National Association (“KeyBank N.A.”). Securities products and services are offered by KeyBanc Capital Markets Inc. Banking products and services are offered by KeyBank N.A.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key send an e-mail to DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.


NFB Lab 4
 

Try moving down column A. Then using insert up arrow to read each line. Some of the smaller spreadsheets make it easier to understand that way.


On Sep 19, 2020, at 1:12 AM, Bob Kennedy <intheshop@...> wrote:



As far as being able to compete with a sighted user, the quick answer is no. You can get close if you have a fantastic memory and can remember all of the Jaws commands for reading. Don't mean to be discouraging, I'm being honest, which a lot of people don't like.
On Friday, September 18, 2020, 12:42:14 PM EDT, Walker, Michael E <michael.e.walker3@...> wrote:


Hi,

 

What is the fastest way to get familiar with a large spreadsheet for the first time using JAWS, if you have no idea what is in it? My co-worker told me that as soon as she opens a spreadsheet, she can immediately see everything she needs to know on screen. I am trying to learn if there is a way to use a computer as fast as someone who can see in every situation. I am totally blind.

 

Thanks,

Mike


Bob Kennedy
 


As far as being able to compete with a sighted user, the quick answer is no. You can get close if you have a fantastic memory and can remember all of the Jaws commands for reading. Don't mean to be discouraging, I'm being honest, which a lot of people don't like.

On Friday, September 18, 2020, 12:42:14 PM EDT, Walker, Michael E <michael.e.walker3@...> wrote:


Hi,

 

What is the fastest way to get familiar with a large spreadsheet for the first time using JAWS, if you have no idea what is in it? My co-worker told me that as soon as she opens a spreadsheet, she can immediately see everything she needs to know on screen. I am trying to learn if there is a way to use a computer as fast as someone who can see in every situation. I am totally blind.

 

Thanks,

Mike


Glenn / Lenny
 

I've never appreciated sighted people thinking that tasks need to be done at the speed of light.
I find it annoying when sighted people think I need help if it takes me 10 seconds longer to find a door for example.
Likewise, what is so important about being able to see what a file is about half a minute faster than a Blind person's technique.
some sighted people speed-read, and I believe that they don't absorb the information as well as a typical reader.
And some Blind folks can read Braille or synthetic speech faster than sighted people can read print.
Glenn
 

----- Original Message -----
Sent: Friday, September 18, 2020 12:28 PM
Subject: Re: Excel and JAWS Question

Mike,

 

Spreadsheets can be written in formats from the sublime to the ridiculous.  As a totally blind user, I try to write down the headings and so get an idea of the organization of the spreadsheet.  However, since your co-worker is looking at a full screen and you are accessing the spreadsheet cell by cell, what you can learn depends entirely on the complexity of the spreadsheet itself.  No matter how you choose to learn about the functions of the spreadsheet, it’s going to take you longer than it would take a sighted person.  For complicated financial spreadsheets, even looking at the screen can be a daunting experience.

 

Greg

 

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Walker, Michael E
Sent: Friday, September 18, 2020 12:42 PM
To: jfw@groups.io
Subject: Excel and JAWS Question

 

Hi,

 

What is the fastest way to get familiar with a large spreadsheet for the first time using JAWS, if you have no idea what is in it? My co-worker told me that as soon as she opens a spreadsheet, she can immediately see everything she needs to know on screen. I am trying to learn if there is a way to use a computer as fast as someone who can see in every situation. I am totally blind.

 

Thanks,

Mike


Greg Daniel
 

Mike,

 

Spreadsheets can be written in formats from the sublime to the ridiculous.  As a totally blind user, I try to write down the headings and so get an idea of the organization of the spreadsheet.  However, since your co-worker is looking at a full screen and you are accessing the spreadsheet cell by cell, what you can learn depends entirely on the complexity of the spreadsheet itself.  No matter how you choose to learn about the functions of the spreadsheet, it’s going to take you longer than it would take a sighted person.  For complicated financial spreadsheets, even looking at the screen can be a daunting experience.

 

Greg

 

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Walker, Michael E
Sent: Friday, September 18, 2020 12:42 PM
To: jfw@groups.io
Subject: Excel and JAWS Question

 

Hi,

 

What is the fastest way to get familiar with a large spreadsheet for the first time using JAWS, if you have no idea what is in it? My co-worker told me that as soon as she opens a spreadsheet, she can immediately see everything she needs to know on screen. I am trying to learn if there is a way to use a computer as fast as someone who can see in every situation. I am totally blind.

 

Thanks,

Mike


Scott Pearl
 

Whether the below way is as fast as a sighted person, Idon’t know. There may be other ways to figure out quickly the content of a spreadsheet you’re not familiar with but the below way is how I like to do it.

Typically, I will just start pressing control with the arrow keys to start navigating regions. I’m looking for how big this spreadsheet actually is. If it only goes out for a few regions, this method will be extremely quick. But if there are dozens or hundreds of regions, then after awhile I will use the go to key to go to the edge of the spreadsheet and then control left arrow or control up arrow to get to the last populated cell. There are key combinations that JAWS has to tell you which cells are populated but they don’t help me as I think very spatially and to see what’s at the far right of a spreadsheet, it’s more difficult for me to conceptualize it when I had to press down arrow to get there.

I’ve gotten fairly quick at the above steps and I can typicaly pick up how big a large spreadsheet is in about 10-15 seconds. It’s probably not as fast as a sighted person can get that information by just looking at the screen but it works for me.

Once I’ve gotten my boundaries I begin looking at how they have it laid out. Where are column and row headers, formulas, inserted data and so on.

Again, there are other methods and keystrokes that JAWS has of getting this information but if you’re one who needs to think spatially by pressing the arrow keys with control, this method has worked for me.    

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Walker, Michael E
Sent: Friday, September 18, 2020 10:42 AM
To: jfw@groups.io
Subject: Excel and JAWS Question

 

Hi,

 

What is the fastest way to get familiar with a large spreadsheet for the first time using JAWS, if you have no idea what is in it? My co-worker told me that as soon as she opens a spreadsheet, she can immediately see everything she needs to know on screen. I am trying to learn if there is a way to use a computer as fast as someone who can see in every situation. I am totally blind.

 

Thanks,

Mike


Mark Fisher
 



Hi

When you first enter the workbook, you can use JAWS Key+F1 to provide some basic information about what is in each tab such as the amount of cells with data, size of the data ranges and any JAWS customising that has been done on the spreadsheet. You can move between the tabs and execute this command in each tab. Whilst not ideal, it gives you a starting point.

A good practice to get into and to advise others to do is to create a Notes tab at the front of the workbook to describe what's in the workbook and each tab especially if its a complicated workbook. This also helps when others are trying to follow the steps of what people have done to create the workbook. I use this to describe briefly what's in each tab and also where the data came from. It may take a few minutes longer when setting up the workbook but makes everything easier for people coming into the workbook for the first time whether they can see or not.

Mark Fisher
Principal - HR Systems
Water Corporation


Jim Fettgather
 

I would use the jaws command
Control shift D to place all the cells  with data in a list.

Sent from my jPhone

On Sep 18, 2020, at 11:42 AM, Walker, Michael E <michael.e.walker3@...> wrote:



Hi,

 

What is the fastest way to get familiar with a large spreadsheet for the first time using JAWS, if you have no idea what is in it? My co-worker told me that as soon as she opens a spreadsheet, she can immediately see everything she needs to know on screen. I am trying to learn if there is a way to use a computer as fast as someone who can see in every situation. I am totally blind.

 

Thanks,

Mike


Walker, Michael E
 

Hi,

 

What is the fastest way to get familiar with a large spreadsheet for the first time using JAWS, if you have no idea what is in it? My co-worker told me that as soon as she opens a spreadsheet, she can immediately see everything she needs to know on screen. I am trying to learn if there is a way to use a computer as fast as someone who can see in every situation. I am totally blind.

 

Thanks,

Mike