well I was asking amio if he had a sample file to work on
On 11/14/13, Ajay Minocha <[email protected]> wrote: > Hello syde, > Please share with me as well. > regards > > On 11/14/13, Mukesh <[email protected]> wrote: >> Hello Syed, >> >> I'm also interested in pivot table. Please share a sample file for my >> better >> >> understanding on my personal email id or upload it on send space for all >> those who are interested in it. >> >> Thank you. >> >> Regards >> >> Mukesh Baviskar >> Mobile: 9403161157 >> >> >> -------------------------------------------------- >> From: "syed imran" <[email protected]> >> Sent: Thursday, November 14, 2013 6:43 AM >> To: "AccessIndia: a list for discussing accessibility and issues >> concerningthe disabled." <[email protected]> >> Subject: Re: [AI] About Pivot Table in Excel 2007. >> >>> Yes it is accessible (without a sample excel file it's hard to >>> explain, but I'll try). >>> For example There's a worksheet that contains a detailed study of your >>> client base such as their demographics, their income level, product >>> preference, buying pattern etc and let's say this whole data runs over >>> some 4000 rows, but you're only interested in finding out just the >>> average income level of your clients by region. >>> This is one of the reasons why you may want to use the pivot table >>> feature. >>> To creat a pivot table: >>> 1. go to the top left cornor of the data (for example, A1) >>> 2. go to insert > pivot table or pivot chart > pivot table (Alt n, v, >>> enter) >>> 3. confirm the selection (something like $A$1:$S$4000) and press enter >>> 4. By default the pivot table gets created in a new worksheet and the >>> cursor lands in A3. Press F6 to move to the field list box where you >>> can select what needs to be put in rows, what needs to be put in >>> columns, and what needs to go as value. >>> for example, select "region" as row then "income Level" as value. >>> 5. Press shift f6 to go back to the newly designed pivot table, then >>> verify that the values in the table are summarised correctly ( sum / >>> count / average) >>> 6. if you wish to summarise the value in a different manner, then go >>> to the first cell of the value and then activate the context menu and >>> then select the appropriate option in the "summarise by" details menu. >>> >>> hth >>> >>> Syed >>> P.S. the following link might also be of some help : >>> http://mail.accessindia.org.in/pipermail/accessindia_accessindia.org.in/2012-February/060311.html >>> >>> >>> On 11/13/13, Amiyo Biswas <[email protected]> wrote: >>>> Hello, >>>> >>>> I have to learn pivot table in excel 2007 myself for a friend who has >>>> to >>>> >>>> use >>>> it in her office. Please illustrate the whole thing with examples etc. >>>> Is >>>> >>>> it >>>> accessible? >>>> >>>> With best regards, >>>> Amiyo Biswas >>>> Cell: +91-9433464329 >>>> Register at the dedicated AccessIndia list for discussing accessibility >>>> of >>>> mobile phones / Tabs on: >>>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>>> >>>> >>>> Search for old postings at: >>>> http://www.mail-archive.com/[email protected]/ >>>> >>>> To unsubscribe send a message to >>>> [email protected] >>>> 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.. >>>> >>> >>> >>> -- >>> >>> >>> >>> >>> >>> >>> >>> -.-.-.-Faint heart never won fair lady_._._._._ >>> >>> Register at the dedicated AccessIndia list for discussing accessibility >>> of >>> >>> mobile phones / Tabs on: >>> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/[email protected]/ >>> >>> To unsubscribe send a message to >>> [email protected] >>> 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.. >> >> >> Register at the dedicated AccessIndia list for discussing accessibility >> of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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.. >> > > > -- > Ajay Minocha > Mob : +91-9584076767 > E mail : [email protected] > [email protected] > Skype: ajayminocha2 > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > 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.. > -- -.-.-.-Faint heart never won fair lady_._._._._ Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] 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..
