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.

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.

Advance Filter in Microsoft Excel is easy to use. Learn how to filter data based on complex conditions in Excel the right way.

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

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.

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 to Center Horizontally & Vertically in Excel. When crafting an Excel 2010 spreadsheet for your business, getting the look just right is important, making data easier to browse and understand.

Can Excel sort by color? Absolutely. In addition to sorting by values, Excel can sort by cell color, font color, and cell icon. First, you must you must define the colors for your sort columns ...