UPDATE: I shared this post because I know marketers are quite fond of the OFFSET function. But I share a much more stable alternative to the OFFSET … [Read more...]
How To Create A Dynamic Chart From A Pivot Table [VIDEO]
In a post I wrote last week, I demonstrated in a video how to use advanced filters (one of Excel's best-kept secrets) to divide a list of keywords … [Read more...]
[VIDEO] Excel Bug In Pivot Charts On The Mac
As I mention in my post on creating pivot charts, you can't create pivot charts in Excel for the Mac. It's, hands down, my greatest aggravation with … [Read more...]