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 join any number of data sets, as long as they have one column in common. Sadly, as is the case with most really useful Excel techniques, it […]
Search Results for: excel
The Definitive Guide To Campaign Tagging in Google Analytics
This comprehensive guide includes a video, Google Spreadsheet that auto tags your links, sample campaign strategy, and multiple custom reports. Check it out!
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 function. If you’re building out a dashboard or large Excel file, the INDEX function will take less of a toll on your workbook than its more volatile OFFSET counterpart. And […]