Your reports should remain stable even when your data gets messy. AGGREGATE is the only function that survives both filtered ...

The more I learned MOD, the more excuses I found to use it.

Regardless of whether your Excel spreadsheet contains a little or a lot of data, you may want to have cells that meet certain criteria stand out. Excel lets you set some conditional formatting rules ...

Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what your workbook already contains, but it analyzes the data ...

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...

Please note: This item is from our archives and was published in 2005. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I know Excel ...

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more. Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating ...

Sometimes, the YEAR function returns the correct value, but Excel displays an unexpected year, such as 1900 or 1905. This occurs when the cell containing the YEAR formula is formatted as a Date ...

Microsoft Excel’s new FILTER() function is a great tool for reporting and dashboards. We’ll show you how to use it to get more done. Filtering is a huge part of many Microsoft Excel sheets, and ...