Skip to content

The Data are Alright

  • Home
  • Blog
    • Spreadsheets
    • Civil Writes
    • Salesforce
    • Conga Composer
  • Dear Spreadsheet Whisperer
  • Consulting services
  • About
    • Testimonials
    • Link tree
    • Contact me

Tag: Dear Spreadsheet Whisperer

An anonymous advice column for spreadsheet emergencies, musings, and best practices.

April 26, 2022April 26, 2022 Samantha Shain Uncategorized

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!

December 23, 2021December 23, 2021 Samantha Shain Uncategorized

How to compare addresses

StreetStStrSt.AvenueAveAve. How many different ways can you write an address? Turns out... a LOT. Typically, when I am cleaning address data (yes, that's something I do quite regularly, what with being a spreadsheet whisperer and all), I am preparing to either (1) upload a single file into an online database or (2) create a mail … Continue reading How to compare addresses

July 1, 2021 Samantha Shain Uncategorized

Dear Spreadsheet Whisperer: Date Me?

What do my partner, date field formulas, and the Chicks have in common? Read this post to find out! Especially if you create time sheet systems to manage your workload!

February 4, 2021 Samantha Shain Uncategorized

Dear Spreadsheet Whisperer: Tzedakah Tsuris

What to do when you outgrow your grassroots spreadsheet systems? Try Airtable! It's flexible, freemium, and fun to use. Oh, and this is #NotAnAd!

January 22, 2021 Samantha Shain Uncategorized

Dear Spreadsheet Whisperer: Gettin’ Schooled

In this edition of Dear Spreadsheet Whisperer, lessons about how to set up spreadsheets to ask hard questions about racial equity in schools.

July 3, 2020 Samantha Shain Salesforce

Dear Spreadsheet Whisperer: capital-O Organizing

What's the best way to use a database for distributed organizing? Can Salesforce even do this? Plus, beautiful, custom watercolor illustrations from the one and only Katie Blanchard.

May 6, 2020August 29, 2021 Samantha Shain Uncategorized

smol, medium, large

Not knowing if a given scenario is easy or hard, or if there's an easier work-around to avoid a super-hard thing, feeds the overwhelm/impostor machine. It's so clarifying and liberating to just know what you're getting yourself into. PLUS, baby animal memes!

July 28, 2019August 29, 2021 Samantha Shain Uncategorized

Dear Spreadsheet Whisperer: Po-em-G!

Special guest "Axolotl Questions" aka my mom (!!!!) comes to the Spreadsheet Whisperer with a question about how to organize poems for her upcoming research project.

April 3, 2019August 29, 2021 Samantha Shain Salesforce, Uncategorized

Dear Spreadsheet Whisperer, What’s an Object?

What do unicorns, squirrels, and building blocks have to do with healing the Admin / End User divide? Read more to see my answer to an illustrious Salesforce User who's looking for resources to support her organization's Admin team to connect with a non-technical audience.

December 20, 2018August 29, 2021 Samantha Shain Salesforce, Uncategorized

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!

Posts navigation

Older posts

Tags

accounting address() array automation Black Lives Matter change management civil rights movement Civil Writes code conditional formatting conferences Conga Composer consulting counta() countif() crafting CRM cumulusci Data database data cleaning data culture data validation Data visualization de-dupe Dear Spreadsheet Whisperer EQAT error messages Excel facilitation feedback feminism filter() forms Formulas fundraising google scripts Google Sheets if() ifna() importrange() Impostor Syndrome indirect() interviews Justice large() LEFT() LEN() life with goldie listicle loops Mailchimp mailing list Mail Merge master's tools match() membership mentorship Metrics mindsets nationbuilder npsp openrefine open source phonebanking Pivot Tables poem PROPER() Public Health puns queer racial equity recruitment relational database reporting reproductive justice REPT() resource roundup RIGHT() rows() Salesforce salesforce flow search() self care SEO Single Source of Truth snowfakery social justice Spreadsheets sprints statistics SUBSTITUTE() sumif() systems testing thought piece TRIM() Tutorial unique() unofficial sf vlookup() xlookup() You Can Do It!
Powered by WordPress.com.
 

Loading Comments...