by admin | Jun 2, 2014 | Excel Pivot tables | Introduction, Excel | Case Studies, Excel | Useful tricks
I was recently teaching a class on Powerpivot and the subject came up of how to use Excel to construct an aging analysis. The person had already created some serious serious formulas to do what he needed to do so no point in re-inventing the wheel. His big interest...
by admin | Feb 12, 2013 | Excel Pivot tables | Introduction, Excel | General
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 | Jan 16, 2013 | Excel Pivot tables | Introduction
This is part two of my introduction to pivot tables. You can have a look at part one here. A new feature in Excel 2007 is called the table. While it is not essential to convert your list to a table, doing so means that you can then work more efficiently with your data...
by admin | Jan 8, 2013 | Excel Pivot tables | Introduction, Excel | General
This is the first in a series of blog posts about pivot tables in Excel. A pivot table is a tool in Excel which allows you to move around your data so you can see it under different headings e.g it can take a list of sales and allow you to show you sales by country,...
by admin | May 14, 2012 | Excel Pivot tables | Introduction
How to create pivot tables If you are working with any sort of lists in Excel and you want to be able to extract meaningful data out of it, a key skill you should have in your toolbox is how to create a pivot table. Essentially a pivot table allows you to move around...