Absolute Referencing in Excel – Usage with Examples
In the previous blog, we understood the usage of Relative Referencing. We highly recommend reading the Relative Referencing before jumping to Absolute. The second referencing… Read Article
Functions
This category is dedicated to covering all the functions and formulas of Excel.
Relative Referencing in Excel – Types of References
References form the base for using the formulas and functions in excel. If one wants a good grip on excel, then they must know the… Read Article
STDEV.P Function in Excel – Uses, and Examples
The STDEV.P Function in excel is one of the most useful statistical functions in excel. It is used for the whole population. Let us see… Read Article
ISPMT Function of Excel – Interest Amount Keeping the Principal Constant
In our earlier blogs, we learned the usage of the IPMT Function to get the interest amount when the payment ( principal+interest ) was constant… Read Article
NPER Function in Excel – Calculating Number of Periods
When taking a loan, one must be willing to know how many payments will he/she have to pay in total to pay for the loan… Read Article
MIRR Function in Excel – Modified Internal Rate of Return
MIRR Function in Excel is a modified form of IRR. IRR considers that the money reinvests at the same discount rate. In finance, most of… Read Article
XIRR Function in Excel – IRR for Irregular Cash flows
In our previous blog, we learned the IRR Function of Excel. In Finance, whenever we want to get the IRR when consecutive cash flows have… Read Article
IRR Function in Excel – Internal Rate of Return
Whenever a business is willing to invest in a project, it makes sure if it is a profitable investment or not. Let us say project… Read Article
PMT PPMT IPMT Functions of Excel – Usage
The PMT, PPMT, and IPMT functions in excel are the three financial formulae in excel. These three function are quite related to each other. While… Read Article
FV Function of Excel – Find Future Value of Investment
When working with finances, we might feel the need to know the future value of a business investment after a certain period of time having… Read Article
AMORLINC Function of Excel – Finding the Depreciation of as Asset
Depreciation means the decreasing of the worth of an asset with time due to its wear and tear. Any valuable thing costs the original price… Read Article
CHOOSE Function in Excel – Choosing Value according to Index
The CHOOSE function is a very powerful function of Excel. The function is used in many cases like creating raw data for dashboards, to get… Read Article