5 Rules for Making Better Charts (and one fun chart)
Jeff Weir, an alert reader of this blog points me this chart showcasing voice-over artist’s for various Simpson’s characters. I am a hard-core Simpon’s fan, so I naturally wasted quarter-hour looking at the chart. That is when I realize this chart is not only fun, it also teaches 5 valuable lessons on making better charts. Read the rest of this post to find out the five rules.
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
Building a Layout for Project Evaluation Model & Best Practices [Part 2 of 6]
In the second part of our tutorial we will learn how to prepare the layout of our model to do project evaluation.
If you know basic referencing and formula framework in excel, you can write a model that calculates numbers. Good vs Bad financial model would be decided by the layout of the model.
Before we start discussing on how to build a good layout, lets see the layout that I have in mind. The layout is based on my experience of working as an investment banker and as a consultant and I find it neat.
How to show Indian Currency Format in Excel?
This is a guest post by our excel ninja – Hui. Today we will learn how to format numbers and amounts in Indian currency format. Indian numbers are grouped differently than standard English numbers. English Grouping 123,456,789.01 Indian Grouping 12,34,56,789.01 Quick and easy fix to show numbers in Indian format: A custom number format of: […]
7 Links and One Question for You
Darren writes one of my favorite blogs – Problogger, it is a blog about blogging. It is super helpful for people like me who write, connect, share and sell online. A week back, Darren asked his readers to participate in a fun experiment by posting 7 links on their blogs. It seemed like an interesting […]
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!
Select Expressions to Find their Values [Macro Debugging Tip]
Here is a quick macro tip that I stumbled on to while debugging some code yesterday (ya, ya, call me workaholic for coding on a weekend…) You can select expressions in your code and place mouse pointer on that for a second to find what value it evaluates to (of course, this works only on […]