We are in a period of reflection and atonement in the Jewish ritual calendar, so here is an Al Chet (collective confession) for the sins we, as database administrators, have committed. Add your own in the comments!
What should you do if the built in Excel Table Styles don't match your colors or preferences? Create a Custom Table Style, of course! Here's a post that walks you through the "how" and "why" to customize your table designs. Here's a hint- think about who else uses your spreadsheets besides just YOU! Come for the puns and stay for the data 🙂
Reflecting on what database managing and farming have to do with each other. Come for the puns, stay for the data tips!
Looking for resources to brush up your Excel prowess? Look no further than these links and courses. The Spreadsheet Whisperer is here to help - with data, puns, and more!
How to filter a list based on another list, featuring one of my favorite data tools... the VLOOKUP! Plus, some examples for how this tool can be used for political organizing, and the "pull rabbit out of the hat" meme makes another appearance.
On a pragmatic level, I offer 6.5 concrete ideas for interfaith solidarity in databases. On a conceptual level, I explore how databases built to promote religious tolerance can lead to behavioral change. What else is possible if we build systems that accommodate and celebrate the fabulous diversity of our communities? Thanks to colleague and mentor Andy Kirshner from IFYC for exploring these ideas with me over dumplings and bubble tea (the way to my heart!)
Life update! I moved in with my partner! Introducing... some spreadsheets I'm using to set up our kitchen, including The Spreadsheet Whisperer's kitchen supply reccos and Weekly Meal Planning. Read on for all that, and more....
Have you ever played spreadsheet hide and seek with hidden columns, filter views, and more? Or have you ever needed to temporarily hide or restrict access to certain information? If yes, then this post is for you (plus, cute bunny gifs!)
50 posts later, what's up with The Data Are Alright? A retrospective post that summarizes major themes and popular posts, and sets some new goals for the next 6 months!
What do you do if you're outgrowing a contact list in Google Sheets? How can you store info for a political campaign before you go live with a database? Last but not least, how to link Google Forms to existing Google Spreadsheets. Onward!