Last week I asked you “would you be interested in an online excel training program?” and quite a few of you have responded with “YES”.

So I decided to start excel school. This is a 12 week online training program that will explain various MS Excel concepts to you in an easy to understand format. I am calling it “school” because the program will be fun, exciting and playful – just like school. We will learn from each other as much as we learn from the course itself. Read the rest of the post to see “Excel School Intro” video.

Last week I have reviewed Google’s flu trends chart and told you that is it is very well made. Out of curiosity I made a similar chart in Excel. In this post, I am going to share the experience and results with you. Interested? Read on…

Most of you already know that using the REPT formula along with pipe (“|”) symbol, we can make simple in-cell charts in excel. For eg. =REPT(“|”,10) looks like a bar chart of width 10. Despite the simplicity, most people don’t use in-cell charts because these charts don’t look anything like their counterparts. But you can […]

Today we will build a mortgage payment calculator (and amortization schedule) using excel. But we will not build a boring excel sheet, we will build a mortgage calculator that is easy to play with.

A mortgage payment is a monthly installment that you pay towards a loan. Any mortgage loan will typically have, (1) loan amount, (2) duration of the loan in years, (3) interest rate per year

Given these 3 parameters, we can easily determine the monthly installment amount (this will be the same amount for all months during loan tenure)

We are going to use Excel’s form controls (more on this below) to build a mortgage payment calculator like this.

Today we will learn to use Excel’s LEFT and FIND formulas. But what fun it is to learn a new formula on a Tuesday? So, we will actually learn to use these formulas to solve the problem: “extract the username from an email ID” How is an email ID structured? Any email ID contains 2 […]

Finally, our second visualization challenge comes to an end. We got a winner. Background about Zoho Reports Visualization Challenge: (skip this section if you know what I am going to say) Back in November, 2009, I have asked the readers to come up with best possible ways to visualize a set of fictitious sales data. […]

Ok, I need some quick feedback here. For the last few months I have been thinking and planning to launch an online excel training program. And I want to know if YOU are interested in one. Read the rest of this post if you are curious.