top of page
.png)
Here to Help.
Search


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 1, 20231 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
Jun 8, 20206 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
May 27, 20204 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, 20202 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
Apr 8, 20204 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
Feb 18, 20205 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 26, 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 15, 20193 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...
Beth McCranie
Nov 12, 20192 min read
bottom of page