Sure Sir. When should I call you in that case? Thanks and regards, Sudeshna Bhattacharya
On 1/1/19, Mahesh Narasimhan <maheshde...@gmail.com> wrote: > 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.. > 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..