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.
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.
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
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.
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, James
Links are now fixed. Glad you like the tutorials - once you managed to track them down.