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.

In this guide, you will learn how to use Histogram Charts in Excel to visualize the distribution of your data. Follow these steps to create and customize your histogram chart: ...

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

Pivot Tables in Excel allow you to analyze and pull important summary information from large data sets. In this workshop, you will learn how to add fields to rows and columns, filters and values. The ...

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

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

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.

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

How to Use Microsoft Excel to Draw Control Charts and Graphs. A control chart plots measured values along with upper and lower quality control limits.

Excel is a powerful tool for managing projects, but there's one key feature it lacks: a built-in Gantt chart. This can be frustrating for project managers who rely on Gantt charts to visualize ...