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..
