[AI] Help requested for Pivot Table creation

Sudeshna Bhattacharya sudeshna.bhattacharya34 at gmail.com
Fri Dec 28 00:47:37 EST 2018


Hello  Mahesh Sir,
A very good morning! Liked your step by step guide very much. But,
Before writing to the list, , I had tried this method, JAWS is reading
nothing but "field list ". Pressing up or down arrows or tab at this
place does not make JAWS read anything. Please guide me here Sir. I
wish  to learn the advanced features of Pivot as well.

Thanks and regards,
Sudeshna Bhattacharya while

On 12/27/18, Aravind R <aravind.andhrabank at gmail.com> wrote:
> dear sir, how to display filtered values in pivot table like days
> belonging to one month? top 10 numbers, values greater or lessor than
> a particular number?
>
> On 12/27/18, Mahesh Narasimhan <maheshdel88 at gmail.com> wrote:
>> Creation of Pivot Table
>>
>> 1.	Open the excel file having the table on which pivot has to be
>> applied. This means that the table which has to be analyzed.
>> 2.	Select the table.
>> 3.	Press the Alt key, then right arrow to reach the Insert menu. There
>> press the down arrow; the first option is Pivot. Hit enter.
>> 4.	A dialogue box would open and it would say, “Create pivot table,
>> select the table/range”. Kindly note, we have already selected the
>> table which has to be analyzed, here simply hit ‘Tab’ once and it
>> would say “New worksheet radio button checked”. Then hit ‘Tab’ till Ok
>> and hit enter.
>> 5.	A new worksheet would open and by default the curser would be in A3
>> cell. Do not worry! Press once the “Function key 6 (F6)”. Here all the
>> column heads would be placed one below the other. Then press down
>> arrow till you reach to the column head which you wish to keep as the
>> primary column (the first column). Then press the “Application key”.
>> Then down arrow and it would say “Add to row label”. There hit entre.
>> In A3 cell it would say “Row Label”.
>> 6.	Then press F6 key and by default the curser would be on the column
>> head which you would have selected. There press down arrow or up arrow
>> as per your requirement and select the column head which you wish to
>> place next and press the application key, then the down arrow to add
>> to row labels and press entre. Continue this process till you have
>> short-listed all the column heads (except the last column head) that
>> you wish to have in the table which would be analyzed.
>> 7.	Then you again press the F6 key and press the up arrow or the down
>> arrow which would be the last column of the table. Press the
>> Application key. Then press the down arrow till you reach “Add to
>> Values”. There press entre.
>> 8.	Then press the “Escape” key. Then press the “Alt” key and right or
>> left arrow till you reach “Design Tab”. There press the down arrow and
>> left arrow till you reach “Report Layout Submenu”, there hit enter.
>> There you press down arrow till you reach “In Tabular Form”, there hit
>> enter.
>> 9.	Your pivot Table is ready.
>>
>> You try this first and there are more things to take care in pivot
>> table which I shall share in the next session.
>>
>> Enjoy learning!
>>
>> Thank you.
>>
>>
>> --
>> "Good friendship is like the relationship between  eye & hand! If the
>> hand is hurt, the eye will cry! & when the eye cries, the hand will
>> wipe the tears"
>>
>> With best regards,
>> Mahesh Narasimhan
>> Mobile: +91-9899353960
>> E-mail: maheshdel88 at gmail.com
>>
>>
>> On 12/27/18, Sudeshna Bhattacharya <sudeshna.bhattacharya34 at gmail.com>
>> wrote:
>>> Hello Friends,
>>> Can you please suggest me a detailed tutorial for creating and dealing
>>> with a Pivot Table  in Excel 2010? I'm using JAWS 18.
>>>
>>> Thanks and regards,
>>> Syudeshna Bhattacharya.
>>>
>>>
>>>
>>>
>>> Search for old postings at:
>>> http://www.mail-archive.com/accessindia@accessindia.org.in/
>>>
>>> To unsubscribe send a message to
>>> accessindia-request at accessindia.org.in
>>> with the subject unsubscribe.
>>>
>>> To change your subscription to digest mode or make any other changes,
>>> please
>>> visit the list home page at
>>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>>
>>>
>>> Disclaimer:
>>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of
>>> the
>>> person sending the mail and AI in no way relates itself to its veracity;
>>>
>>> 2. AI cannot be held liable for any commission/omission based on the
>>> mails
>>> sent through this mailing list..
>>>
>>
>>
>>
>>
>> Search for old postings at:
>> http://www.mail-archive.com/accessindia@accessindia.org.in/
>>
>> To unsubscribe send a message to
>> accessindia-request at accessindia.org.in
>> with the subject unsubscribe.
>>
>> To change your subscription to digest mode or make any other changes,
>> please
>> visit the list home page at
>> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>>
>>
>> Disclaimer:
>> 1. Contents of the mails, factual, or otherwise, reflect the thinking of
>> the
>> person sending the mail and AI in no way relates itself to its veracity;
>>
>> 2. AI cannot be held liable for any commission/omission based on the mails
>> sent through this mailing list..
>>
>
>
> --
> --
> nothing is difficult unless you make it appear so.
>
> r. aravind,
>
> Assistant manager
> Department of sales
> bank of baroda specialised mortgage store, Chennai.
> mobile no: +91 9940369593,
> email id : aravind_069 at yahoo.com, aravind.andhrabank at gmail.com.
> aravind.rajendran at bankofbaroda.co.in.
>
>
>
>
> Search for old postings at:
> http://www.mail-archive.com/accessindia@accessindia.org.in/
>
> To unsubscribe send a message to
> accessindia-request at accessindia.org.in
> with the subject unsubscribe.
>
> To change your subscription to digest mode or make any other changes, please
> visit the list home page at
> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
>
>
> Disclaimer:
> 1. Contents of the mails, factual, or otherwise, reflect the thinking of the
> person sending the mail and AI in no way relates itself to its veracity;
>
> 2. AI cannot be held liable for any commission/omission based on the mails
> sent through this mailing list..
>



More information about the AccessIndia mailing list