Description
Many Excel experts believe that pivot tables are
the single most powerful tool in Excel. According
to Bill Jelen (a.k.a. Mr. Excel) "No other tool in
Excel gives you the flexibility and analytical
power of a pivot table". I agree completely.
Excel Pivot Tables are fun and powerful. So, in
no particular order, here are some things you
should know about them.
1.You can build a pivot table in about one
minute
2.Perfect your source data
3.Count the data first
4.. Plan before you build
5.Use a table for your data to create a "dynamic range“
6. Use a pivot table to count things
7.Show totals as a percentage
8.Use a pivot table to build a list of unique
values
9.. Create a self-contained pivot table etc