Excel resources

Excel Tips & Tricks

Articles, examples, and practical guidance from the SpreadsheetWeb team.

Page 8 of 60 · 540 articles

Double Negative in Excel: What Double Minus (--) do?

The double negative, also known as double minus, is an operation to convert Boolean values into ones and zeroes.

SpreadsheetWeb • By using the CUMIPMT function in Excel, you can calculate cumulative loan interest over a period of time.

Do you need to know your active file’s location frequently? Let us show you how to show the workbook location in the Quick Access Toolbar.

Excel’s PivotTables give you pretty much all the tools you might need to transform a data set, easily manipulate it, and analyze its content.

The LEN function is used to count characters in Excel. But it doesn't support ranges or arrays to easily count total number of characters in a range.

In this guide, we are going to show you how to create a dropdown list in Excel with three different ways including Excel formulas.

Let us show you how to recover and repair Excel file that has been corrupted. There are a few things you can do to recover your work.

In this guide, we'll introduce step-by-step insights and valuable tips to make the most of this powerful Microsoft Excel feature.

In this article, we're going to show you one of the easiest methods for organizing data and how to remove blank rows in Excel using filters.