It has a purpose, but GetPivotData has confused and frustrated many Excel users. You want to write a formula using PivotTable cells and get a clunky, inflexible result. Here's how to stop …
Data Lessons from Your Mom
Hello readers! It's been some time since my last LinkedIn post.I've been shifting more attention to my site at georgejmount.com, with my big goal to develop an online class based on the themes of my …
Quickly Fill Blanks Cells in Microsoft Excel
Hello Readers, Happy New Year!I've been unusually silent lately, in between the holidays and a nasty virus. Avast! I am back with more.I'm trying a new medium: YouTube video. This is a great platform …
Continue Reading about Quickly Fill Blanks Cells in Microsoft Excel →
Conditional Formatting Across Columns
Update: After getting clarification from the reader I developed the attached model. It was bit trickier than I thought at first and I am feeling a little under the weather tonight so have not gone …
Continue Reading about Conditional Formatting Across Columns →
TRIM as the Tree Comes Down
Merry Christmas! I hope you are enjoying the holiday and spending more time with friends and family -- and maybe less with your spreadsheets!Here is an appropriate Excel tip as your Christmas tree …
Is There a Problem Here?
If there were such a thing the Analyst Scouts, it'd have the same motto as the Boy Scouts: Always Be Prepared.A good analyst is thinking two steps ahead of his data, anticipating problems and taking …