fbpx

Welcome to Chandoo.org.
My mission is to make you AWESOME in your work.

Hello, Namaste & Kia Ora. Welcome to Chandoo.org. 

My name is Chandoo. My mission is to make you awesome in Excel and Power BI.
I do this by sharing Excel & Power BI tutorials, examples, tips, videos and articles on this website. I live in Wellington, New Zealand with my beautiful wife Jo & our twins Nishanth & Nakshatra. Take a minute to browse various topics of the site to see how I can help you.

Thank you and welcome.

Not so wild lookups

In case, this is the first time you are hearing about Excel formula wildcards, check out the Using wildcards in Excel VLOOKUP formula tutorial.

So you know about wild cards like * ?, now how would you tell VLOOKUP to ignore them?

Say, you are genuinely interested in looking the value “* Payroll” in a lookup table. What then?

This is exactly the problem faced by Peter in our forum post VLOOKUP and cells with “*” NOT to be interpreted as wildcard

Read This »
Chandoo.org Podcast Sessions

CP052: Book Review – M is for Data Monkey by Ken & Miguel

In the 52nd session of Chandoo.org podcast, let’s discuss monkeys, Ok, I am kidding. We are going to talk about M is for Data Monkey book.

What is in this session?

In this podcast,

  • Updates: Why so much gap between episodes?
  • Quick introduction to Power Query
  • Why you should get this book?
  • What is in this book?
  • A very cool example of the techniques you will learn
  • Conclusions
Read This »

Make 1,200 dinosaurs in no time with Excel [formulas]

It seems spreadsheets & dinosaurs on a collision course. How else can you explain Jon’s XKCD Velociraptor problem solved with Excel and now this. Debby, alert reader of our blog sent me this email yesterday.

I need an algebraic formula to solve this in Excel

I have 5 heads, 5 bodies, 4 arm sets, 4 leg sets and 3 tails. I need to see if I can create 1000 dinosaurs from these, and if that’s too many AND I need the 5 digit groupings to prove it and create them.
basically Xa*Xb*Xc*Xd*Xe=1000 – I’m not supposed to go over 1200. […] And then I want the 5 digit combinations if possible – right now they are trying to do the combinations by hand – would be awesome if we could do it in Excel.

Read This »

Format charts quickly with chart styles & color themes [quick tip]

Here is a quick tip to reduce the time you spend on chart formatting – use chart styles & color themes.

Excel offers various pre-defined color schemes and chart styles. Using them is very simple.

  1. Select your chart
  2. Go to Chart Design ribbon
  3. Click on the style or color scheme you want.
  4. Your chart changes instantly.
Read This »
VLOOKUP FAQs - Frequently asked questions about Excel VLOOKUP formula
Chandoo.org Podcast Sessions

CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered

In the 51st session of Chandoo.org podcast, let’s discuss most frequently asked questions about VLOOKUP.

What is in this session?

In this podcast,

  • What is VLOOKUP?
  • What happens when VLOOKUP can’t find the value?
  • Should my list be sorted?
  • Is VLOOKUP slower than INDEX + MATCH?
  • What if my list has multiple matches?
  • How to fetch 2nd / 3rd matching item?
  • How to fetch all matching items?
  • How to fetch items matching multiple conditions?
  • How to speed up VLOOKUP?
  • Why doesn’t my VLOOKUP work?
  • What to do in case of errors?
  • Resources for you
Read This »

Latest Video

for more videos…

Learn Excel Step by Step

Everything from Power Query to Dashboards, Shortcuts to Formulas, Pivots to Charts in one course.

Topics

Power BI

Excel & Power BI for you

What people say about Chandoo.org

A relative told me about your website since I need help creating pivot tables, I learned how to do it in a matter of minutes thanks to your tutorial. Where have you been all of my excel troubled life, I look forward to viewing your videos on youtube as well as on your site. You are going to make me EXCELLENT at Excel!
Soulful Sista
Excel Sister
Hi Chandoo, I just want to say I really appreciate your Excel tutorials and all your hard work that it took to compile the huge library of content. Your site has helped me gain a better understanding of Excel which has helped me in my job. You are helping the world!
Felix H
Accountant
Throughout my life as an administrative assistant; your site has been invaluable to me. And now that I’m a recruiter; it’s still an amazing resource for when I need to teach someone something quickly. You are a friggin’ Rock Star!!! Thank you for everything you do.
Jason S
Recruiter

Courses for you

training-calendar-view

Excel School

Learn how to work with data, make calculations, pivots, create amazing charts and powerful dashboards from scratch using Excel School + Dashboards program. Suitable for analysts, managers or professionals who need to use Excel often.

vba-classes-from-chandoo

VBA Classes

Use VBA to automate your tasks and build powerful spreadsheet based apps. In this course, learn all about how to program with VBA, how to use the language and object model to your advantage. Suitable for people who build a lot of things with Excel.

cg2018-games-viz-power-bi

Power BI

Power BI, the newest technology from Microsoft is a game changer. You can build rich, interactive and informative displays for your audience using Power BI. In this course, learn all about Power BI, Power Query and Power Pivot and how to combine them to achieve awesome results.

=XLOOKUP(chandoo, on_social_media)