Use shift + F11 to insert a new worksheet in Excel.A pretty self-explanatory one -- but also a huge time-saver, and also proof that Excel is magic :) PS: A reader mentioned to me that some GIFs …
Avoid the Dread GETPIVOTDATA
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 …