Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

If you need to sort, filter, and manipulate your Excel 2007 data but you don't know how to take advantage of Filters, I have just the thing for you. Watch this two-minute long Business Hacks ...

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.

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.

Learn the criteria expression for finding blank cells using Excel's Advanced Filter feature.

If you are working with a filter in an Excel worksheet, you can extend the range of the filter and include additional data by editing the filter criteria.

How to Filter Every 5th Item in Excel. When manipulating large amounts of data in an Excel spreadsheet, it can be challenging or time-consuming to select specific items by hand.

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.