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: Spreadsheets

Musings on using Microsoft Excel and Google Sheets to solve real-world problems for social justice practitioners. I focus on formulas, scripts, pivot tables, and design techniques to help you get the most out of your spreadsheet-based systems – and I have a lot of fun, to boot!

May 17, 2022May 17, 2022 Samantha Shain Uncategorized

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!

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!

April 11, 2022April 11, 2022 Samantha Shain Ethical Tech, Salesforce, Uncategorized

NEW VIDEOS | practicing cognitive flexibility with my bestie

A retrospective on the Emily and Samantha collab + Emily and Samantha tackle cognitive flexibility!

April 2, 2022 Samantha Shain Salesforce, Uncategorized

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.

February 6, 2022 Samantha Shain Spreadsheets

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!

January 17, 2022January 17, 2022 Samantha Shain Salesforce, Uncategorized

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.

December 27, 2021December 28, 2021 Samantha Shain Spreadsheets, Uncategorized

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!

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

November 22, 2021 Samantha Shain Conga Composer, Salesforce, Spreadsheets, Uncategorized

on gathering (or, what I’m learning as I make mail merge tutorial videos)

Learning how to share mail merge templates with all of you turns into a reflection on The Art of the Gathering, and digital sharing in general.

November 3, 2021January 20, 2022 Samantha Shain Salesforce, Spreadsheets, Uncategorized

how to populate multi-select picklists in Google Sheets and Salesforce

Do you need to edit multi-select picklist values in a Google Sheet and then import them into Salesforce? I have a script to help you transcend the limitations of data validation!

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...