![](https://easylearnlive.com/wp-content/uploads/2018/07/excel-min1.jpg)
![](https://easylearnlive.com/wp-content/uploads/2018/07/Roman-Kondratiuk-ELL-Presenter-Photo-20161016-min.jpg)
VLOOKUP Range Lookup Table with Absolute References
Roman Kondratiuk
Slicers are a visual display mechanism in PowerPivots which allow you to interactively filter your PivotTable display using fields and data from your Data Model.
PowerPivot Slicers can incorporate calculated and concatenated fields and be used in conjunction with timelines and charts to filter, analyse and display PivotTable information efficiently with minimal effort.