Have you ever looked at a spreadsheet and thought “where do I even begin?”
Sometimes it’s a file we inherit from someone else in our org. Other times, it’s a data entry project turned disaster. Either way, our sector is no stranger to the messy spreadsheet.
Continue reading “VIDEO: How to Clean a Messy Spreadsheet in under 10 min”
No more sorting, cutting, pasting and resorting to calculate data. These formulas have got you covered.
This post is the second part of a Formulas-You-Need-to-Know series. If you haven’t seen the first part, you’ll want to start here.
But assuming you’re up to speed, get ready! This is another game changer.
Continue reading “Spreadsheet Formulas You Need to Know, Part 2: 3 Simple Conditionals”
Even if you’ve never used formulas before in your spreadsheets, you’ll be happy you scanned these formulas. They can save you hours of manual spreadsheet time.
Have you ever spent hours on a spreadsheet & thought “there has to be a better way”?
Then I’ve got bittersweet news. There probably was.
When I started using spreadsheets 6 years ago, I thought they were glorified Microsoft Word Tables. Except they were finicky and I could never get them to look right. 🤷🏻♀️
Fact is, spreadsheets come with tons of powerful functionality. The problem is just that it all sits quietly behind the scenes. And you won’t reap the benefits unless you know how to use some of them.
Enter this post series, devoted specifically to formulas.
Continue reading “Spreadsheet Formulas You Need to Know, Part 1: The 6 Biggest Time-Savers”
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 “2 Tricks for Better Looking Google Sheets (in under 3 minutes)”
For any spreadsheet situation involving duplicate entries – here are 2 tactics you’ve got to know. Instructions for both Excel and Google Sheets!
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 “2 Ways to Handle Duplicates in Excel + Google Sheets”
How to highlight duplicates in Excel for easy spotting, using conditional formatting.
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!)