## IRR versus XIRR Excel Functions [Tutorial]

The IRR (Internal Rate of Return) Function is used to calculate the internal rate of return for a series, of given periodic cash flows. These cash flows do not have to be even, though...

The IRR (Internal Rate of Return) Function is used to calculate the internal rate of return for a series, of given periodic cash flows. These cash flows do not have to be even, though...

The Body Mass Index (BMI) is used by nutritionists and other health scientists, in order to give an indication of the body fat of an individual. It is based on the weight of an...

We have already seen how to use the PV Function, the FV Function and the PDURATION Function in a previous tutorial. We have also seen how to calculate NPV and XNPV and the difference...

The NPV (Net Present Value) Function is used to calculate the net present value of an investment by evaluating a provided discount rate, a series of future payments (negative values) and income (positive values)....

The PV Function, FV Function, and PDURATION Function are all extremely useful financial functions. The Present Value (PV) Function is used to calculate the present value of a loan or an investment using a...

You’re here because you want to make stunning, interactive and professional dashboards with Excel. You’re at the right place. I am recommending the best Excel dashboard course here. I have checked this course personally (enrolled)...

The CONVERT function is an extremely useful and relatively unknown Excel function. It converts a number from one unit of measurement to another unit of measurement. The CONVERT function can convert between units of...

When you have more than one data series that you want to plot on the same chart, you can create a combination chart in order to deliver a visual representation of each of the...

Advanced Excel / Formulas / Functions

by Taryn N · Published March 22, 2017 · Last modified March 24, 2017

Using Flash Fill This is a question that is often asked namely, how to extract data from one column into another format or more than one column. We are going to see how to...

Advanced Excel / Data Analysis / Formulas / Functions

by Taryn N · Published March 20, 2017 · Last modified March 25, 2017

The Excel database functions are designed to help one retrieve relevant information from large sets of data stored in Excel. There are twelve database functions available in Excel namely: DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX,...

Microsoft Excel provides efficient functions that allow one to search for and lookup data. Of the lookup functions – VLOOKUP, INDEX and MATCH and the database function DGET are the most useful and most...

Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, not to be confused with the DAY function, returns the...

In this post, we shall discuss how you can navigate within a table, how you can select different parts of a table and how you can move a table from one location to another....

In this post, we shall learn how you can add new rows or columns in a table and how you can delete existing rows or columns from a table. You can add a new...

This post will deal with imposters! No, I mean table duplicate entries. We will be able to manage them, remove them, tame them according to our needs and desires by the end of this...

- Top 20 Advanced Essential Excel Skills You Need to Know
- Learn Excel VBA Programming & Macros [Free Tutorials,…
- 102 Microsoft Excel Formulas & Functions Cheat Sheet…
- How to Make a Frequency Distribution Table & Graph in…
- How to Reference PivotTable Data in Excel Formulas with…
- Excel 2013 Scenario Manager To Do Scenario Analysis
- Conditional Formatting in Excel 2013 [Multiple, Based on…
- ActiveX Controls Excel [Check box, Combo box, List box, Text
- What is active cell in Excel
- How to Create One Variable Data Table in Excel 2013 –…