Hello, Here is an article on pivot tables using a screen reader. Hope this will be of help to you.
Yes it is accessible (without a sample excel file it's hard to explain, but I'll try). For example There's a worksheet that contains a detailed study of your client base such as their demographics, their income level, product preference, buying pattern etc and let's say this whole data runs over some 4000 rows, but you're only interested in finding out just the average income level of your clients by region. This is one of the reasons why you may want to use the pivot table feature. To creat a pivot table: 1.go to the top left cornor of the data (for example, A1) 2.Go to insert pivot table or pivot chart pivot table (Alt n, v, enter) 3.confirm the selection (something like $A$1:$S$4000) and press enter 4.By default the pivot table gets created in a new worksheet and the cursor lands in A3. Press F6 to move to the field list box where you can select what needs to be put in rows, what needs to be put in columns, and what needs to go as value. for example, select "region" as row then "income Level" as value. 5.Press shift f6 to go back to the newly designed pivot table, then verify that the values in the table are summarised correctly ( sum / count / average) 6.if you wish to summarise the value in a different manner, then go to the first cell of the value and then activate the context menu and then select the appropriate option in the "summarish -----Original Message----- From: Jfw [mailto:[email protected]] On Behalf Of Greg Nickel via Jfw Sent: Monday, December 08, 2014 8:15 PM To: [email protected] Subject: Pivot tables. Does anyone have experience with pivot tables in excel? I haven't been able to find any resources for implementation with navigation with jaws. Any guidance would be greatly appreciated. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/201412 08/ac5540c6/attachment.html> _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com _______________________________________________ Jfw mailing list [email protected] http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com
