Hi guys,
I've been told by one of our engineers, that using Pivot tables for an ongoing task I have, would be a great thing to do, saving me time, and minimising error.
I've got 'Excel 2002 Power Programming with VBA' by John Walkenbach, which has been a useful tool for other tasks, but when looking at the Pivot tools section, it expects you to have a rather comprehensive background in pivot tables.
I have a good working background of Excel, but Pivot tables are just something I've never bothered with, as most things I did I was happy with the speed/outcome, but my current task is a real time waste.
I'm hoping someone can point me to a book, website, tutorial xls, or even post some tips.
Thanks in advance guys.
-Cully
I've been told by one of our engineers, that using Pivot tables for an ongoing task I have, would be a great thing to do, saving me time, and minimising error.
I've got 'Excel 2002 Power Programming with VBA' by John Walkenbach, which has been a useful tool for other tasks, but when looking at the Pivot tools section, it expects you to have a rather comprehensive background in pivot tables.
I have a good working background of Excel, but Pivot tables are just something I've never bothered with, as most things I did I was happy with the speed/outcome, but my current task is a real time waste.
I'm hoping someone can point me to a book, website, tutorial xls, or even post some tips.
Thanks in advance guys.
-Cully