Hooking up slicers to one pivot table in Excel 2010 provides a programming-free way to create dashboards. One of the new features in Excel 2010 is a type of visual pivot table filter called a Slicer.

Slicers are a good way to filter data in a Microsoft Excel PivotTable or PivotChart, but they take up a bit of room. By moving the buttons to the chart, you free room for more visuals.

You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends. If you're new to pivot tables, this guide will get you ...

Excel’s PivotTables (Microsoft runs the words together, although you?ll find pivot tables in other spreadsheet programs) can provide those types of answers. Do you want to group data by category?