top of page
.png)
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
17 views
0 comments


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
21 views
0 comments


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
21 views
0 comments

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
18 views
0 comments


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
11 views
0 comments

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
32 views
0 comments


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
16 views
0 comments


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
50 views
0 comments


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
21 views
0 comments
bottom of page