by Ilker | Jan 30, 2019 | Excel Tips & Tricks
Nested IF statements are useful for creating more complicated scenarios in Excel. However, IFS and SWITCH formulas can work more efficiently when dealing with more than one condition. These formulas work a bit differently than the legacy IF function. Let’s start...
by Ilker | Jan 30, 2019 | Excel Formulas
The MIRR Excel function is a finance function that calculates the modified internal rate of return (MIRR) for a series of periodic cash flows. This function works by using both the cost of the investment and the interest received by reinvesting the cash. In this...
by Ilker | Jan 30, 2019 | Excel Formulas
The XIRR function is a finance function that calculates the internal rate of return (IRR) of a series of non-periodic cash flows. This function works like the IRR function, but doesn’t require entering regular intervals. In this guide, we’re going to show you...
by Ilker | Jan 30, 2019 | Excel Formulas
The IRR Excel function is a finance function which can calculatee the internal rate of return (IRR) of a series of periodic cash flows. The function assumes that the cash flows occurs at regular intervals. In this guide, we’re going to show you how to use the IRR...
by Ilker | Jan 29, 2019 | Excel Formulas
The XNPV function is a finance function which can calculate the net present value (NPV) of a series of non-periodic cash flows, based on a specified discount rate. In this guide, we’re going to show you how to use the XNPV function and also go over ome tips and error...
by Ilker | Jan 29, 2019 | Excel Formulas
The Excel NPV function is a finance function that calculates the net present value (NPV) of a series of cash flows based on a specified discount rate. In this guide, we’re going to show you how to use the Excel NPV function and also go over some tips and error...
by Ilker | Jan 29, 2019 | Excel Tips & Tricks
Conditional Formatting is commonly used to highlight data fields to easily identify outliers, or narrow down the results. However, this feature works a bit differently when dealing with a Pivot Table. Pivot Tables are also dynamic elements, and conditional formatting...
by Ilker | Jan 28, 2019 | Excel Formulas
Excel EXACT function compares two strings and returns TRUE for a perfect match, and FALSE if not. Note that this comparison is case-sensitive. In this guide, we’re going to show you how to use Excel EXACT function to compare strings and also go over some tips and...
by Ilker | Jan 24, 2019 | Excel Tips & Tricks
Comparing the data in two different columns is a frequently used method in data analysis. In Excel, you can compare using formulas or highlighting. In this guide, we’re going to show you how to compare two columns in Excel using these two methods.Compare two columns...