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

October 25, 2022October 25, 2022 Samantha Shain Uncategorized

3 new-to-me spreadsheet capabilities (plus a bonus)

While analyzing survey data, I encountered 3 new spreadsheet capabilities in Excel and Google Sheets!

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

September 23, 2021 Samantha Shain Spreadsheets, Uncategorized

how to combine three contact lists

How to use simple spreadsheet formulas to merge three or more contact lists into one. Useful for data cleanup, data migration, surveys, event management, and email blasts!

April 13, 2021January 20, 2022 Samantha Shain Uncategorized

introducing: xlookup

Puppies are organizing to convince the zoning board to protect their dog park! They need help from VLOOKUP and XLOOKUP to get the job done. Follow along as we learn the ins and outs of these powerful functions in Excel and Google Sheets!

February 4, 2021 Samantha Shain Dear Spreadsheet Whisperer

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!

October 22, 2020 Samantha Shain Uncategorized

hay in a needlestack

What to do when you find data discrepancies?! I kinda felt like I did 6 loads of laundry, came out with socks I didn't even know I had, and then figured out how to match them up. Also, Spongebob, Rubix Cubes, and pivot tables.

October 18, 2020 Samantha Shain Uncategorized

filter down spreadsheet formulas

Like a coffee filter, the filter functions that I'm writing about today help us get to the very essence of our data. Read on for examples of filtering and summarizing a complex dataset, informed by a recent consulting project for an emergency homeless shelter.

August 31, 2020 Samantha Shain Uncategorized

call me, maybe?

Getting ready for your Q4 fundraising phone-a-thons? Follow these simple steps in Excel or Google Sheets to format your phone numbers for optimum ease!

June 18, 2020 Samantha Shain Uncategorized

hide and seek

=IF(FIND(ers, keepers), "", "weepers"). In other words, using text functions to make sense of lists. Plus, gifs and my pet turtle, Prince!

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