When you need staff to add data to a spreadsheet, you can end up with lots of inconsistencies. Here’s how to use data validation to create drop-down lists, so that data is entered accurately and uniformly!
Anyone who regularly works with spreadsheets knows the anguish of screwing up said spreadsheets.
It usually goes like this. You’re powering through – filtering, sorting, formulating – until you notice that one row of data looks off. After frantically checking a few more rows, it hits you. Something went wrong in your manipulations, and now you need to start from scratch.
Spreadsheets are great, but they have also destroyed many a nonprofit worker’s day. Fortunately, we can do things to reduce the chance of this happening…and keep calm when it inevitably does.Continue reading
For any of you who work with spreadsheets too, you know those things can cost us lots of time! So I’m experimenting and sharing a few of the must-know tips via video.
For the first video in this series, check out how you can quickly format names, addresses, and organizations to have the proper capitalization!
I sort of got in trouble at work recently.
Don’t worry – nothing actually offensive took place on my part. My job isn’t in jeopardy, I’m not on probation, or anything like that! But I had an exchange with one of my directors, and as far as I’m concerned, I’ve definitely made a mistake in my role. Let’s dive in.
Anyone who manages a database knows that the job has it’s less-than-glamorous moments. Not that anyone would call this work glamorous…which is precisely why I love it.Continue reading