Performing calculations on complex numbers in Excel is not difficult because Excel has a set of functions that allow many different calculations of complex numbers.

Read More

Tornado diagrams, or tornado charts, are modified versions of bar charts and are also one of the classic tools of sensitivity analysis used by decision makers to get a quick overview of the risks involved. In other words, a tornado diagram or chart shows a financial analysis for a project.

Read More

Regression analysis is a powerful statistical tool used to analyze and model the relationships between variables. It allows us to understand how changes in independent variables affect the value of a dependent variable.

We will explore how to perform regression analysis in Microsoft Excel, specifically focusing on linear and multiple regression models.

Read More

A petal chart, also known as a star chart, is a type of radar chart that plots the values of each category along a separate axis that starts in the center of the chart and ends at the outer ring. Petal charts are useful for comparing multiple values across multiple categories.

Read More

Excel can’t create a multi level pie chart where everything is “automatically” taken care of for you, but you have to find a way around to make the solution workable.

Read More

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.

Read More

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.

Read More

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.

Read More

In this Excel lesson, you will learn how to create a Wind Rose chart in an Excel spreadsheet.

Read More

In this charting tutorial, you will learn how to create dynamic chart in Excel. There are useful when you want to have charts which change when you change the scope of data.

Read More