View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rene Rene is offline
external usenet poster
 
Posts: 74
Default How Do I Take Pivot Tables to the Next Level?

Where can I get intermediate and advanced tips and instruction on the
possible variations of field arrangements in all 4 areas of a pivot table
report and what they'll yield? I recently used the same field in both the Row
Fields and in Data Items areas for the first time, in order to get a count of
each unique item, and it saved everyone a lot of time and they loved it. I
want to convert more lay people to the wonderful world of Pivot Tables.
Also, what types of files can I acctualy import into Excel for analysis via
PT reports? Any tips on importing external data like that?
--
Rene - Do appreciate your help