A Technique for Analysing Large Tables of Data
Once you start using Excel to develop systems, budget, forecast and large tables of data you may come across the dilemma of “How do I know this is right” or “How do I truth check this”.
This post will add a tool to your arsenal to help you out.
Excel Links – Happy Birthday Edition
First some personal matters. Today I am celebrating my 28th birthday. The last one year has been very good for us. We have been very busy parenting 2 hilarious and naughty twins, I moved back to India, quit my job and started a company. My business became a mild success crossing $100k revenues in 12 […]
Bad News & VLOOKUP Contest
Hello Folks.
I have a rather bad news for you. My internet service provider (TATA Photon) has mysteriously blocked chandoo.org. My site hasn’t been loading since Sunday. While, I know it is up and running, I cannot see it unless I go thru a proxy server.
It may take a few days to get this resolved. I am using this time to take a break from blogging and finish reading a few books.
But I have a contest for you that will keep you busy. Share your favorite VLOOKUP tip / trick and you can win an iPod Nano. Read more for rules & how to participate.
Remove duplicates & sort a list using Pivot Tables
Removing duplicate data is like morning coffee for us, data analysts. Our day must start with it. It is no wonder that I have written extensively about it (here: 1, 2, 3, 4, 5, 6, 7, 8). But today I want to show you a technique I have been using to dynamically extract and sort […]
Make your data validations dynamic! [quick tip]
Ok, since excel school 3rd batch is going to open on 15th, I wasnt going to write anything today. I have slept just 4 hours last night, blame it on work (and that funny video on youtube). But I found 30 minutes free time, so here you go, a quick but delicious tip on making your data validation dynamic.
Dynamic Data Validation?!? What in the name of slice bread and peanut butter is that?
See the demo aside to understand and read on to master the trick.
9 Excel Tips & Downloads Submitted by Our Readers [Reader Awesomeness Week]
Last week I announced Reader Awesomeness Week to celebrate the passion, attitude and knowledge of our little community here. I got 9 interesting and beautiful entries from our readers. In this post you can see 9 tips & downloads submitted by our readers. These include a project management template, a macro to remove blanks, a technique to make Google Earth maps using Excel and several other interesting tips & tricks.
Go ahead and read them, download attached workbooks and become awesome in Excel. 🙂
How Francis Landed on Chandoo.org, Become Awesome and Made a Superb Dashboard, all in ONE Weekend
As part of our Reader Awesomeness Week, Francis shares with us a travel site dashboard he made for his company. Francis took just two days to prepare this awesome dashboard which uses concepts like bullet charts, sortable KPI grid, Date based filtering, dynamic charts and more. I was really moved by Francis’ gesture in sharing his work with us, so much that, I did a video review of his work. You can see it in the embedded youtube video to the left.
Read the rest of the article to know how this dashboard is made and get a copy of the file.