2012 has been the most awesome year since we started Chandoo.org.
The credit for this goes to our community of Excel users – that is you.
For practically every day of 2012, you have inspired me (and all of us at Chandoo.org) to learn something new, share and make you awesome. I know I say this many times, but I can never feel enough – Thank you for your support to Chandoo.org.
Apart from you, there are many other amazing people & companies that played a role in our success. In this post, let me highlight them & express my sincere gratitude.Continue »
Here is a New year gift to all our readers – free 2013 Excel Calendar Template.
This calender has,
- One page full calendar with notes, in 4 different color schemes
- Daily event planner & tracker
- 1 Mini calendar
- Monthly calendar (prints to 12 pages)
- Works for any year, just change year in Full tab.
We wish you a merry Christmas & very happy New Year 2013. May your holidays be filled with joy and warmth. And your new year with lots of hope, fun, strength and awesomeness.
I also want to tell you how thankful & fortunate I feel to have your support in this year. Your desire to learn Excel & become awesome at your work motivates me everyday to learn & share. 2012 is a memorable year because of you. Thank you.Continue »
Recently, I wrote a tutorial on tax burden in USA chart.
Jared, One of our readers liked this chart very much. Jared works as a workforce scheduler and has data similar to our chart. So he applied the same technique to analyze monthly service levels for last 7 years & sent me the file so that I can share it with all of you.
First take a look at the demo of Jared’s chart. And read on to know how this works.Continue »
Rama, one of our readers emailed this:
I Have Many List boxes In That I need to Hide Few Of them Using Check box
Show Hide list boxes by using a check box
We can use check box and a bit of VBA to do this easily. Something like above demo.
Read on to learn how to do this using Excel & VBA.Continue »
Are you ready for an Excel challenge?
Today, your job is very simple. Just find a pattern in a text and return corresponding value.
In a range we have some resource types & their billing rates.
In another range, we have some descriptions. Each description contains a resource type somewhere inside it. We need to retrieve billing rate for each description by looking up which resource type is mentioned in it.
See above diagram.Continue »
When analyzing business data like sales, shop visits or productivity, one of the questions managers always ask is,
What is the best month / week for this data?
To answer this question, we need to make a chart that looks like above. Today, lets learn how to highlight portions of such charts that correspond to best week or best month.Continue »