Spreadsheet Formulas You Need to Know, Part 2: 3 Simple Conditionals

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”

Spreadsheet Formulas You Need to Know, Part 1: The 6 Biggest Time-Savers

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”

5 Excel List Nightmares & How to Fix Them

Without hours of manual updates, that is.

Updated 2020 – If you’re reading this blog, there’s a good chance that you work with spreadsheets from time to time.

Maybe you’re like me: eager to dive into that world of cells and formulas. Or maybe you dread each time you see an email with a .csv or .xlsx file.

Because once you open that file, you know all bets are off. Who knows what kind of mistakes are waiting for you.

Credit: Giphy. The only platform that lets me combine two disparate loves: spreadsheets and Love & Hip Hop.
Continue reading “5 Excel List Nightmares & How to Fix Them”