[gui-talk] Pivot tables in Excel

[Steve Jacobson]

I mostly find Excel easier to use than Microsoft Access, although for some things Access does work better.  It is just a much more complicated interface to 
learn.  Particularly if one knows SQL, Access offers a lot of power.

Best regards,

Steve Jacobson


On Sat, 22 Feb 2014 22:53:40 -0500 (EST), Jude DaShiell wrote:

>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>


>_______________________________________________
>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%40visi.com