On 1/1/19, Sudeshna Bhattacharya <sudeshna.bhattachary...@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 <maheshde...@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: 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.. >> > > > > > 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.. > 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: maheshde...@gmail.com 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..