March 2014 - Page 2 of 2 - Best Excel Tutorial

10Mar

How to calculate ratio?

In mathematics, a ratio is a comparison of two numbers. It is expressed as a colon (:) between the two numbers. For example, if there are 2 red balls and 3 blue balls on a table, the ratio of red balls to blue balls is 2:3.

How to make 3 axis graph

by Best Excel Tutorial Charts

As you know, it’s easy to draw 2D (with 2 axis) graphs in Excel. You can also draw a 3D chart in Excel, with 3 axes: X, Y and Z.

How to use the Excel MIRR function?

by Best Excel Tutorial Functions

The term MIRR (Modified Internal Rate of Return) is commonly used in corporate financial or financial management to indicate the profitability of an investment, and is therefore commonly used in making business decisions when choosing between investments. The MIRR calculation uses a series / payment schedule (which includes the initial outflow along with net income / gains), when calculating the MIRR of interest capitalization, it is assumed that the Net Present Value of the investment is zero.