Hello Syed,
I could not try your tips before. I tried it just now on a small sheet of 60
rows and it is working. However, since this contains data on some expenses
of the account, I can't share it perhaps. Anyway, I shall try it on another
sheet with large scale data and try various options. In fact, I have to
learn the tricks for a friend of mine.
With best regards,
Amiyo Biswas
Cell: +91-9433464329
--------------------------------------------------
From: "syed imran" <[email protected]>
Sent: Thursday, November 14, 2013 7:58 PM
To: "AccessIndia: a list for discussing accessibility and issues
concerningthe disabled." <[email protected]>
Subject: Re: [AI] About Pivot Table in Excel 2007.
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..
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..
