by admin | Jan 16, 2013 | Excel Path - Step by Step
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 Path - Step by Step
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 | Feb 7, 2022 | Excel | General
The usual wisdom around pivot tables is that they are generated from a single source of data. That is generally true. However from Excel 2013 onwards you can use the data model feature. The same rules still apply as using a vlookup (or indeed index/match) in that you...
by admin | Dec 14, 2020 | Case Studies - How To
This year has been the year of the pivot – so many people have had to pivot in their lives, both personal and professional. Pivot is defined as the action of turning around a point but of course in Excel it invariably means pivot table – which is basically...
by admin | Nov 4, 2016 | Excel Path - Step by Step
Debra Dalgleish (http://www.contextures.com) is one of my Excel heroines and the pivot table guru. She is someone whose work I regularly reference in class. I recently asked her to help me answer a question that regularly comes up in class when people ask about pivot...