Last week's #FunctionFriday video tutorial covered VLOOKUP tips and techniques for marketers. This week's video explores the INDEX MATCH alternative … [Read more...]
VLOOKUP Tips And Tricks For Marketers [VIDEO]
The VLOOKUP function in Excel is one of the most essential functions marketers need to master. It's a staple in my tool set because it allows you to … [Read more...]
How To Find Text Within Text In Excel #FunctionFriday
Update: Based on questions I've received, I added the Misc Notes section to the end of this post. Continuing with our #FunctionFriday series, today … [Read more...]
Three Marketing Examples Of The OFFSET Function [VIDEO]
UPDATE: I shared this post because I know marketers are quite fond of the OFFSET function. But I share a much more stable alternative to the OFFSET … [Read more...]
21 Real-World Examples Of Concatenating Marketing Data In Excel
Hey! Welcome to another edition of #FunctionFriday! One of Excel’s Swiss army knives for marketers is the ability to concatenate things and stuff. Oh, … [Read more...]
- « Previous Page
- 1
- 2
- 3
- 4
- …
- 7
- Next Page »