5 Things you probably dont know about this site

Share

Facebook
Twitter
LinkedIn

Hi there,

Pointy Haired Dilbert - Chandoo.orgWelcome to Pointy Haired Dilbert. Over the last few weeks, we have seen huge influx of new members in our little community. So I am writing this to welcome you.

This is a site for people who want to tell stories using charts and data. Although we focus more on learning Microsoft Excel, we have hundreds of useful resources on data visualization, dashboards, charting best practices and data analytics.

My name is Chandoo, I am from India, but I travel around the globe frequently and have worked in 7 countries in last 3 years. I have started writing PHD in 2004, mostly to tell my friends and family about my b-school life. The blog became an excel and charting community in 2007 and has been growing strongly ever since. In year 2009, I have received the MVP award from Microsoft. Just few days back I have become a dad too…

If you are a subscriber to this blog, you should be getting fresh excel and charting tips through e-mail / RSS. But, there is more to Pointy Haired Dilbert than just a regular update.

Here is a list of 5 things about PHD that you probably don’t know,

Comprehesive resources to help you make an excel dashboard

That is right. We have a good selection of articles, tutorials and free downloadable templates to help you with your excel dashboards. There is a 6 part tutorial on making KPI dashboards using excel guest authored by Robert from Clearly and Simply.

Click here to see the excel dashboard section of the site.

Learn 51 Everyday Excel formulas in plain English

You can learn almost all the eveeryday excel formulas using the learn excel formulas section of the site. You can even buy the e-book version of it, which has 75 formulas in a much more learner friendly format.

Click here to see the excel formulas page.

Free Excel Downloads & Templates

We have a huge collection of free, downloadable excel templates, chart templates, excel utilities, excel games and much more in the free excel downloads section of the site.

Click here to see the downloads section.

Free Excel E-books

We have 2 free excel e-books on the site.

(1) 95 Excel & Charting Tips to make your 9 to 5 better

(2) Excel Ribbon Learning Guide

These books present great content in a fun & easy to learn way.

Ask an Excel question in our Discussion Forums

Recently we have added a discussion forum to PHD. In the discussion forum you can ask any excel or charting related question and get help from other members.

Click here to access our discussion forums.

Welcome once again. I hope you are learning and enjoying this place as much as we like to learn and share. Have a fun week ahead.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

6 Responses to “Using Lookup Formulas with Excel Tables [Video]”

  1. Damian says:

    H1 !
    this is my very first comment.
    Can you use same technique with Excel 2003 lists ?
    thanks 😀

  2. Tom says:

    Thanks, Chandoo! I like seeing the sneak peak of what's to come on Friday too 🙂

  3. Chandoo says:

    @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?

  4. Q.fg says:

    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.

Leave a Reply