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 | Dec 14, 2020 | Excel | General
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 | General
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...
by admin | Nov 24, 2014 | Excel | General
Well, have to say I’ve been off the grid (at least for this blog post) for the past while but my intention is certainly to begin blogging again – bringing you lots of tutorials and interesting tricks and tips from the world of Excel. Recently I have been...
by admin | Sep 10, 2014 | Excel | General, Powerpivot 2010
So if you have read my first post in this series on Powerpivot, and you are thinking about exploring it a bit more here are some resources to check out. Installing Powerpivot There are two versions one for 32 bit machines and the other for 64 bit machines. You can...