In this Excel tutorial, you learn how to handle MACD in your spreadsheet.

The Moving Average Convergence Divergence (MACD) indicator is a popular technical analysis tool used in stock trading and other financial markets to identify potential buy and sell signals. The MACD is calculated as the difference between two moving averages, the 26-day exponential moving average (EMA) and the 12-day EMA, and is often plotted along with a 9-day EMA of the MACD line, known as the signal line.

Here’s how to calculate the MACD indicator in Microsoft Excel:

Read More

In Excel, you can calculate the integral average, also known as a definite integral, by using the Sumproduct and Trapz functions.

Read More

Logarithmic average, also known as the geometric mean, can be calculated in Excel by using the geometric mean formula.

Read More

Earnings per share (EPS) is a financial metric that measures a company’s profitability. In this lesson, you will learn how to calculate EPS in Excel.

Read More

In this lesson you can learn how to calculate ROIC in Excel.

Read More

In this Excel tutorial lesson, you will learn how to calculate ROCE in Excel.

Read More

Return on Sales (ROS) is a financial ratio that measures a company’s efficiency in generating profits from its revenue. It is calculated by dividing the operating profit (or income) by the net sales. A higher ROS indicates greater profitability and better control over costs.

In this tutorial, I’ll show you how to calculate ROS in Excel with a simple formula. All you need are two inputs: operating profit and net sales. Alternatively, you can use EBIT (earnings before interest and taxes) as a proxy for operating profit and revenue for net sales.

Read More

The antilog, also known as the inverse logarithm, is a mathematical operation that can be used to reverse the effect of a logarithm. In Excel, the antilog can be calculated using the EXP function, which returns the exponential value of a given number. In this Excel tutorial, you will learn how to handle antilog in Excel.

Read More

A blood alcohol calculator in Excel can be a useful tool for determining the estimated blood alcohol content (BAC) of an individual based on their weight, gender, the number of drinks consumed, and the time elapsed since their last drink. Here is a step-by-step guide for creating a blood alcohol calculator in Excel:

Read More

In this Excel tutorial, you learn how to prepare ebay fee calculator in your spreadseet.

An eBay fee calculator in Excel can help you estimate the fees you will incur when selling items on eBay. Here’s how to create an eBay fee calculator in Excel:

Read More