Fix Incorrect Percentages with this Paste-Special Trick
Sometimes we get values in our Excel sheets in such a way that the % sign is omitted. So instead of the value being 23%, it is 23. Now, you can very easily correct this by editing the cell and adding a % sign at the end. But what if you have 100s of rows of data. You can’t do this to every cell. (You can not just format the cells to % format either, excel shows 23 as 2300% then). There must be some simple and intuitive solution for this … umm.
Pivot Table Tricks to Make You a Star
We, data junkies, love pivot tables. We think pivot tables are solution for everything (except for may be global warming and that broken espresso machine down stairs).
Today, we are going to learn 5 awesome pivot table tricks that will make you a star.
Delete Blank Rows in Excel [Quick Tip]
Blank rows or Blank cells is a problem we all inherit one time or another. This is very common when you try to import data from somewhere else (like a text file or a CSV file). Today we will learn a very simple trick to delete blank rows from excel spreadsheets. Read this post to findout how to delete blank rows / cells from your excel data in a snap.
Excel School Online Training – More Details
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.
Flu Trends Chart in Excel [Yes, we can edition]
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…
Use “Playbill” font to make your incell charts realistic [quick-tips]
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 […]
Interactive Mortgage Calculator to know how much you can borrow (with Excel)
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.