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 –…
Challenge 12 – Student Scoring Maximum Total Score
Download the file related to this problem from here Max Total Score Given the below grid, I need a formula in N2 and N3 which gives the name of the person scoring the total highest marks adding all subjects together. This, you need to do without a helper column. For example, in the below grid,…
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…
Excel Quiz 10
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+
Excel Quiz 9
Article 13 – Generate a Unique / Distinct List out of a List when no blanks in the list / range
Suppose you have a list as given below and now task before you is to generate a list of unique / distinct list from column A. We will also be looking into generating Unique values from Columns A, B and C together which can be generalized to any number of columns. Note – This article…
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…