top of page
.png)
Search

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...
17 views0 comments


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...
21 views0 comments


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...
21 views0 comments

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?
18 views0 comments


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...
11 views0 comments

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...
32 views0 comments


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...
16 views0 comments


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...
50 views0 comments


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...
21 views0 comments
bottom of page