How to Translate Text Quickly (using Google Sheets)

I know my way around a few spreadsheet formulas. I love a good VLOOKUP and PROPER situation!

But this formula is so cool and fun (and surprising!) that I had to share.

Continue reading “How to Translate Text Quickly (using Google Sheets)”

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”

Here are 5 steps you can take once your org has Salesforce.

Your org’s got Salesforce. Now what? Here are 5 steps you can take to impact your implementation today, whether you’re the official admin or the de-facto one!

So. After lots of deliberation, your org finally has Salesforce. Yay!

Right?

Continue reading “Here are 5 steps you can take once your org has Salesforce.”

⏲️ 1min Spreadsheet Hack: PROPER-ly Format Those Cells!

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!