You have a need to select A1 to A10. This is a very easy job to do. Suppose, you need to select A1 to A10000. Now, it becomes more cumbersome. Suppose you need to select E23 to AB4325. It is all the more cumbersome job for you. Approach 1 – Put the range in Name…
Category: Tips and Tricks
Tips & Tricks 93 – Sorting from Left to Right
Generally, we do sorting in a column from top to bottom. But, what happens if the data is in rows. Then you will have to sort from left to right. This is possible in Excel. 1. Select your data in the row. 2. Data tab> Sort OR Home tab > Sort & Filter OR ALT+DS…
Tips & Tricks 92 – Financial Function – Calculate Effective Interest
You are applying for a loan and an interest rate has been quoted. The interest rate which is quoted is called "Nominal Interest Rate". They will quote Nominal Interest Rate in yearly terms. Hence, if they quote 12% interest for a loan, this is yearly figure. Now, you generally pay EMIs every month. They simply…
Tips & Tricks 91 – Financial Function – Calculate Compounded Interest
As part of our Mathematics courses in our childhood, we had learned about Compounded Interest. The famous formula which we remember is Compounded Balance = Principal x (1+rate)^N
Tips & Tricks 90 – Financial Function – Calculate Interest Rate
You want to take a loan. You know how much loan to take (pmt), you know how many months you want to pay up (nper) and you want to know effective rate of interest. Excel makes it easy to do. RATE function is the answer for this.
Tips & Tricks 89 – Financial Function – Calculate Number of EMIs to Pay Up a Loan
You have taken a loan and you know your EMI capability. So, you want to know how many months will be taken to pay off a loan completely. It is fairly easy job to do it in Excel. You will need to use NPER function for this.
Tips & Tricks 88 – Financial Function – Calculate Principal Part of an EMI
This Tips and Tricks is in continuation of Tips & Tricks 84 – Financial Function – Calculate EMI. Now the EMI for a month = Interest for that month and Principal for that month. IPMT is used to calculate the interest portion of your EMI. This I talked about in Tips & Tricks 87 –…
Tips & Tricks 87 – Financial Function – Calculate Interest Part of an EMI
This Tips and Tricks is in continuation of Tips & Tricks 84 – Financial Function – Calculate EMI. Now the EMI for a month = Interest for that month and Principal for that month. IPMT is used to calculate the interest portion of your EMI. Excel defines IPMT as "Returns the interest payment for a…
Tips & Tricks 86 – Quickly Access AutoSum
Autosum is a much widely used feature in Excel. It is available in two places in Excel 2013. One in Home tab and one in Formulas tab. You can quickly access the AutoSum by the shortcut key ALT+
Tips & Tricks 85 – Show Comments Always
You put a comment in Excel and it puts a red triangle in the top right corner to indicate that there is a comment. But sometimes, it is necessary that comment should be visible when Excel is opened. This becomes very desirable feature when dealing with top executives. This is also a good feature to…