You can look it up - using Excel and Sheet functions to merge data - CXL Institute Revenue optimization services Copytesting Blog Search Start 7-day trial for $1 Subscriptions Minidegrees Live trainings Online courses Free courses Resources
Free Webinar

You can look it up – using Excel and Sheet functions to merge data

Forget plain old numbers! From IP addresses to email address to URLs, let’s explore the different ways Excel and Sheets can link those together.

Get unlimited accessWatch ondemand anytime!

Hosted by Fred Pike
Managing Director / CFO @ Northwoods

A key differentiator between a spreadsheet amateur and a pro is how well they can use the different lookup functions – when to use them, what the limitations are, how to set them up, etc. In this webinar we’ll dive into each of the Lookup functions – powerful additions to your analyst’s toolkit. If you haven’t played with these functions yet, join us for a quick (but thorough) demonstration.

In this webinar you will learn:

  • INDEX and MATCH – another, more powerful, tool for looking for matching datasets.
  • XLOOKUP – the newest Excel function, and a real winner. Handily solves all the shortcomings of the VLOOKUP command. Not available (yet
  • Using some combination of those functions, you’ll learn multiple ways to link disparate datasets together.

About Fred Pike

Fred Pike

Fred started his career using Visicalc, the very first electronic spreadsheet, and has been a spreadsheet aficionado ever since. Fred’s previous course for CXL, “Using the Google Analytics API add-on with Google Sheets,” was a well-received introduction for non-programmers to the nuances of the Google Analytics API and how to use Sheets to format the raw data into a presentable format.

Have any questions?

The webinar will last about 30 minutes. Have questions? Send them in the webinar chat or join our CXL Facebook group here. It’s a place for discussions about marketing, growth and optimization.

Get unlimited access

You can look it up – using Excel and Sheet functions to merge data

Forget plain old numbers! From IP addresses to email address to URLs, let’s explore the different ways Excel and Sheets can link those together.

Watch ondemand anytime!