Archive for December, 2019

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 »Come and learn from me in London – April 2020

Hello readers, I have an exciting announcement for you.
I will be presenting at two events at London in April 2020. Please consider this my personal invitation and join me for Excel + Power BI fun.
Continue »![Filter as you type [Quick VBA tutorial]](https://chandoo.org/wp/wp-content/uploads/2015/08/filter-as-you-type.gif)
Filtering a list is a powerful & easy way to analyze data. But filtering requires a lot of clicks & typing. Wouldn’t it be cool if Excel can filter as you type, something like above.
Let’s figure out how to do this using some really simple VBA code.
Continue »