Archive for December, 2015

2015 has been the busiest year since starting Chandoo.org.

Wow, that is 12 years of breaking previous records. Thank you.

In 2015, we published 124 posts (down 3% YoY), received 6,300+ comments (up 5%). Our forum too had busy year with 1000s of new members and 5,000+ new threads. Chandoo.org podcast continued to shine, we had 24 episodes this year and reached the 50 episode milestone. Our podcast episodes has been downloaded more than 900,000 so far since launch (in March 2014) with 600,000+ downloads this year alone!!!

Fun fact: People have spent 6.8 million minutes in 2015 listening to Chandoo.org podcast. (assuming only 50% of downloads materialized to listens)

We have trained more than 1,800 people thru my online classes – Excel School, VBA Classes & 50 ways to analyze data program.

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, […]

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.

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.

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.

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

Looks interesting? Read on.

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:

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

This is going to be epic!!! In the 50th session of Chandoo.org podcast, we 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

Here is an interesting twist on the good old VLOOKUP. How to find the pricing applicable for given quantity of a product?

Something like above.

Looks interesting? Then read on…