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.
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 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.
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!