by Ilker | Jun 13, 2019 | Excel Formulas
The Excel RRI function is a Financial function that calculates and returns the equivalent interest rate for the growth of an investment. When given a present value, a future value, and the number of periods for an investment, you can calculate the rate of return for...
by Ilker | Jun 13, 2019 | Excel Formulas
The Excel RATE function is a Financial formula that calculates and returns the interest rate for a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel RATE function and also go over some tips and error...
by Ilker | Jun 12, 2019 | Excel Tips & Tricks
Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. An Excel Table contains...
by Ilker | Jun 12, 2019 | Excel Tips & Tricks
Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. In this guide, we’re...
by Ilker | Jun 11, 2019 | Excel Formulas
The Present Value Excel function (PV) is a Financial formula that calculates and returns the present value of a loan or an investment based on constant payments, and interest rate. In this guide, we’re going to show you how to use the Present Value Excel function (PV)...
by Ilker | Jun 11, 2019 | Excel Formulas
The NPER function is a Financial formula that calculates and returns the number of repayment periods of a loan, based on constant payments and interest rate. In this guide, we’re going to show you how to use the Excel NPER function and also go over some tips and error...
by Ilker | Jun 10, 2019 | Excel Formulas
The PMT is a Financial function that calculates and returns the repayment amount of a loan based on constant payments and a constant interest rate. This formula is commonly used in amortization schedule Excel models. In this guide, we’re going to show you how to use...
by Ilker | Jun 10, 2019 | Excel Macros, Excel Tips & Tricks
Named ranges are cells, ranges, tables, formulas, or constant values that are represented with meaningful names, that are tied to their workbook reference (i.e. A1, B23, A1:B23). Using named ranges make formulas easier to read and maintain. In this guide, we’re...
by Ilker | Jun 10, 2019 | Excel Formulas
The ABS function is a Math formula that returns the absolute value of a given number. The absolute value of a number represents number’s distance from zero, regardless of the direction. This means that the distance of a number x has the same distance as negative...
