If you’ve ever spent too much time trying to make a Google Sheet look nice, be it for your director or a board meeting….then this is for you.Continue reading
Project-managing and working with colleagues waaaasssnn’t exactly easy before the crisis. So I’m imagining that for most of us, things feel much trickier.
I can happily spend hours working alone in a spreadsheet. And I have! But there’s an undeniable satisfaction that comes with being able to work with a bunch of people, to achieve an important outcome for your org and your mission. When that happens, it’s a great feeling.
And when that doesn’t? It’s usually a hiccup somewhere in the coordination.Continue reading
We can all agree that duplicates are a pain. But they’re a real downer when you have a spreadsheet chock full of them, and no clue where to start cleaning.
Enter these spreadsheet tips.Continue reading
Dealing with duplicates can be a hassle! Here’s one option to add to your toolbox. Conditional Formatting lets you highlight duplicate or unique values in a column. Check out how to do it below!
p.s. You can get more spreadsheet tips straight to your inbox by subscribing here! –> Or, if you just want the vids, follow the Employed for Good Youtube Channel!)
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