Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

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.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

Or, if you are creating an Excel dashboard, you can use it to display part of a table, PivotTable, or chart in your dashboard, changing the size of your screenshot to display as much or as little ...