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

When an ordinary alphabetical or numerical sort in Microsoft Excel won't do, check out the advanced sorting options or add a custom sort pattern.

Another way to split data into multiple columns is to use some of Microsoft Excel's functions. If you choose this route, remember that the split values will be linked to the original values, meaning ...

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

Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Excel's convenient cell-based structure lets you input your business' inventory, for example, and then sort that data in several ways via a few quick clicks.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

This post will show you how to filter or sort Excel data using Cell Color and Font Color the easy way. This helps organize cells & improve productivity.

How to Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what ...