excelpunks. Training – Consultancy – Solutions.

recent posts

about

Tag: pivot table

  • Sample 3: Collating of Data Using a Pivot Table and Macro

    For My Driving Instructor Download: https://drive.google.com/file/d/0B1pEq2dN7H9AWi1qNHdBY2J1QVk/view?usp=sharing I came across an interesting situation with my driving instructor.  He was collating a list of all the lessons the instructors in his team had taught for the day and the result of the lesson, being a pass or fail. He was collating this data by hand and I…

  • Magic to make the boss’ jaw drop with Pivot Tables!

    Data Processing 2: Pivot Tables Time to learn: 20 minutes Have tonnes of data that you can’t make sense of?  Need a fast way to organise and view your 10,000 cell spreadsheet?  Then, pull that rabbit out of your hat with pivot tables! A pivot table compiles and summarises all the information in a spreadsheet into…

  • Pivot Tables!

    Hi everyone, I see there has been a lot of attention on pivot tables.  Well, the page is ready! Have a look and have fun! Josh.