Slicers in Excel

Slicers are floating filters associated with PivotTable, PivotChart and official Tables in Excel. Apart from filtering data, Slicers also provide the current filtering status. In this blog post, we will see how to add Slicers for PivotTables and Excel Tables. We will also cover how to ‘Connect a Slicer to two or more PivotTables.’ Add Slicer for an…

How to Connect Excel Tables

How to build Relationships between Excel Tables using the Data Model of Excel is explained in this Tutorial. Purpose of connecting Tables VLOOKUP and INDEX+MATCH formulas always get the job done, but a lot of them will essentially slow down the workbook. Moreover, the Lookup and Reference formulas also demands maintenance with addition or deletion…