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.

2018 Calendar, daily planner Excel templates [free downloads]

Here is a New year gift to all our readers – free 2018 Excel Calendar & daily planner Template.

This calendar has,

  • One page full calendar with notes, in 4 different color schemes
  • Daily event planner & tracker
  • 1 Mini calendar
  • Monthly calendar (prints to 12 pages)
  • Works for any year, just change year in Full tab.
Read This »

Merry Christmas and Happy New Year 2018 [Holiday Card]

Hellow there…

I wish you a merry Christmas & Happy New Year 2018. May your holidays be filled with joy, togetherness, celebrations and fulfillment. May your new year be filled with hope, energy and awesomeness.

I want to tell you how thankful I am for all your support in this year. Each time you click, visit, read, comment, share, view, listen, purchase, subscribe, follow, question, discuss or email, my heart is filled with gratitude and happiness. Thank you for all the love and support. 2017 has been another amazing year in Chandoo.org journey and I owe this to you.

Read This »

How much long service bonus to pay? [Homework]

‘Tis Friday and it is too hot in my home office to stand and type a longish post. So, let’s keep this skirtish (short and pretty).

How would you calculate long service bonus?

Let’s say you are HR manager at BigLargeInc. and you are looking at Julia’s service details. You have her employment start date, current date, her leave without pay details, as shown below.

 

You need to calculate how many days of continuous service Julia had (ie total service – duration on leave without pay). How would you write the formula?

Read This »

5 conditional formatting top tips – Excel basics

Time for another round of unconditional love. Today, let’s learn about conditional formatting top tips. It is one of the most useful and powerful features in Excel. With just a few clicks of conditional formatting you can add powerful insights to your data. Ready to learn the top tips? Read on.

Read This »

Filter all records for November or 11AM or 2017 [quick tip]

Imagine you are the first officer at ship terminal αε974F1 on remote planet Alderaan. Your job involves looking at terminal log to see anomalies in time space continuum. So one day after getting to work late, thanks to crazy traffic on the floating super way in your settlement, you are looking at latest terminal log for αε974F1 on Excel (of course Excel, what else are you going to use? Notepad?!?) and want to check all the records logged at 7 AM on any day. You don’t have all the time in universe to filter records one at a time. You don’t want to write a formula or something else as it is too early in the morning and the nearest Starbucks is 7 light years away. So what would you do?

Use filters of course.

Read This »

Thank you, we have a home in New Zealand

Time for a quick residential break from all the Excel awesomeness. I have an exciting news to share with you all.

We have a home in New Zealand.

In the middle of 2016, we moved to New Zealand. We have been living in windy, lovely and beautiful Wellington ever since. After renting a house and sampling life in NZ, we decided to call it home for next few years. The next natural step is to purchase a home and move in.

Read This »

Which power plan is best for me? Excel for everyday problems

We had to switch power providers soon, so I started reviewing the options. There are heaps of providers in New Zealand and each offer a ton of different plans. Some offer welcome bonus or credit worth up to $ 200. Other offer straight forward rates. Some others offer discount if you sign up for both electricity and gas with them. So how do you decide which one is better for you?

Using Excel of course.

The result is awesome. I ended up saving more than $1000 with a simple model. Puzzled? Curious? Check out this short but powerful video tut.

Read This »

Conditional Rank, the easy way [quick tip]

Yesterday, my mate from across the ditch, Hui posted about conditional rank formula (RANKIFS) using awesome SUMPRODUCT

Of course, not everyone can whip up a sumproduct formula like that. On a scale of One to Hui of Excel awesomeness, you would need to be at least an H to write sumproduct or countifs formulas shown in that post. So does it mean, you can’t conditional rank if you don’t know your X from L?

Don’t worry. We got you covered. You can still get your conditional ranks, without inception level array formulas. Simple, use pivot tables instead.

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)