All articles with 'personal' Tag

Finally, spring weather showed up in Wellington this week. We cashed it as much as possible by going on treks, cycling trips, more treks and of course doing laundry.

Anyways, I don’t have time to blog. I must go out and help kids with some cycling. But I want to keep you busy this weekend. So here is a fun homework problem.

Does my range have all numbers from 1 to n?

Let’s say you have a range called range (duh!).  And you want to check if range has all the numbers 1 to n (say n=5) in it, each number appearing only once (no more, no less). You can assume the named ranges range and n in your formulas.

See above examples to understand the problem.

So go ahead and post your formulas in the comments section. I will sneak in whenever I can to look at all your creative answers.

So we moved to Wellington, New Zealand few weeks back (on 17th of July 2016, to be precise). After spending first 3 weeks in Jeff’s house and a hotel, we moved in to our rental home over the weekend (on 6th of August). Around the same time, the worst of Wellington winter waved welcome to us. We quickly learned how to stay warm indoors (layers, hot water bottles, rugs and more layers). Kids started going to school few days back and they are loving it. I bought a bike and managed to go out on few rides on the hilly roads of Wellington and found a strange for sale sign too.

Anyhow, Since we didn’t have internet connection until today, I thought I will start by sharing a few Excel links with you. Check them out to get your fix of spreadsheets.

Read on…

First a little back story:

Last Friday (on 29th of July), we (Jo, kids & I) went on a day walk to Red Rocks. It is a rugged coastal walk near Owhiro bay in Wellington. It was a windy & cold day. So why did we brave the elements of nature on this 10km walk? To see seals of course. And we did find a few of them. We also caught glimpses of snowy peaks in Southern Island of New Zealand.

3 Seals Excel Puzzle

Now I can’t take you on the same walk thru internet. There is no Excel function that can teleport you from your office (or home) to Owhiro bay. So I made the next best thing.

An Excel puzzle with 3 hidden seals.

Time for a quick personal update. We (Jo, kids & I) are moving to New Zealand on July 15th. We are going to Wellington and will be living there for next 2 years. New Zealand…Really? Why? How? To understand that, we need to go back in time, to EDATE(TODAY(), -75). In April 2010, I moved back to […]

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.

This week Excel turned 30. As per wikipedia,

Microsoft released the first version of Excel for the Macintosh on September 30, 1985

Let’s celebrate 30 years of Excel by reliving your first memory of it. Share your earliest memory of Excel in the comments section.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 44th session of Chandoo.org podcast, let’s talk about failures.

What is in this session?

In this podcast,

• Book announcement about Dashboards for Excel
• Story of my first ever dashboard
• Important lessons – Requirement Analysis for dashboards
• Resources for creating awesome dashboards
  • Podcasts
  • Books
  • Courses

Wow, what a month it has been. In August 2015, I announced Awesome August, an Excel festival. I published 31 articles, one for each day of August to make you awesome in your work. We had  3 podcasts, 11 videos, 17 articles and 238 comments in August. This content is consumed by more than 50,000 people from all over the world (3% of site traffic visited Awesome August pages). There were lots of emails, tweets and facebook posts telling me how you are enjoying Awesome August.

Thank you so much for taking time to learn from Chandoo.org and making Awesome August a success.

I made a short (5 mins) video to share the journey and to say thanks to you personally. Please watch it below.

Note: This is a not an Excel tips post. It is a dairy of one of the most awesome conferences I have ever attended.

I just finished attending PASS Business Analytics conference in Santa Clara (USA) and am now heading back home to India. And it has been one of the most fun, uplifting and educational experiences of my life. I met so many remarkable people in this trip.

Read on for some pics & gossip.

Today is Holi, the festival of colors in India. It is a fun festival where people smear each other with colors, water balloons, tomatoes and sometimes rotten eggs. This year we wanted to play with only water guns, but kids vetoed that idea vehemently. So we ended up driving to my sister-in-law’s place to play with colors (there were no rotten eggs or tomatoes, thankfully).

Let me smear a few colors on you

I would love to splash a jug full of color water on you and say Happy Holi. But the internets have not advanced thus far. So I am going to give you the next best option.

An Excel workbook to play holi

2014 has been the most awesome year since starting Chandoo.org

Thank you so much for making it happen. This year, more than 10 million people visited our site, learned something and took first step to become awesome in their work. Each & every day of 2014 felt invigorating, exciting & blessed. I could meet 100s of you face to face during my travels to Houston & Dallas in September this year.

A big thanks to you, my reader, for supporting me and choosing chandoo.org as partner in your journey to awesomeness.

Apart from our readers, there are also countless people, websites, books, companies which helped me have a fantastic year. This message is my way of saying thanks to them.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

A big, warm & pleasant hello to you.

I wish you a merry Christmas & Happy New Year 2015. 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. 2014 is the most successful year since starting Chandoo.org, all thanks to you. Heartfelt thanks to you, from my family, staff and volunteers.

About this year’s holiday card

We took this picture recently when we went to Udaipur (a city in northern India). For a change, no one closed their eyes when the camera clicked.

A holiday gift for you…

Read on to download your special holiday gift.

Hello awesome folks. It has been a while since I posted on Chandoo.org. And there is a reason for that. As you may know, recently (on October 12^th) a category 3 cyclone (hurricane) passed thru our city devastating trees, power lines, cellular towers, old houses & roads on its way. This means our family was left without power, water, telephone and internet for almost 10 days. Early last week we got power & water. Then slowly the internet started working too. (more on this here)

I am swimming thru heaps of email & backlog work. Thanks to everyone who emailed me with kind thoughts, prayers and love. I can’t tell you how thankful I am for having you in my life.

I am really glad to be back online, sharing my stories, knowledge & tips with you all.

As it has been a while, I want to share a few quick announcements first.

Podcast: Play in new window | Download

Subscribe: Apple Podcasts | Spotify | RSS

In the 23rd session of Chandoo.org podcast, lets talk about my experience with Hudhud cyclone.

Note: This podcast session has no Excel tips. It is a story of how our family is surviving the effects & aftermath of destructing Hudhud cyclone that recently (on 12th October) passed thru our city. Hopefully, you still find it interesting & inspiring. If you are expecting some Excel tips, check again next week.

What is in this session?

Growing up, I lived all my childhood in coastal cities. So cyclones & severe storms are not new to me. But first time, I have experienced anything as severe, destructive & long as Cyclone Hudhud. After the cyclone, we (our family and 1000s of other families in Vizag, our city) had to endure days with no power, water, cellular signals and access to essential supplies. Fortunately, great progress has been made in the last few days and things are restoring to normalcy. We (our locality) is expecting to have power & regular water supply by this Sunday (19th of October).