An interesting Excel feature is that as you make the 12-month chart smaller and smaller, Excel drops the last (right-most) label ...

Date Units on the X Axis- Excel I was working on a dashboard in Excel 2016 and I ran into something a bit frustrating. So, I thought I wou...

Automatically update your Pivot Table  Whenever I start showing people Pivot Tables, one of the first questions asked is: “What hap...

Ever open up a worksheet and have an  " Update Links"  dialog box pop up and, even after searching, you can't find the link...

My primary use  for Go To Special  has been to select only the visible data in subtotals and pivot tables; however, it has a lot of other ...