Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

DGET is a straightforward lookup function designed to retrieve a single value from a column in a table or database. It's ...

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.

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

How to Use Conditional Statements in Excel. Jazz up your Microsoft Excel workbook by creating conditional statements to visually represent trends within your data. The Conditional Format tool ...

Excel's conditional formatting lets you formats cells based on the value of those cells or their formulas. Learn the basics of this amazing feature.

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...

COUNTA function with multiple criteria counts how many arguments are in the list of arguments. Learn how to use COUNTA function in Excel.

Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.