[AI] Help requested for Pivot Table creation

Sudeshna Bhattacharya sudeshna.bhattacharya34 at gmail.com
Thu Jan 3 00:16:16 EST 2019


I think, that will be fine for me too.

Thanks and regards,
Sudeshna Bhattacharya

On 1/2/19, Mahesh Narasimhan <maheshdel88 at gmail.com> wrote:
> Hi Sudeshna,
> Greetings!
>
> If possible, can we do it on 5th January at 11:00 in the morning?
>
> --
> "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 1/2/19, Sudeshna Bhattacharya <sudeshna.bhattacharya34 at gmail.com> wrote:
>> Sure Sir.  When should I call you in that case?
>>
>> Thanks and regards,
>> Sudeshna Bhattacharya
>>
>> On 1/1/19, Mahesh Narasimhan <maheshdel88 at gmail.com> wrote:
>>> On 1/1/19, Sudeshna Bhattacharya <sudeshna.bhattacharya34 at gmail.com>
>>> wrote:
>>>> Hello Mahesh Sir,
>>>> First of all wish you a very happy new and prosperous new year.
>>>> Actually Iin my pc so far, I happened to work with Excel 2003 and
>>>> 2007.  I did not face any such difficulty with JAWS. moreover I did
>>>> not have to change any kind of the default settings for JAWS. Of late
>>>> when I started Office 2010, I found a number of things which I cannot
>>>> do with the earlier methods that I used in earlier versions. a few
>>>> settings (I can't mention accurately) I needed to change in JAWS
>>>> verbosity setting.(using insert + V option). JAWS  18 is also a bit
>>>> new for me. would you please guide me about switching on /off of
>>>> virtual cursor and its functionality in application like excel etc?
>>>>
>>>> Eagerly awaiting your kind response,
>>>>
>>>> Thanks and regards,
>>>> Sudeshna Bhattacharya
>>>>
>>>> On 12/31/18, Mahesh Narasimhan <maheshdel88 at gmail.com> wrote:
>>>>> 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..
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> 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..
>>>>
>>> Hi Sudeshna,
>>>
>>> Thanks for the new year wishes. I wish you the very same.
>>>
>>> Cool! I wish to give it a try, if you allow. Can we talk over a call
>>> and try to solve it? Through E-mails we are unable to address the
>>> issue. Just note, I shall be available on weekends; week days I am
>>> extremely busy. If JAWS and excel are in place, to understand pivot
>>> will not take more than 45 minutes, I think. It is a very handy tool
>>> to use.
>>>
>>> --
>>> "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
>>>
>>>
>>>
>>>
>>> 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