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...
by admin | Jan 17, 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. Assuming you have done that, in this part we are going to look at constructing our first pivot table. In the video below I will show you how to...