Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Pivot table help for beginners (Excel 2000 SR1a)

    I've seen pivot tables mentioned here numerous times, yet this is one feature of Excel that I havn't delved into as of yet... I'm thinking that once I got a bit of a start into them that I could make them work for me. Is there a good resource available somewhere (book, site, etc.) that would serve as a decent beginner's tutorial?

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Pivot table help for beginners (Excel 2000 SR1a)

    David, I don't know of any good book, specifically for pivot tables -- have been looking for one myself. I did a quick search on Google and got over 7000 hits on the expression "pivot table". That might be a place to start. I have found that most books on Excel have a small worked example on them, but I have learned the little I know from just playing around with data tables. I hope maybe that someone will write a book, because from the little bit I have seen, it is one of the most powerfule aspects of analysis in Excel. I have attached an example that may help. If I find anything else, I will definitely share through this thread.

    Ron M <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Attached Files Attached Files

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Pivot table help for beginners (Excel 2000 SR1a)

    Hi David,
    At the risk of appearing biased, Woody's SE Using Office 2000 has a decent introduction to pivot tables, or I have a book called Excel Expert Solutions by Brian Underdahl that's pretty good (mine is based on Excel7 but there may be a more recent version)
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    New Lounger
    Join Date
    Sep 2001
    Location
    Paignton, Devon, England
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot table help for beginners (Excel 2000 SR1a)

    <P ID="edit" class=small>Edited by gwhitfield on 15-Nov-01 06:46.</P>Chip Pearson's site has a good intro to pivot tables: <A target="_blank" HREF=http://www.cpearson.com/excel/pivots.htm>http://www.cpearson.com/excel/pivots.htm</A>. You could also look at John Walkenbach's site or his Excel 2000 Bible.

    Graeme

  5. #5
    New Lounger
    Join Date
    Jan 2001
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot table help for beginners (Excel 2000 SR1a)

    I am turning away from pivot tables at the moment. I had a large workbook that included 5 pivot tables. It was 11.5 megs. I removed the pivot tables replacing them with countif formulae together with various array formulae and reduced the overall size to 4.5 megs. I think that this should be an improvement.
    Do you need pivot tables?
    Regards

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Pivot table help for beginners (Excel 2000 SR1a)

    Do I need pivot tables? I don't know yet. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> For now, I'm interested in what they are and how they can be utilized, and then I'll see how well they may fit into my work. I use countifs and sumifs and matches and lookups and such right now (though nothing with arrays either). For hardcore data analysis I pull the data into Access and build queries. After looking at the 'Introduction to Pivot Tables' that GraemH's post points to, it looks like the pivot table might fill an 'intermediate' role or when I just need some quick and dirty analysis.

  7. #7
    New Lounger
    Join Date
    Oct 2001
    Location
    Northern VA
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot table help for beginners (Excel 2000 SR1a)

    When creating pivot tables, make sure you uncheck the Save Data with Table Layout in the Options section. If the box is checked, that means it will save your data with EACH pivot table -- meaning your spreadsheet was "duplicated" 5 times! When you uncheck the box it will always refer back to your original data and save you precious memory!

    Another box I always uncheck is the AutoFormat Table option. If you leave it checked and have multiple pivot tables on one spreadsheet, it will resize the columns to fit the last pivot table you refreshed, which can be a big pain depending on what you're doing.

    Don't give up on pivot tables -- they make life very easy (esp. by saving time) once you get to know them!

  8. #8
    New Lounger
    Join Date
    Jan 2001
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot table help for beginners (Excel 2000 SR1a)

    Thanks for the advice I'll check it out. It could save some heartache.

    Rgds

  9. #9
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Pivot table help for beginners (Excel 2000 SR1a)

    > At the risk of appearing biased...

    No need for silly caveats here! If you believe in a product, and you think it may be a good fit for someone else's needs, you should have no reservation against recommending it -- unless, of course, you receive a commission (or other direct benefit) for selling it. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> And if you were really intent on selling it, you would have hyperlinked the title to an order page to make buying it easier. <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>

    Besides, I was drawn to the Lounge after seeing/hearing recommendations of "Woodyswatch" from distinctly arms-length sources -- including a couple of potential competitors to the book you mentioned. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> If Woody's competitors are recommending Woodys as a reference/resource site, it definately makes me think there's something to your recommendation!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •