Archive for June, 2010
Here is a really tricky problem. Recently I was given a data set like this (shown below) and asked to find the position of lookup value in the list. The only glitch is that, instead of values, the lookup table contained lower and upper boundaries of the values. See the below illustration to understand what […]Continue »
Ok, this is bound to happen. After regularly writing for about 2 years now, I have decided to revise posting schedule on Chandoo.org. Usually I write 5 posts per week (about 21-22 per month). While I have not ran out of ideas yet (my notebook still has 94 different ideas yet to become posts), I […]Continue »
Okay folks, sorry I took quite awhile to post this. But I was busy with excel school and getting my kids buzz cut. So here you go. Contest winners – India Paresh shah (website) Abhishek Jain Rahul Mulchandani (website) Contest winner – International Tom (this Tom) Congratulations Winners. You will very soon hear from me […]Continue »
Checking if a value falls between 2 other values is fairly common when you are working with data. In today’s quick tip, we are going to learn how to check for such between conditions in excel. You will be learning how to check if a value, date or text falls between 2 other values, dates or texts (when arranged in dictionary order) as shown in the picture aside.Continue »
Here is an interesting use of Excel. Use it to design User Interface Prototypes. A UI Prototype is one of the steps we do while developing systems. It contains a clear and detailed user interface mocked up so that we can clearly find-out how end-users would react to such a system. Now, there are a […]Continue »
Those of you reading the blog for the last few months would know that I manage 2 more super-fast growing ventures. They are called Nakshatra and Nishanth. Our twin babies. They are in to 9th month now (born on September 24th last year).
It is fairly common for kids in this part of the world to get rid of their birth hair around this time. So we took the kids to a near by temple to get them tonsured. I want to share a few pics with all of you.Continue »
PS: Today is the last day for joining excel school. So bear the promotional messages. Skip this post if you are already sold or not going to buy.
I gave free excel school passes to few of the people I respect and learn from. You see, I have worked mostly alone on Excel School and while the first batch students were very happy with what they got in the school, I wanted to be doubly sure that Excel School is an excellent value for money and nothing short of an awesome program. So I gave free passes to people I truly admire, to know what they would think.
Read this short post to find out what they think about Excel School.Continue »
As you may know, I run an online excel training program, called as, Excel School. I have opened registrations for 2nd batch of this program on last Monday. Thank you very much for supporting this program wildly. In a few hours, I will be closing the registrations for Excel School.
At the time of writing this post (around 9 AM IST on 21st), we have 103 students signed up for Excel School. This is certainly a bit more than what I expected. But, I am also confident and eager to help as many of you as possible. So go ahead and join the program, because, you want to be awesome.Continue »
Hui, one of our in-house excel ninjas at Chandoo.org Forums, has asked an interesting question. Microsoft is already planning the next version of Excel and is looking for our feedback into what extra chart types it should offer/include. [more] It is an interesting question, so lets have a poll. What new chart types you prefer […]Continue »
Comparison of lists of data is something that we do all the time. Today, lets learn a few tricks that you can apply immediately to compare 2 lists using Excel. We will learn how to compare 2 lists of data in 3 + 1 different ways. (click on links to jump to that section of […]Continue »
Excel School 2nd edition seems to be rocking already. Here is a quick update: So far 50 students have signed up for Excel School. The classroom is busy too. We have 40 comments so far and some interesting questions from new students. Excel School Review by Debra: I gave a free student account to Debra […]Continue »
Like most of the small businesses, I too use Excel for running various activities including preparing quotations, estimates and pricing models. In this post you can find a couple excel quotation templates that you can immediately use.
The first template is useful for sending quotations for one time work or services.
The second template is useful for sending quotations for hourly work like repairs, services, consulting.
Go ahead and download these excel quote templates to prepare beautiful quotations right from your favorite program.Continue »
Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.
What is weighted average?
Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”
Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.Continue »
Folks… I have an exciting news.
Excel School 2nd batch is now officially open.
In this post, you can find some information about Excel School and links to sign-up for the program. Read on, if you want to be even more awesome in Excel.Continue »
Today FIFA World-cup 2010 is beginning. For the next 30 days or so, no matter where you go, you are bound to hear about soccer, world cup, teams, points, goals and what not. As a tribute to this beautiful and lovely sport, I want to showcase some really awesome excel spreadsheets that are designed to […]Continue »