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 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...

We are all in a hurry, most of the time, so I thought I would share one of my all time favorite Excel keyboard shorcuts.   How to Close An Excel Workbook If you want to close  a selected...

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...