You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Learn how to calculate moving averages in Excel using dynamic arrays. Simplify rolling totals with custom functions for efficient analysis.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

How to use Excel’s RANK.AVG () function Figure D Figure D Word’s RANK.AVG () better accommodates duplicates. Figure E Figure E The average rank increase with every duplicate.

Learn how to use both Excel's XLOOKUP() and VLOOKUP() functions to find results between conditional benchmarks in Microsoft Excel.

Discover how to calculate the modified Macaulay duration of a bond or other fixed-income security using Microsoft Excel.