Hooking up slicers to one pivot table in Excel 2010 provides a programming-free way to create dashboards.

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