Archive for June, 2010

Range Lookup in Excel [Formulas]

Published on Jun 30, 2010 in Learn Excel
Range Lookup in Excel [Formulas]

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 »

Excel Links – Change in Posting Schedule Edition

Published on Jun 28, 2010 in excel links
Excel Links – Change in Posting Schedule Edition

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 »

Office 2010 Contest Winners are here!!!

Published on Jun 25, 2010 in blogging, Excel Howtos
Office 2010 Contest Winners are here!!!

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 »

Between Formula in Excel [Quick Tips]

Published on Jun 24, 2010 in Excel Howtos
Between Formula in Excel [Quick Tips]

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 »

Use Excel For Rapid UI Prototypes [Awesome uses of Excel]

Published on Jun 23, 2010 in Learn Excel
Use Excel For Rapid UI Prototypes [Awesome uses of Excel]

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 »

A Hairy Update [personal]

Published on Jun 22, 2010 in personal
A Hairy Update [personal]

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 »

Excel Heros who Reviewed and Recommending Excel School

Published on Jun 21, 2010 in products

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 »

Excel School Closing in a Few Hours – Join Now!

Published on Jun 21, 2010 in Learn Excel, products
Excel School Closing in a Few Hours – Join Now!

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.

Click here to sign up 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 »

What new chart types you want to see in Excel? [poll]

Published on Jun 18, 2010 in Charts and Graphs
What new chart types you want to see in Excel? [poll]

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 »

Become a Comparison Ninja – Compare 2 Lists in Excel and Highlight Matches

Published on Jun 17, 2010 in Excel Howtos, Featured, Learn Excel
Become a Comparison Ninja – Compare 2 Lists in Excel and Highlight Matches

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 »

Super-mini Quick Update on Excel School

Published on Jun 17, 2010 in products
Super-mini Quick Update on Excel School

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 »

Excel Quotation Template [Spreadsheets for Small Business]

Published on Jun 16, 2010 in excel apps
Excel Quotation Template [Spreadsheets for Small Business]

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 »

Weighted Average in Excel [Formulas]

Published on Jun 15, 2010 in Learn Excel
Weighted Average in Excel [Formulas]

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 »

Join Excel School Today

Published on Jun 14, 2010 in Learn Excel, products
Join Excel School Today

Folks… I have an exciting news.

Excel School 2nd batch is now officially open.

If you want to know more about the program and join, head over the Excel School page.

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 »

FIFA Worldcup Excel Spreadsheets [Roundup]

Published on Jun 11, 2010 in Charts and Graphs, excel links
FIFA Worldcup Excel Spreadsheets [Roundup]

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 »