Welcome to Session 4 of Pivot Table Week. Thanks for joining me again for Session 4 in Pivot Table Week.  Today we will be looking at additional calculations in   If you need a recap of...

Welcome to Session 3 of Pivot Table Week. In this session we are going to start getting some good information from our raw data, getting the Pivot Table to all of the hard work really start to Pump...

Welcome to Session 2 in Pivot Table Week. Let's do a quick recap here. I have found to fully understand and get the best out of this fantastic Excel function you need to know the core terminology,...

Yes indeed Excellers it is Pivot Table week at how to excel at excel.com For some they are something they cannot live without in Excel world, for others they make them run screaming away at the very...

Gaps can be good, - sometimes - but not always on the Axis of your Excel chart. I think it looks like something is missing somehow or just downright untidy.  A bit like my example here...

This really was something that annoyed me until I found out how to fix it!  If you have large numbers on your Y axis it can take up waaaay too much space.the sales here may be good but the Y Axis...