Triangular plot…! What is it?
Recently, a Chandoo.org forum member asked this,
‘I want to be able to make a graph that, in some aspects, looks like below, but I have no idea how to do it at all.’
After seeing it, I said to myself in Barney Stinson’s tone, ‘Challenge Accepted!‘
The final plot looks like above. Read on to learn how this is made.Continue »
I have a confession to make.
I am not sure how to describe this new thing I made in Excel / VBA. So first take a look at it.
Read on to learn how you can create something like this using Excel & a little bit of VBA.Continue »
Our holiday sale for 2013 is now live. Click here to purchase your favorite Excel, advanced Excel, dashboards & VBA courses at discount.
What is this holiday sale?
Two of our most popular, awesome & valuable courses are on sale.
- Excel School & Dashboards program – Save $30
- Excel School, VBA & Dashboards program – Save $50
Our customers from India save Rs 1,200 & Rs 2,000 respectively.Continue »
Here is a quick announcement folks!
Many of you asked me whether we are going to have a holiday sale at Chandoo.org this year. Of course we have a sale!
Details of Chandoo.org Holiday Sale – 2013
Dates of the sale – 4th & 5th December, 2013 (Wednesday & Thursday)
You can save up to $50 in this holiday sale.Continue »
It is thanksgiving week in USA, which means our friends & readers in America are enjoying a fun long weekend with family & friends.
Happy thanksgiving day to you and your family.
Since most of our readers will be enjoying the holiday, I want to save Excel awesomeness for next week. Meanwhile, lets have our very first Ask me anything [AMA].
Ask me anything.. what is it?
It is very simple. In the comments section, you can ask me anything. I will reply to you.
Anything from Excel to my life, SUMPRODUCT to C23.. you get the drift.Continue »
In this episode of Formula Forensics, lets talk about how to build a model where costs vary per year and age. In this example, we are talking about a plantation project. The costs & yields of plants vary by the year they are planted in and the age of plants. In this case, how do we calculate the total costs or returns with formulas?
Here is a handy trick to calculate last day of any month.
Assuming y and m contain the year & month for which you want to find the last day’s date, write
That is right, you can use ZERO (0) as the day.
When you do this, Excel tells us the last day of previous month.Continue »