Isn't it great when spreadsheets just WORK, making your repetitive tasks faster and more accurate? Here are two examples of spreadsheet tools I've built with a combination of Salesforce exports and spreadsheet prowess. Using them makes me feel proud and blissful!
expand, contract
Spreadsheets or life-in-general bringing you stress? Here's a tutorial about how to wrangle your spreadsheets with the "Group Rows" function. Plus, a mindfulness exercise!
open (source) sesame
What I'm learning at a Salesforce.org Community Sprint in Long Beach, CA.... from admin skills to being WAY over my head with a coding working, and sticking it out anyway. Plus, HI and THANK YOU to TDAA readers who I got to meet in person!
admin emoji
Frankly, I'm surprised that it's taken me this long to realize that I needed to blog with emojis, given that I use my Emoji keyboard in almost every text or slack message. But, here we are. Btw- WordPress (my blogging platform) isn't great in the emoji department, but I found a workaround. Bear with me. … Continue reading admin emoji
oops baby
You’ve heard of oops babies, right? This post is about being an oops database manager – in the field, we call them, “accidental admins.” It’s a story about how I made this my career (as early in my career as I am, I really love what I do!) and the values that guide my work.
pivot swivet
In this installment of Dear Spreadsheet Whisperer, we use pivot tables, VLOOKUPs, and a mail merge to send top notch donor acknowledgement letters. Plus, gifs and cat memes!
(re)portable
Imagine your data are stored in a database. When should you save a new report versus modifying a template? How should I tackle a reporting strategy? What kind of winter coat should I buy? These questions are all raised, and maybe answered!
Ifs, Ands, AND Buts
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.
