fbpx

All articles with 'personal' Tag

50% done – mid year updates for 2020

Published on Jul 2, 2020 in personal
50% done – mid year updates for 2020

Hello folks. 50% of 2020 is behind us. Let me share a few updates with you all. First check out this awesome double rainbow outside our house on 30th June. MVP I am thrilled and humbled to tell you that I have been re-awarded Microsoft MVP for 2020 year. This is my 12th year in […]

Continue »

Celebrating 50k Subscribers on YouTube + Give away

Published on May 25, 2020 in personal
Celebrating 50k Subscribers on YouTube + Give away

Hiya folks… Got an exciting news to share with you all. Over the weekend, my YouTube channel hit 50,000 subscriber milestone.

Thank you so much for making me a part of your journey to awesomeness.

Continue »

A quick personal update

Published on Mar 23, 2020 in blogging, personal
A quick personal update

How are you? I want to say hello and check in with you in these strange and scary times.

Continue »

Merry Christmas & Happy New Year 2020

Published on Dec 24, 2019 in personal
Merry Christmas & Happy New Year 2020

Hello readers,

On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2020. Here is a small holiday card from Chandoo.org HQ. This year, we have a new addition to our family – Excel, bichon-poodle puppy has been with us for a little over one month and already became a big part of our lives.

Continue »

How to trace precedents in Excel formulas? [tip+music from Prague]

Published on May 22, 2019 in Excel Howtos
How to trace precedents in Excel formulas? [tip+music from Prague]

Here is a very useful and almost secret Excel tip for you. Imagine you are looking at a big, complex workbook with lots of calculations. You want to understand where everything is pointing to and how the workbook is set up.

You can use trace precedents in Excel to do this. Read this tip to learn how it works.

Continue »

Excel School v2.0, blogging schedule, personal life – a quick update

Published on Aug 3, 2018 in blogging, personal
Excel School v2.0, blogging schedule, personal life – a quick update

Hi all,

Time for a personal + blog related update. Bring a cup of your favorite brew, sit back, relax and read on. Read about our 2 years in New Zealand, Excel School v2.0 and revised blogging schedule. Catch glimpses of our live in NZ too.

Continue »

How to undo in Power Query [Quick Tip]

Published on Jun 22, 2018 in Power Query
How to undo in Power Query [Quick Tip]

Ever wondered how to undo in Power Query. If you try to press CTRL+Z or look for undo icon in Power Query (either in Excel or Power BI), you will not find it. The reason is simple. There is no undo in Power Query. So how to undo ?

Continue »

Merry Christmas and Happy New Year 2018 [Holiday Card]

Published on Dec 22, 2017 in personal
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.

Continue »

Thank you, we have a home in New Zealand

Published on Nov 22, 2017 in personal

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.

Continue »

Start your bar charts from zero – Excel geeks screaming at you from mountain top

Published on May 15, 2017 in Charts and Graphs
Start your bar charts from zero – Excel geeks screaming at you from mountain top

Here is a simple but vital charting rule.

Start your bar (or column) charts from zero.

To illustrate why you should do this, let me share a personal example.

Over the weekend, the Jon Peltier visited Wellington. He is staying with Jeff (who occasionally guest blogs on Chandoo.org). On Sunday, we all decided to hike up a small mountain near my house for a leisurely family picnic.

While on the top of the mountain, Jo (my wife) took a few pics of us three Excel geeks.  As we were standing on a sloping mountain face this is how the pictures look.

Looking at the picture on left, you would confidently say that I am way shorter than other two. But picture on right tells a different story.

Continue »

There are 5 hidden cells in this workbook – Find them all [Excel Easter Eggs]

Published on Apr 14, 2017 in Excel Challenges
There are 5 hidden cells in this workbook – Find them all [Excel Easter Eggs]

It is Easter time, and that means time for another fun Easter Egg hunt in the spreadsheet. For the last 8 years (since 2009), I have been running Easter Egg hunt at Chandoo.org. This year too, I have prepared an exciting egg extraction enigma for you. Check it out.

Can you find all the 5 hidden cells in this workbook?

First step. Download this workbook. There are five worksheets, each containing one egg. You need to find the hidden cell in each worksheet.

Continue »

Merry Christmas & Happy New Year 2017 [Holiday Greeting]

Published on Dec 23, 2016 in personal
Merry Christmas & Happy New Year 2017 [Holiday Greeting]

A big, warm & pleasant hello to you.

I wish you a merry Christmas & Happy New Year 2017. 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. 2016 has been a remarkable year in our journey and I owe this to you and your support.

Continue »

A quick tip about data analysis while on bike [Video + Personal]

Published on Oct 3, 2016 in Pivot Tables & Charts
A quick tip about data analysis while on bike [Video + Personal]

Wellington(NZ) sure is beautiful on a clear day. There are so many cool bike tracks, walking trails and beaches to keep you busy. Today, I went cycling on my usual route towards Makara beach. At the turn off point, I thought, “This is selfish. I can’t keep all this beauty to myself. I must share it with you.” So here we go.

A quick video about data analysis while on bike

Technically, I was not on bike when recording this video.  Watch it below or on our YouTube Channel.

Continue »

Check if a range has all numbers from 1 to n [Homework]

Published on Sep 30, 2016 in Excel Challenges, Learn Excel
Check if a range has all numbers from 1 to n [Homework]

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 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.

Continue »

Excel Links – Getting used to life in Windy Wellington Edition

Published on Aug 10, 2016 in excel links, personal

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.

For sale: Pony poo and pine cones

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…

Continue »