Tag Archives: Tools

Learned: Spreadsheet calculations that update totals when filtering!

Ever created a spreadsheet with calculations on a long list, and then experienced frustration when filtering your list because the calculated totals don’t change when cells are hidden? Yeah me too*. I did some searching and found these two macros that … Continue reading

Posted in Interactive Conversation | Tagged | Leave a comment

Excel -Kill off #DIV/0!

Are you as sick of that #DIV/0! as I am? Wrap it in this =IFERROR(MyFormulaHere,0) or if you want text instead then use =IFERROR(MyFormulaHere,”N/A”)

Posted in Interactive Conversation | Tagged

Choose a lane there buddy!

Grab a pencil and paper, here’s a cool exercise.  Regardless of how dominant your left or right brain might be, this is a fun exercise to demonstrate why changing sides in your head is difficult for everyone.  – On your piece … Continue reading

Posted in Interactive Conversation | Tagged , , ,