How to Increment a Number in Excel. Product IDs, serial numbers and other reference numbers require a unique identifier to avoid confusion when referencing a product or specific data point.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

How Do I Change Hours & Minutes Into a Decimal Number in Excel?. In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data ...

Both the Currency and Accounting number formats in Excel are used to display monetary values, including the symbol for the chosen currency. However, in this article, I'll explain their subtle ...

Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make quick work of this challenge.

Learn how to modify the number of Undo levels in Excel using this guide. You can set Undo levels from 0 to 100 using Registry Editor.

The variance measures how far each number in the set is from the mean. You can use Microsoft Excel to calculate the variance of the data you have entered into a spreadsheet.

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.