Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

Excel spreadsheets can grow unwieldy as they get larger and larger in size. If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter ...

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

How do I create and populate tables? And, once a table is created, how do we custom filter, format, and design those tables so they look professional in a report? We’ll show you how it’s done.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

You can edit a drop-down list in Excel using a few different methods. It's easy to edit a drop-down list if it's based on an Excel table, as the table should update automatically with your edits.