Insights | McCranie Land Services

Beth McCranie

Jun 1, 20231 min read

XLookup Wins!

Yes, yes, I know there's a whole post about how much I love VLookup. BUT! I'm ready to admit that it's been replaced. Shocking, I...

Beth McCranie

Jun 8, 20206 min read

Macros

First, we'll do the TL;DR version, in case you just need a refresher. To start recording a macro, go to the View tab, click on the...

Beth McCranie

May 27, 20204 min read

Breaking Down Concatenate, "&", TextJoin

TL;DR: "Concatenate" and "&" formulas perform basically the same tasks, but with slightly different formatting. You can combine text in...

Beth McCranie

Apr 8, 20202 min read

3 Reasons to Maintain B2B Marketing in a Crisis

Marketing is often one of the first casualties of emergency budget-tightening. It’s an understandable response, but is it the wisest?

Beth McCranie

Apr 8, 20204 min read

Me and You, and You and Me...

You know that feeling when you have a perfectly good spreadsheet, and then you realize you need a seemingly simple change that will...

Beth McCranie

Feb 18, 20205 min read

Vlookup Will Change Your World

If you’ve never used vlookup, this may seem like a crazy statement, but if you dig through data for a living, Vlookup is what keeps you...

Beth McCranie

Nov 26, 20193 min read

How to Self-Manage Data using Excel

It’s almost December! That means the end of the year, and for most, the start to the “clean up” month. It’s that time you look forward to...

Beth McCranie

Nov 15, 20193 min read

Defining Data Management

It's easy to make a list of industry jargon and tasks, but what does it really mean? McCranie Land is here to help you get on track, and...

Beth McCranie

Nov 12, 20192 min read

Contractor or Employee?

Contractor versus employee is a debate with a long history in Oil and Gas. Many companies struggle to correctly identify their needs...