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 | 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...
by admin | Sep 3, 2014 | Powerpivot 2010
Powerpivot is a new free add-in that first appeared in Excel 2010. As a trainer I’m incredibly excited about the possibilities this offers Excel users to streamline their work and to do a lot more with their data. Imagine just updating your data connection and...
