Happy New Year to all our readers. Let’s kick start 2020 with an awesome calendar, daily planner and monthly calendar template. Please visit the post page to download the 2020 Calendar Excel Template.Continue »
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 »
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 »
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 »
Introduction to Power BI – What is it, how to get it, how to create reports with Power BI and how to publish them?
Power BI is a data analytics & visualization software. It is one of the most popular and powerful way to work with complex business data. In this page, you will find a comprehensive guide to start your Power BI journey.Continue »
It’s Halloween time. As adults, we can’t go trick or treating. We can of course dress up in costumes and entertain others. But what about the poor spreadsheets. Don’t they deserve some of this fun too?
Hell yeah! So I made a spider web generator in Excel. Just use it to make a spooky cob web pattern and add it to your report / dashboard / time sheet or whatever else. Surprise your colleagues.Continue »
Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. In this page, learn how to,
- Introduction to IRR & XIRR functions
- Calculate rate of return from a set of cash-flows with XIRR
- Simulating purchase or terminal value changes with data tables
- Apply conditional formatting to visualize the outputs
- Common issues and challenges faced when using XIRR