What strikes terror into the hearts of Excel beginners? VLOOKUP! Excel power users, though, can’t live without it.
Excel MVP Bill Jelen has declared March 25 – 31, 2012 to be VLOOKUP week. He’s invited his fellow Excel experts to publish VLOOKUP posts on their sites during the week. At MrExcel.com, Bill will offer five podcasts about VLOOKUP and do giveaways each day. Posts from across the web will be curated and published on a special blog at vlookupweek.wordpress.com.
(The latest report from Bill at 5 pm CST on March 22: VLOOKUP Week has taken on a life of its own. Bill finds himself with VLOOKUP t-shirts, coffee mugs, and a theme song and logo.)
Apart from generating VLOOKUP swag, Bill’s real goal is to make the fearful more comfortable with VLOOKUP, and to take the people who already know VLOOKUP to the next level. On his site, he’ll be publishing articles for beginners and experts; for example he’s planning one on how do a “VLOOKUP left” and another on how to return the row with the *last* matching value.
We’re participating, too, thanks to Bill. We’ll be publishing a five-part tutorial from him, one segment for each day of the week–with videos.
Before the week starts, you can find out if you’re an Excel beginner or an expert. Take a look at the tag cloud below to see if you can define more than five terms. Then at the end of the week check back to see what you’ve mastered.