Understand the basics of the current ratio, including its use in assessing a company's liquidity and learn how it is calculated in Microsoft Excel.

In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory ...

Having intermittent cells and blank cells in Excel makes calculating the sum of intermittent cells tedious. Using this technique, you can calculate sporadic totals in Excel easily.

Find out more about free cash flow, the formula for calculating free cash flow, and how to calculate a company's free cash flow using Microsoft Excel.

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

How to Calculate a Running Total in Excel Learn to create cumulative sums in Microsoft Excel with these step-by-step instructions and screenshots.

While MS Excel provides unlimited options to play around with numerals, there are limited options to do so with text. Using the '&' key, you can consolidate the text information in the same way ...

System administrators at your company can use Microsoft Excel's Visual Basic editor to calculate subnetworks, generating host addresses by combining network addresses and subnet masks.

How to Convert DOB to Age in MS Excel. Microsoft Excel provides a function that displays a person's age based on his date of birth. In your business, this function can help you keep track of your ...

How to create an interactive dashboard in Microsoft Excel Now that you have a basic idea about interactive dashboards in Microsoft Excel, let’s check them out in action.