12 Rules for Making Better Spreadsheets
As part of reader awesomeness week, today I am featuring a list that Larry sent me with 12 beautifully defined rules for making better spreadsheets. He says that spreadsheets should be easy to understand, have a clearly defined purpose and should use Excel features as much as possible. I totally agree with him.
Read the rest of this post to find the rules and download a poster containing these rules. Thanks Larry.
Introducing Excel Wedding Planner
About a month ago, I got an email from Kevin. The crux of this email is,
I am working on a wedding planner based in Excel. Do you want to collaborate?
I replied to him asking for more details as I got curious about the project. Kevin sent me a work-in-progress version of his wedding planner which blew my mind. Although I have only one wedding experience and even that I hardly planned (as it is traditional for parents to take care of the wedding ceremonies in India), I found Kevin’s planner quite comprehensive, useful and easy.
So we worked on it together and I am happy to announce the Excel Wedding Planner
Introduction to Financial Modeling using Excel [Part 1 of 6]
In this and next 5 posts, we are going to learn how to build a financial model to do project evaluation using Excel. The 6 parts of this tutorial are,
- Introduction to Financial Modeling
- Building a layout for Project Evaluation Model – Best practices
- Building Inputs and Assumptions Sheet
- Building Projections for Project Evaluation
- Modeling the Cash Flow Statement and Projections
- Putting it all together – Final Project Evaluation Model
What is financial modeling?
Financial modeling is creating a complete program/ structure, which helps you in coming to a decision regarding investment in a project/ company. Now this could be on a simple piece of paper or in excel. The advantage with excel is that, even if you have calculation speed and accuracy like me (this is one place where I am like Einstien!), then also you would be able to come to the right conclusion!
Gantt Box Chart Tutorial & Template – Download and Try today
On Firday, we proposed a new chart for showing project plans. I chose an ugly name for it and called it Gantt Box Chart. Essentially, a gantt box chart is what you get when a gantt chart and box plot go to a bar, get drunk and decide to make out. It shows the project […]
Find-out Days Overlaped [Excel Formula Homework]
Few days back we have learned how to find if 2 sets of dates overlap using Excel Formulas. For eg. we have learned that to check whether {1 July,2010 to 23 July 2010} overlaps with the date range {15 July, 2010 to 16 August 2010}, we can use a formula like, =if(or(and(x>=a,x<=b),and(a>=x,a<=y)), “Overlap”,”Do not overlap”) […]
Do You Want to Learn Excel Financial Modeling?
Very Quickly, Chandoo.org is partnering with Pristine to start a free course on financial modeling using excel. If you are interested, take this short survey and tell us what topic you want to learn. Back Story One of the advantages of going to a premier MBA college is that you are bound to have good […]
Even Faster Way to Compare 2 Lists in Excel [Quick Tip]
Last week we discussed a fun and easy way to compare two lists of data in excel using conditional formatting. In that post, Artem commented, The quickest way to find all about two lists is to select them both and them click on Conditional Formatting -> Highlight cells rules -> Duplicate Values (Excel 2007). The […]