[mso] Re: Excel - pivot tables

  • From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Sun, 19 Feb 2006 11:52:45 -0500

Hi Jenny.  Pivot Tables do just what the name says ... They let you  


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


*************************************************************
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: