[mso] Re: Excel - pivot tables
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 19 Feb 2006 11:58:34 -0500
Sorry about the first reply...I'm on my laptop and always hit the wrong
keys...
Anyway, pivot tables let you "pivot" stuff....move data to from rows to
columns, etc. .... And allow you to change the display of stuff in different
arrays. Like if you had a bunch of stores with total sales for a bunch of
different products for a bunch of different years, you could quickly "pivot"
the display to show how many stores sold a certain product in a certain
year, or how many products were sold by each store in each year, or how many
years did a particular store sell a product, or what was the total sales for
each year for each product....and on and on and on. When you put stuff in a
pivot table, the possibilities are endless.
I'm sure if you search google for pivot table you will find lots of
different free tutorials, then all you need to do is play around with the
wizard until you get the feel for it.
I'm a big fan of pivot tables.
Linda F. Johnson
Linda's Computer Stop
http://personal-computer-tutor.com
All outgoing mail checked by Norton AV. If you received a "bug" that looked
like it came from me, it did NOT!
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Jenny Johnson
Sent: Sunday, February 19, 2006 11:08 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Excel - pivot tables
I have used Excel to create templates for others to use. There are several
sheets involved and values from one sheet feed into other sheets
automatically. The sheets have many formulas including several layers of
If, Countif, Vlookup, etc.
I was learning while creating some of these and when I have to make edits, I
have to be very careful to make changes in all of the right places. Someone
asked me if I had considered using a pivot table for this work.
I don't know anything about pivot tables and when it is appropriate to use
them. Does anyone have a quick description or is there an article that you
could recommend to help me decide if that is what I should be using?
Thank you,
Jenny
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
