People & websites that helped me in 2015 [thank you message]

2015 has been the most awesome year since starting Chandoo.org Thank you so much for making it happen. This year, more than 11 million people visited our site (up 8%), learned something and took first step to become awesome in their work. 2015 has been an amazing journey, thanks to all your visits, listens, purchases, […]

Continue »

Merry Christmas & Happy New Year 2016 [Holiday Greeting]

Merry Christmas & Happy New Year 2016 [Holiday Greeting]

A big, warm & pleasant hello to you.

I wish you a merry Christmas & Happy New Year 2016. 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. Every time you visit our website, read an article, leave a comment, enroll in a course, purchase a product, read one of my books, listen to a podcast episode, watch a video or tell your friends about Chandoo.org, I feel nothing but gratitude, thankfulness and amazement. 2015 is the most successful year since starting Chandoo.org, all thanks to you. Heartfelt thanks to you, from my family, staff and volunteers.

Continue »

Generate a snow flake pattern Excel [holiday fun]

Generate a snow flake pattern Excel [holiday fun]

Yesterday I saw a tweet from @JanWillemTulp with random snow flake generator.

That got me thinking…? Why can’t we make a snow flake pattern in Excel?

This is what I came up with.

Read on to know more about this snow flake and download the example workbook.

Continue »

How many Mondays between two dates? [homework]

How many Mondays between two dates? [homework]

Here is a quick but challenging homework problem for you.

Let’s say you have two dates – Start and End.

And you want to find out how many Mondays are there between those two dates (including the start & end dates).

What formula would give the answer?

Please post your formulas / VBA functions / DAX measures in the comments section.

Continue »

Color changing line chart [tutorial]

Color changing line chart [tutorial]

Let’s learn how to create a color changing line chart using Excel. This is what we will create.

Looks interesting? Read on.

Continue »

KPI Contest Winners

KPI Contest Winners

Today is a school holiday for kids. So we (Jo & I) are taking them to zoo for a day of walking, picnic and family time. Before I rush, I want to share two quick announcements with you.

KPI contest winners:

Thanks for everyone who participated in our recent KPI data visualization contest. Each and everyone who made the final list is a winner in my book. You have creativity, passion and a sense of sharing.

After reviewing all the entries and considering our judge’s opinions, here are the winners:

Continue »

CP050: Fifty Excel Tips to make you awesome

CP050: Fifty Excel Tips to make you awesome

This is going to be epic!!! In the 50th session of Chandoo.org podcastwe have 50 Excel tips to make you awesome.

What is in this session?

In this podcast,

  • Thank you message
  • Fifty tips in 5 buckets
    • Shortcuts & Productivity
    • Formulas
    • Managing Data
    • Charts
    • Using Excel better
Continue »