by admin | Feb 20, 2013 | Excel Path - Step by Step
Well, I have you enjoyed this series on pivot tables (you can start again at one and work your way through two, three, four, five, six, seven and eight any time you want to. However, today I just wanted to let you know about an excellent Add-in developed by Debra...
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...
by admin | Feb 7, 2013 | Excel Path - Step by Step
So we are now up to seven of the eight part series I am doing on pivot tables. You can check out parts one, two, three, four, five and six here. In Excel 2007 (and later editions) the charting facility with your pivot charts gives you a huge amount of flexibility....
by admin | Feb 5, 2013 | Excel Path - Step by Step
This is number 6 in an 8 part series of blog postings on pivot tables. You can read one, two, three, four and five and number seven and eight are on the way next week. I came across this rather delightful little trick on www.datapigtechnologies.com . Essentially it...
by admin | Jan 31, 2013 | Excel Path - Step by Step
In part one of this series, I looked at list preparation and in part two, I suggested that you convert your list to a table to make it much easier to manage adding in new data. In part 3, we looked at how to construct your first pivot table. In part four I showed you...
by admin | Jan 24, 2013 | Excel Path - Step by Step
In part one of this series, I looked at list preparation and in part two, I suggested that you convert your list to a table. In Part 3, we looked at the nuts and bolts of creating your first pivot table. In this post I am going to look at how you quickly convert your...
