Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Basic Formulas At their most basic, Excel formulas can perform basic math functions and display a solution. For example, the formula "=2+2" will display "4" in the cell.

The three inputs into a Sharpe ratio calculation are your expected return, the risk-free rate and the standard deviation. Your return covers the portfolio's net gain. The risk-free rate represents how ...

On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...

Most people measure wealth only by their bank balance, house, cars, or jewelry. But in reality, true financial strength is ...

Using Excel as a scheduling tool is a great skill to have under your belt. Learn how to use SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions.

The cross price elasticity of demand measures how the demand for one good responds to price changes for another good. Companies use it to set prices.

Annualized income is an estimate of the amount of money that an individual, business, or investment asset will earn over the course of a year.

Sortino Ratio Example The following examples of applications of the Sortino ratio formula demonstrate how calculating risk-adjusted returns can benefit investors.

Knowing how to calculate holding period return can help you assess the performance of your investments. Here's how it works.