by admin | Oct 18, 2021 | Excel Path - Step by Step
I was recently asked in a class about grouping entries together. In that case it was fish lengths but what I show here applies to a wide range of options. The first method shows you how to use the inbuilt facilities of Excel pivot tables to group numbers into...
by admin | May 31, 2021 | Case Studies - How To
I was recently asked by a friend to help her identify who were the top three contributors in a project – based on Page Views and Participation. She also wanted to get some idea of frequency of contribution.. You can download the original (anonymised) file...
by admin | Feb 12, 2013 | Excel Path - Step by Step
So this is the final installment in the series of pivot tables. You can check out parts one, two, three, four, five ,six and seven here. A new feature of Excel 2010 is the Slicer – which looks rather like a grater but which allows you to easily “slice and...
