[AI] Help requested for Pivot Table creation

Mahesh Narasimhan maheshdel88 at gmail.com
Mon Dec 31 09:41:10 EST 2018


Hi Sudeshna,
Greetings for the day!

I am unaware about the verbosity setting of JAWS in excel. Requesting
you to guide me in this so that I can check.

Just note, the JAWS vertual setting must be turned off because in my
system I have kept it off.

In the normal case, as Office package and JAWS are installed in the
system, I have worked with Excel 2007, 2010 and 2013 and I did not
face any issue with pivot or any other excel tools that I use as yet.

All the best and do well

-- 
"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/31/18, Sudeshna Bhattacharya <sudeshna.bhattacharya34 at gmail.com> wrote:
> Good Morning Mahesh Sir,
> What I wanted to let you know is that I had already tried the method
> for creating the Pivot table, you mentioned above. But when in the new
> worksheet, I am pressing the "F6"key to choose the fields, JAWS is
> saying "pivot table field list, press up or down arrow to choose the
> fields ..... ".
> Here pressing up or down arrow doesn't make JAWS  say anything. so,
> here I get stuck. Please guide me how to proceed from this step. do I
> need to change any verbosity setting of JAWS in excel 2010?
>
> awaiting your kind reply Sir,
>
> Thanks and regards,
> Sudeshna Bhattacharya
>
> On 12/28/18, Mahesh Narasimhan <maheshdel88 at gmail.com> wrote:
>> Hello Aravind and Sudeshna,
>> Good evening !
>>
>> I read your queries. Explanations are furnished below.
>>
>> Aravind: Do you want to apply filter on the complete data that you
>> have? If your answer is yes, then "pivot" is not the tool you must be
>> using, I feel. In place of pivot, you must either use the "Conditional
>> Formatting" tool or the "Filter" tool. If your answer is no, then you
>> must copy and paste special the pivot table in a new worksheet and
>> apply filter.
>>
>> Sudeshna: I am extremely sorry, I did not get your query. Please be
>> more elaborative. Kindly rephrase your query.
>>
>> --
>> "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/28/18, Sudeshna Bhattacharya <sudeshna.bhattacharya34 at gmail.com>
>> wrote:
>>> 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..
>>>>
>>>
>>>
>>>
>>>
>>> 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..
>>
>
>
>
>
> 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