LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 08:05 PM
user level security-stop export of tables salmonella Excel Discussion (Misc queries) 1 December 20th 06 09:37 PM
Pivot Table - report product that have sales above defined level richard Excel Discussion (Misc queries) 0 December 9th 05 02:02 PM
Using Pivot Charts, how to hide field values in second level filters? elrao Excel Discussion (Misc queries) 1 June 17th 05 10:22 AM
Pivot Charts, hiding field values in second level filters? elrao Charts and Charting in Excel 1 June 17th 05 10:19 AM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"