Here's a recipe for how to use Pivot Tables, VLOOKUPs, If Statements, and the Concatenate function to take bigger data sets and manipulate them, saving you TONS of time so you can get back to organizing or putting your feet up. Plus, some lessons on segmentation. And some puns!
know one nose it all
A treatise on mystery, learning, and shame. A joyous reflection on NPSP Day Philadelphia. And a spreadsheet tip you might not know you needed.
dreamfierce
What started out as a post about Dreamforce took on a shape of its own as an ode to my dear friend, Ryan.
al chet for database admins
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!
far afield
Reflecting on what database managing and farming have to do with each other. Come for the puns, stay for the data tips!
5 days in 5 minutes
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.
Impasta Syndrome
5 concrete ways to unravel Impostor Syndrome (praise the planning crew for the Salesforce.Org Open Source Community Sprints!), plus some cute cartoons.
mile high dispatch
Update about projects I'm working on at the Salesforce.org Open Source Community Sprint in Denver, including "campaign hierarchies" (and why they matter to changemakers) and a nascent project around salary transparency. Plus, thank you to my readers for all of your recent support!
There’s something I’d like to address
Address management can have as many pitfalls as Philadelphia streets have potholes! In this post, I explore best practices for keeping track of addresses, thanks to many of YOU! for writing in with questions to Dear Spreadsheet Whisperer.
salesfierce / abolish ice
Join me in calling on Salesforce CEO Mark Benioff to cut the contract with US Customs and Border Protection! In this post... justice initiatives that revolve around Salesforce. Hence, #salesfierce - my take on justice and equity in the Salesforce landscape.