Fantastic news folks…
As part of Office 2010 launch, Microsoft India is arranging a virtual launch event on May 25th and 26th. There are a ton of cool sessions on various Office products.
I will be presenting on “Sparklines and Conditional Formatting” On May 25th between 3:30 – 5 PM IST (we are GMT + 5:30). The event is free and open for all.
Click here to register for the event
Few more details about the event:
- You can join the session online or walk-in to one of the partner centers in India and attend.
- All the sessions are conducted by Microsoft India MVPs and Employees.
- Around 8000 people are expected to participate in the session
- All the participants are going to get an ebook and MS Certifications (I am not giving these, MS does, details should be provided during the sessions)
- For more details about Office 2010 Virtual Launch events, visit meraoffice.com
What will you learn in my session?
- Introduction to sparklines
- Introduction to conditional formatting (data bars)
- Learn how to apply sparklines and CF to a real world problem by building a simple dashboard
- Get URLs where you can download example files
Who should attend?
The session is good for anyone working with excel and upgrading to Office 2010 products in the near future. If you are someone responsible for deployment, purchase or training of Office products, then you might for the sessions very useful.
Any questions?
Drop a comment.
No questions?
Then go register… now!
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.