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: maheshde...@gmail.com On 12/31/18, Sudeshna Bhattacharya <sudeshna.bhattachary...@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 <maheshde...@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: maheshde...@gmail.com >> >> >> >> >> On 12/28/18, Sudeshna Bhattacharya <sudeshna.bhattachary...@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.andhrab...@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 <maheshde...@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: maheshde...@gmail.com >>>>> >>>>> >>>>> On 12/27/18, Sudeshna Bhattacharya <sudeshna.bhattachary...@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-requ...@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-requ...@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_...@yahoo.com, aravind.andhrab...@gmail.com. >>>> aravind.rajend...@bankofbaroda.co.in. >>>> >>>> >>>> >>>> >>>> Search for old postings at: >>>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>>> >>>> To unsubscribe send a message to >>>> accessindia-requ...@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-requ...@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-requ...@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-requ...@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-requ...@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..