## 3D Referencing & External Reference in Excel

Creating 3D referencing in Excel within a formula involves referring to the same cell or the same range of cells, on different worksheets. Each of the sheets, one is using, to create the 3D...

Creating 3D referencing in Excel within a formula involves referring to the same cell or the same range of cells, on different worksheets. Each of the sheets, one is using, to create the 3D...

Advanced Excel / Formulas / Functions

by Taryn N · Published July 13, 2017 · Last modified November 9, 2017

The TODAY() Function is used to determine the current date, as in the date one is actually opening the workbook. This function updates automatically, so let’s say you open the workbook on 1 April...

Advanced Excel / Formulas / Functions

by Taryn N · Published June 22, 2017 · Last modified September 16, 2017

The FORMULATEXT Function is a new Excel function, which was introduced in Excel 2013 and later versions of Excel. Using the FORMULATEXT Function will allow you to select any cell containing a formula and...

Advanced Excel / Formulas / Functions

by Taryn N · Published May 11, 2017 · Last modified September 17, 2017

There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF Function, the COUNTIFS Function and the COUNTBLANK Function. The COUNT...

Advanced Excel / Formulas / Functions

by Taryn N · Published April 30, 2017 · Last modified October 30, 2017

An asset is defined as a resource with an inherent economic value that is owned by an individual, corporation or country which will yield future economic benefit. Accountants list assets on balance sheets, in...

Advanced Excel / Dashboard / Data Analysis / Data Visualization / Formulas

by Kawser · Published April 25, 2017 · Last modified October 4, 2017

So, you know your SUM formula, you also know how to use the COUNTIF function. In addition, you are the go-to person at your office, when basic or intermediate level Excel help is needed....

Advanced Excel / Formulas / Functions

by Taryn N · Published April 21, 2017 · Last modified September 17, 2017

There are different types of interest rates and it is prudent for every investor or potential investor to know the differences between interest rates. The nominal interest rate is the simplest of the interest...

Advanced Excel / Formulas / Functions

by Taryn N · Published April 19, 2017 · Last modified September 17, 2017

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 October 4, 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...

Advanced Excel / Formulas / Functions

by Taryn N · Published April 17, 2017 · Last modified September 17, 2017

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...

Advanced Excel / Formulas / Functions

by Taryn N · Published April 13, 2017 · Last modified October 25, 2017

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...

Advanced Excel / Formulas / Functions

by Taryn N · Published April 7, 2017 · Last modified September 17, 2017

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...

In this tutorial, you will learn how to calculate the net present value using Excel’s NPV and XNPV Functions. The NPV (Net Present Value) Function is used to calculate the net present value of...

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

Advanced Excel / Formulas / Functions

by Taryn N · Published March 28, 2017 · Last modified September 17, 2017

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...

- Top 20 Advanced Essential Excel Skills You Need to Know
- 102 Microsoft Excel Formulas & Functions Cheat Sheet…
- Learn Excel VBA Programming & Macros [Free Tutorials,…
- 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
- How to Make FOR LOOP in Excel Using Formulas?
- Conditional Formatting in Excel 2013 [Multiple, Based on…
- What is active cell in Excel
- ActiveX Controls Excel [Check box, Combo box, List box, Text