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 numbers into percentages.
Remember you can kill someone with a chair but not with a pivot table 🙂
[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/pivot_table_intro_percentages.m4v’]
And as always here is the file for you to practise on.