[gui-talk] Pivot tables in Excel

[Jude DaShiell]

Here's a little info that may be useful in this context.  Earlier pivot 
tables were fully inaccessible in Microsoft excel.  However what are 
called pivot tables in Microsoft Excel have a different name in 
Microsoft Access and in msaccess they're called crosstabs.  The 
crosstabs were accessible in msaccess as far back as msaccess 97.  
Whether msaccess now is accessible enough to get you to the crosstabs, 
that's another question.  I had an instructor who taught several 
microsoft courses and two I studied with him were Beginning Microsoft 
Excel and Begining Microsoft access.  He described pivot tables one way 
and then in the Microsoft access course, he described crosstabs in the 
same way.  Had I not had the beginning microsoft excel class earlier and 
been paying attention in the Microsoft access class I would not have 
discovered that or questioned him about that.  So he checked Microsoft 
access out with the same material he used in Microsoft excel for his 
pivot table example and got the same desired results in Microsoft access 
using pivot tables and I was able to do that using I think jaws this 
would have been 2.0 or 3.0 for windows.

On Sun, 16 Feb 2014, Ted Shelly wrote:

> Thanks.  F6 is the magic key.  I was then able to tab and arrow through the
> options and get what I needed.
> 
> Ted
> 
> -----Original Message-----
> From: gui-talk [mailto:gui-talk-bounces at nfbnet.org] On Behalf Of Steve
> Jacobson
> Sent: Saturday, February 15, 2014 9:54 PM
> To: Discussion of the Graphical User Interface, GUI Talk Mailing List
> Subject: Re: [gui-talk] Pivot tables in Excel
> 
> If you are using Excel 2007 or greater, go to the sheet where you have
> specified the pivot table to be created, and then press F6 and you will get
> into the fields list.  You can then use the Applications key to access menus
> that let you manipulate these fields.  I am new at this myself so am still
> learning, but I believe you have to have Excel 2007 or later to use this.
> I'm not sure it was there in Excel 2003.
> 
> Best regards,
> 
> Steve Jacobson
> 
> On Sat, 15 Feb 2014 14:12:20 -0800, Ted Shelly wrote:
> 
> >Hi all,
> 
> > 
> 
> >Does anyone know of a way to create pivot tables in Excel with just 
> >keyboard commands?  I tried researching this on Google but could not find
> an answer.
> >In case you don't know what a pivot table is, it is a way to summarize 
> >rows of data.  I want to use it to total up various categories of 
> >tax-deductable items that I have listed in a spreadsheet.  I am using 
> >Excel 2013, but probably earlier versions work similarly.
> 
> > 
> 
> >Thanks,
> 
> > 
> 
> >Ted Shelly
> 
> >_______________________________________________
> >gui-talk mailing list
> >gui-talk at nfbnet.org
> >http://nfbnet.org/mailman/listinfo/gui-talk_nfbnet.org
> >To unsubscribe, change your list options or get your account info for
> gui-talk:
> >http://nfbnet.org/mailman/options/gui-talk_nfbnet.org/steve.jacobson%40
> >visi.com
> 
> 
> 
> 
> 
> _______________________________________________
> gui-talk mailing list
> gui-talk at nfbnet.org
> http://nfbnet.org/mailman/listinfo/gui-talk_nfbnet.org
> To unsubscribe, change your list options or get your account info for
> gui-talk:
> http://nfbnet.org/mailman/options/gui-talk_nfbnet.org/tshelly2000%40gmail.co
> m
> 
> 
> _______________________________________________
> gui-talk mailing list
> gui-talk at nfbnet.org
> http://nfbnet.org/mailman/listinfo/gui-talk_nfbnet.org
> To unsubscribe, change your list options or get your account info for gui-talk:
> http://nfbnet.org/mailman/options/gui-talk_nfbnet.org/jdashiel%40shellworld.net
> 
> 

jude <jdashiel at shellworld.net>