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
|