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.

A dashboard to visualize this FIFA worldcup [guest post]

This is a guest post by Krishna, a football lover & one of our readers.

The wait for lifting the most valued priced in football for Germans was finally over. For a football fan, world cup is best time that is scheduled every four years and that if your favorite team lifting the trophy is like your crush is going on a date with you. 🙂

A sneak-peek at the final dashboard

Here is the final dashboard (it has more functionality than depicted). Click on it to enlarge.

FIFA 2014 Worldcup Excel dashboard

Read This »
200k-bike-ride-dashboard
Charts and Graphs

Story of my first ever 200KM bike ride (plus an Excel dashboard with ride stats)

Ok people. Let me tell you that this post is almost not about Excel. It is about how one Excel blogger’s (yours truly) dream of long distance cycling came true. So sit back, grab your favorite drink and read between sips.

So what is this all about?

Last Sunday (27th July) & Monday (28th), I finished my first ever 200KM bicycle ride. I rode for a little more than 12 hours, burned 5,179 calories & rode 206 kilometers.

It is definitely one of the most memorable, tiresome & uplifting experiences in my life. So naturally, I want to share the story with you.

Read This »

Become awesome in data analytics, charting & Power Pivot with Houston Masterclass [reminder]

Hello friends,

Let me stop our broadcast of Excel tips to bring an announcement.

Houston, we are going to get awesome

AED 2014 - become awesome in Excel, data analytics, power pivot & dashboard reporitng

As you may know, I am doing 4 days of live masterclasses on Advanced Excel, Dashboards, Power Pivot & Data Analytics in Houston (Texas) this September.

  • 15 & 16 September (Mon & Tue) on Advanced Excel & Dashboard Reporting
  • 17 & 18 September (Wed & Thu) on Power Pivot & Data Analytics

This 4 day masterclass is aimed at managers, analysts, reporting professionals, executives in sales, marketing, customer service or anyone who wants to learn about Data Analytics, Advanced Excel, Dashboard reporting.

Please click here to know more.

Read This »

CP015: Handling big data, Controlling model railroad sets, Overcoming Excel obsession & more – ASK CHANDOO

In the 15th session of Chandoo.org podcast, lets answer some of your burning Excel questions.

Handling big data, Controlling model railroad sets, Overcoming Excel obsession & More - ASK CHANDOO

What is in this session?

Around last week, I invited you to ask me anything. More than 150 people responded to this call and sent in their questions. Since answering all the questions is not possible, I handpicked roughly 10 questions to answer in this episode of Chandoo.org podcast.

In this podcast, you will learn,

  1. How to fill blank cells with data from above
  2. How to work with Big data in Excel
  3. How to combine data from multiple sources & analyze it in Excel
  4. How I am managing my life after starting Chandoo.org
  5. How to create and distribute stand-alone Excel products
  6. How to control a model railroad set using Excel VBA (not fully answered)
  7. & more…
Read This »

Ask me your Excel questions & You could win an eBook

Time for another round of open-mic weekend.

As you know, Chandoo.org has been running a podcast show for last few months. We have completed 14 episodes as of today. For the 15th episode, lets have an “Ask Chandoo” as the theme.

What you need to do:

Simple. Head over to ask.chandoo.org and submit your questions. You can leave me a voice-mail or post your questions

What happens next?

I will listen (or read) your questions and choose a handful for the session 15 of our podcast.

What you get:

If your question is picked up for the podcast, you will receive the 25 Excel tips e-book.

Read This »

CHOOSE() me, an introduction to Excel CHOOSE function

Today lets learn about Excel CHOOSE() function.
CHOOSE eh? What does it do?
To understand CHOOSE() and appreciate its uses, lets invent an imaginary boos-subordinate pair.

Jasmine is the boss. She is, well, lets call her peculiar. She likes olives, Tuesdays & color Red. She hates potatoes.

Martin is the faithful butler of Jasmine. He is obedient, quirky and tall. He likes lotuses, Fridays & color blue. He hates potassium.

Enter Jasmine’s scarf problem:

Jasmine likes to wear a different colored scarf every weekday. She likes to wear Red colored scarf on Mondays & Tuesdays. She likes to put on the blue polka dot scarf on Wednesdays. On Thursdays, she wears her olive colored scarf. On Fridays & Saturdays, she prefers the lovely orange blue scarf. Sundays are no scarf days.

No wonder she is peculiar.

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)