Excel Table

Slicers in Excel: Filter Tables and PivotTables With Buttons

by
Slicers in Excel

A slicer is a panel of buttons that filters an Excel Table or PivotTable with one click, and always shows what's filtered. One slicer can also control several PivotTables at once, which makes simple dashboards easy. Excel TableTable Design → Insert Slicer PivotTablePivotTable Analyze → Insert Slicer Multi-selectCtrl + click Add a slicer to an … Read more

Connect Excel Tables With Relationships (Data Model)

by
Connect Tables With Relationships

Instead of adding VLOOKUP columns to bring region or category into a sales table, connect the tables with a relationship. A PivotTable can then use fields from all of them at once, with no extra formulas. WhereData → Relationships PivotTableUse this workbook's Data Model Works inExcel 2013 and later for Windows Video The problem Sales_Data … Read more