Pivot tables

Pivot tables

Didn't find your answer?

I can't thank tom123 and adam.arca enough. They were one of a number that answered my question recently on csv files and pointed me in the direction of pivot tables.

I've never learnt to use pivot tables before as they looked fairly complicated and I didn't see any relevance to my particular way of working. But, having read their comments, I looked at PTs again and worked through the tutorials here on AWeb and realised that they weren't half as difficult as I had at first thought.

It will take a bit more practice on my part before I gain real familiarity with their use but I am getting there. The only thing is that, far from saving me time in the future, I will in actual fact be forever manipulating data using my new found skills. Thanks a bunch tom and adam :)

This obviously isn't a question. More of a suggestion that, if you haven't tried pivot tables yet, give them a try. It's well worth the time.

Replies (7)

Please login or register to join the discussion.

avatar
By DazedByTheLight
16th Oct 2011 10:46

And if you get yourself onto Office 2010 you get even more useful features including Slicers!

 

I remember being in your position several years ago, and owndering how I will ever understand Pivot tables but they are very intuitive and I have found it quite easy to explain how to use them to colleagues.

 

 

Thanks (1)
avatar
By cparker87
17th Oct 2011 13:05

.

Where are these tutorials? I've wanted to convert for a while!

Thanks (0)
Universe
By SteveOH
17th Oct 2011 13:21

@cparker87

If you click on Discussions at the top of this page, then scroll down to ExcelZone you will see a link to "Start here to learn about pivot tables".

The tutorials are based on Excel 2003 but I found it fairly easy to see where I was in Excel 2007.

Thanks (1)
Routemaster image
By tom123
17th Oct 2011 13:36

Enjoy

Very glad to see you have looked at pivots. You will soon find that, as well as dealing with imported data, your default approach to your own spreadsheets is 'how can I use pivot tables to make my task easier,

 

 

Regards

Thanks (0)
John Stokdyk, AccountingWEB head of insight
By John Stokdyk
24th Oct 2011 15:48

Pivot Table tutorials - Sorry they're so hard to find

Thanks for the feedback - I'm glad to see that the Aweb members and David Carter's tutorials have proved their value once again, but sorry that they're so hard to find. Here are a few more for your consideration:

Want to learn about Excel pivot tables? Start hereWant to learn about pivot tables? Part 2 David Carter's Five Minute Pivot Table TipsReturn of the pivot table tutorialsExcel 2007 - A new approach to PivotTablesImprove your reporting skills with self-teach tutorialsAnalyse sales data with Excel pivot tablesSage Line 50 and Pivot Tables tutorialAudit and financial reporting with pivot tables tutorialModelling and What if? analysis with pivot tables - TutorialConsolidating multiple worksheets in a Pivot Table tutorialExcel 2000/XP pivot table tutorial - Budgeting

Steve's threads have alerted me to the navigational issues around the tutorials and we'll put some effort in over the next few weeks to make them more accessible to everyone else. In the meantime, you can find more pivot table-related content on the PivotTables tag page, and the ExcelZone discussion group that Steve has already mentioned.

Thanks (0)
avatar
By jellard
25th Oct 2011 17:56

Links need correcting

Hi John

Unfortunately a few of your links do not work, I believe they may be missing /item/ in link numbers 5 and 7 - 12

Great tutorials btw

Thanks

James

Thanks (1)
John Stokdyk, AccountingWEB head of insight
By John Stokdyk
15th Nov 2011 12:41

Thanks, James

Links are now fixed. Glad you like the tutorials - once you managed to track them down.

Thanks (0)