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.

Here is a simple solution to your forgetful, leaky brian – “Just put it in a spreadsheet”

This is a guest post written by Joel Zaslofsky, author of Experience Curating.

How to Make “Put It in a Spreadsheet” Who You Are (and Not Just What You Do)
It seemed like a crazy question:

Could I use my passion for Excel as motivation to transform my leaky brain from a weakness into a strength?

Sure, I already had a fifteen year love affair going with Excel.

Every other email I sent to my co-workers had an attached Excel spreadsheet. And when I wasn’t using Excel for work purposes, I was using it for grocery list templates or budget tracking.

But I had to discover the answer to my crazy question.

So I told my wife Melinda in January 2012, “Honey, this is the year I put it in a spreadsheet!”

Read This »

CP014: How to create awesome dashboards – 10 step process for you

In the 14th session of Chandoo.org podcast, lets figure out how to make awesome dashboards.

What is in this session?

Excel based dashboards are much in demand these days, thanks to advancements in Excel & growing pressure on costs. Now a days, analysts & managers are expected to quickly put together a dashboard using Excel. But how do you make a dashboard? What process you should follow? These are the questions we address in this podcast.

In this podcast, you will learn,

  • Announcements about upcoming dashboard classes
  • Ten step process for creating awesome dashboards
  • 1. Talk to your end users
  • 2. Make a sketch of the dashboard
  • 3. Validate your understanding
  • 4. Collect data
  • 5. Structure the data
Read This »

4th of July Fireworks – an Excel animation for you

To all our readers & friends from USA,

I wish you a happy, fun & safe 4th of July.

For the last 4th of July (2013), we (Jo, kids & I) were in USA. We went to Washington DC to meet up a few friends for that weekend. And we had one of the most memorable evenings of our lives when we went to national mall area in the evening to watch beautifully choreographed fireworks. Kids really loved the amazing display of fire-crackers and enthusiasm.

While we all are back in India this time, it doesn’t mean we cant celebrate 4th of July. So I made some fireworks. In Excel of course.

Here is a little Excel animation I made for all of us.

4th of July Fireworks – Excel animation

First watch this quick demo (<15 secs)

Read This »

CP013: Is this a FIFA worldcup of late goals, lets ask Excel [How to analyze data to answer questions like these…]

In the 13th session of Chandoo.org podcast, lets turn our attention to on-going FIFA worldcup and ask an important question.

What is in this session?
A week ago, we discussed “Has it been a late goal FIFA worldcup?” and used various charts & analysis techniques to answer the question. In podcast, lets tackle the same problem, understand various approaches to answer questions like these & shares some lessons for all the analysts.

Read This »

A quick Excel tip for you while on a long bike trip…,

Hi friends,

I have a surprise for you. Between the late night world-cup matches & my reinvigorated thirst for biking, I have difficulty finding time to write a long & detailed article for you. So I thought why not say hello to you and share an Excel tip while I am on a biking trip.

Go ahead and check it out. Its just 4 minutes.

Watch it below or on our YouTube channel.

Read This »

CP012: Top 10 Excel Keyboard Shortcuts for you

In the 12th session of Chandoo.org podcast, lets get productive fast.

Announcement: Short format podcasts sessions once a month

Based on listener feedback, I am adding short format sessions (20 mins). This short format sessions will run once a month (along with longer sessions that we publish almost every week) so that you have something light & easy to chew between heavy doses of Excel awesomeness.

I hope you like this new format. Do let me know what you think in comments.

And I really appreciate your reviews & comments on iTunes. Please click here and post your review.

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)