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: de-dupe

June 15, 2018 Samantha Shain Uncategorized

clean up in column 5!

9 tips for getting your spreadsheet data in tip-top shape. Especially useful for cleaning petition data!

May 16, 2018 Samantha Shain Uncategorized

Dupes / dupes / dupes (Excel)

Part 3 in a mini-series exploring the great, big world of “de-duping” – or, how to handle repeated info in a spreadsheet or database.  In this installment: using Microsoft Excel to highlight duplicates and summarize data. 

May 6, 2018May 15, 2018 Samantha Shain Dear Spreadsheet Whisperer, Uncategorized

Re-member-ships

Some ideas for "best practices" on managing memberships from The Spreadsheet Whisperer.  If you structure your data properly, you won't have to remember when people re-member.  Are you with me?

May 2, 2018January 1, 2019 Samantha Shain Salesforce, Uncategorized

Duped, again!

Part 1 in a mini-series exploring the great, big world of “de-duping” - or, making sure that you don’t repeat the same information twice in a spreadsheet or database.   This post includes "instant-gratification" links to tried and true de-duping resources.

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