I don’t remember when was the last time both of us (Jo and I) were this excited. And the reason?
Nakshatra and Nishanth have started taking their first steps last week !!!
It is such a joy watching them take one step at a time. Aah, the beauty of parenting 🙂
So I asked myself, “What is a good way to celebrate this without looking like a super-excited dad?” and I got my answer in 72 milli-seconds.
I have created 10 short (<10 min) videos helping you to take baby steps in Excel world. Each video introduces you to one new functionality of Excel and shows you some nice examples.
Before jumping straight in to the videos, I want to share a short clip (30 seconds) of our kids taking their baby steps.
[Watch the video clip on Chandoo.org]
Look at them, although, they are scared and probably worried, they look so happy extending the leg in to unknown. If only we kept that curiosity until we get really old…,
The Excel Tutorials:
I have neatly structured all the videos in Excel Tutorial page.
You can learn the following topics from there,
- Introduction to Microsoft Excel
- Formatting Data in Excel – Basics
- How to Make a Chart in Excel?
- Writing Simple Formulas in Excel
- Introduction Conditional Formatting in Excel
- Introduction to Excel Tables
- Introduction to Excel Pivot Tables
- Using Excel Productively – Keyboard Shortcuts
- Printing Your Workbooks
- 10 Things you can do in Excel under 10 Minutes
How to get the most out of these videos:
- Start with first one and slowly graduate to next steps. No need to hurry, just take one step at a time.
- Keep Excel open and play as you go along.
- Pause wherever you want, repeat some steps until you are clear
- Follow the links beneath the video for more juicy and exciting stuff
- Don’t worry if you fall down or didn’t understand something. It is bound to happen, the sooner you fall, the faster you learn.
Spread the word:
Not about my kids walking. But about the awesome training material at Excel Tutorials page. Tell your friends or colleagues by dropping an email or sharing the URL. Just copy paste the below line.
Hey, check out http://chandoo.org/wp/excel-tutorial/ for some awesome excel tutorials.
That is all, go ahead and take your Excel Baby Steps 🙂














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.