N
nun
Are there any pseudo table or something I can d/l and use to play with and
learn about pivot tables?
learn about pivot tables?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
J.E. McGimpsey
Debra Dalgleish has one at:
http://www.contextures.com/excelfiles.html#Pivot
She has a tutorial with another sample file at
http://www.contextures.com/xlPivot01.html
and you might also benefit from Debra's introduction and Jon
Peltier's pivot table links at Jon's:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm
http://www.contextures.com/excelfiles.html#Pivot
She has a tutorial with another sample file at
http://www.contextures.com/xlPivot01.html
and you might also benefit from Debra's introduction and Jon
Peltier's pivot table links at Jon's:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm
J
Jon Peltier
The best way to learn about pivot tables, after looking at a few
examples, is to construct a simplified version of your own data, and
just play around for an hour. Maybe less. You will soon see how
flexible and powerful these tools can be. (My boss has given up on
charting, but wants me to teach him pivot tables!)
- Jon
examples, is to construct a simplified version of your own data, and
just play around for an hour. Maybe less. You will soon see how
flexible and powerful these tools can be. (My boss has given up on
charting, but wants me to teach him pivot tables!)
- Jon
K
KLassman
I am what I would call a "medium" Excel user - and my first introduction
to pivot tables was about 4 months ago.
At first I was terrified . . . the database I was using was about 50
columns wide and I soon learned (from the expert who set it up) that
data in each column had to be of the same "type" -- either text or
number. He finally set up test columns between each data column in
which I could check for the "type" to verify each entry was the correct
type for that column. The formula for that is =type(column letter
row #) e.g. =type(a3)
Another trick I learned was to use the filters for each column to be
sure each entry which was intended to be the same was, in fact the
same. Johns Company and John's Company will not be read as the
same in a pivot table.
Finally I was brave enough to try to create my own Pivot Tables and was
very surprised at how easy they are. As long as I was consistent
with the "type" in each column and consistent with the entries in the
text fields the pivot table works great.
I highly recommend any Excel user to give them a try. Very powerful
and actually quite fun.
to pivot tables was about 4 months ago.
At first I was terrified . . . the database I was using was about 50
columns wide and I soon learned (from the expert who set it up) that
data in each column had to be of the same "type" -- either text or
number. He finally set up test columns between each data column in
which I could check for the "type" to verify each entry was the correct
type for that column. The formula for that is =type(column letter
row #) e.g. =type(a3)
Another trick I learned was to use the filters for each column to be
sure each entry which was intended to be the same was, in fact the
same. Johns Company and John's Company will not be read as the
same in a pivot table.
Finally I was brave enough to try to create my own Pivot Tables and was
very surprised at how easy they are. As long as I was consistent
with the "type" in each column and consistent with the entries in the
text fields the pivot table works great.
I highly recommend any Excel user to give them a try. Very powerful
and actually quite fun.