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 ...

You can automate your ROI calculations for products or other types of investments by creating a simple, reusable Excel spreadsheet.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

Start Excel and open the worksheet containing the number you want to round up. Click inside of the cell where you want to display the calculation. Type "=ROUNDUP ()" into the formula bar.

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

Reviewed by Charlene Rhinehart Fact checked by Vikki Velasquez Businesses depreciate long-term assets for both tax and accounting purposes. For tax purposes, businesses can deduct the cost of the ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Calculating the Pearson correlation coefficient can be complicated but software makes it much easier. You can use several methods to calculate correlation in Excel.

The payback period is the amount of time needed to recover the initial outlay for an investment. Learn how to calculate it with Microsoft Excel.