In the 49th session of Chandoo.org podcast, let’s talk about data dumps!
What is in this session?
In this podcast,
- What is a data dump
- Examples of data dump
- Why we dump
- Ways to avoid data dumps
- Go for information dumps
- Sort the dump
- Filter the dump
- Give a table
- Resources for you
Listen to this session
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Click here to download the MP3 file.
Resources for making animated charts
Making better charts in Excel:
Charting podcasts:
- CP029 – Impress your boss with awesome charts – 6 step road map
- CP032 – Rules for creating legendary column charts
- CP038 – Data to Ink Ratio – What is it and how to optimize it
Transcript of this session:
Download this podcast transcript [PDF]
Come across any data dumps? Share your story…
Now it’s your turn. Do you come across any data dumps in your line work? Share the story in the comments section.
Dump some love – Review my podcast
If you enjoy Chandoo.org podcast, please take a minute and write a review on iTunes.
Also, do dump this podcast on a colleague / friend. Make them awesome. Send them here: http://chandoo.org/podcast
6 Responses to “Using Lookup Formulas with Excel Tables [Video]”
H1 !
this is my very first comment.
Can you use same technique with Excel 2003 lists ?
thanks 😀
Thanks, Chandoo! I like seeing the sneak peak of what's to come on Friday too 🙂
@Damian.. Welcome to chandoo.org. Thanks for the comments.
Yes, you can use the same with Excel 2003 lists too.
@Tom.. You have seen future and its awesome.. isnt it?
[…] Using Tables – Video 1, Video 2 […]
[…] Using Tables – Video 1, Video 2 […]
Hi, is there a vlookup formula for the second example (IDlist)? I used a similar formula to look up the ID for the person, but the reverse way (look up the person with the ID) comes up N/A.