In this post, I write about multi select drop down menus in Google Sheets, how to automate creating spreadsheets, and when automation might not make sense.
I merged two thousand duplicates in Salesforce manually, AMA
When faced with thousands of duplicates in Salesforce, what is the best way to merge them? Here's my reflection of merging them manually, and what I learned in the process.
5 special properties of Microsoft Word for Mail Merge projects
Formatting tips for complex Mail Merge templates in Microsoft Word including conditional logic, hidden text, controlling page breaks, and more!
How to interpret survey data in Google Sheets with dynamic charts and drop down menus
Sorting through Google Form survey responses? What if I told you that you didn't have to rely on the auto charts from Google Forms, and instead, you could develop a fully automated, responsive, Google sheets dashboard for disaggregating data and drawing insights from the data? Here's how!
Dear Spreadsheet Whisperer: Or Else?
What should a social justice movement leader do when his spreadsheets aren't behaving properly? Email the Spreadsheet Whisperer, of course!
NEW VIDEOS | practicing cognitive flexibility with my bestie
A retrospective on the Emily and Samantha collab + Emily and Samantha tackle cognitive flexibility!
I was wrong: tech mistakes, accountability, and trust
Report back from my session at #22NTC and what to do when we - inevitably - make mistakes on the way to good technology.
prepping synagogue data – and – introducing Jenks natural breaks!
What is the best way to divide fundraising totals into categories and create charts and graphs? Enter, Jenks Natural Breaks and some spreadsheet magic!
How to make Validation Rules into *Validating* Rules
The database world is replete with options for "validating" data, but there is a huge missing link in our field, which for me boils down to VALIDATING HUMANS.
by the numbers 2021
How did TDAA do at meeting its goals? How did TDAA compare to statistics from prior years? Lots of juicy metrics and reflection in this end of year round up!