## The FVSCHEDULE Excel Function

We have already seen how to use the FV (Future Value) Function to calculate the future value of an investment with a constant or fixed interest rate, in a previous tutorial. Let’s remind ourselves...

We have already seen how to use the FV (Future Value) Function to calculate the future value of an investment with a constant or fixed interest rate, in a previous tutorial. Let’s remind ourselves...

Advanced Excel / Financial Modeling / Formulas

by Kawser · Published April 18, 2017 · Last modified July 13, 2017

Videos, podcasts, kindle versions of books and online courses are the trend now. So, do you still need a book to learn Excel? Yes! Of course! You still need Excel books. When I started using...

We have already seen how to use the IRR (Internal Rate of Return) Function in a previous tutorial. The IRR Function is used to calculate the internal rate of return for a series, of...

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 courses here. I have checked these courses 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 May 29, 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...

- 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
- How to Make FOR LOOP in Excel Using Formulas?
- What is active cell in Excel