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

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.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

How to Put White Space in Cells in Excel 2003. White space appears as empty area within an Excel 2003 cell and it can be created by text or formatting. Textual white space consists of manually ...

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

Learn how to use basic Formulas for mathematical operations & insert Functions like sum, average, count, max, min, date, time, etc. in Excel.

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred ...