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.

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.

Use implicit And and Or operators with Excel's Advanced Filter feature to create complex, but powerful, filtering combos.

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.

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 ...