How to use SLICERS in EXCEL TABLE!

How to use SLICERS in EXCEL TABLE!

EXCEL SLICERS works like a filter. SLICERS help filter out the required information from the large repository of data and present them in an easy to read and appealing format. Due to their visual qualities, slicers are often used in interactive dashboards. For example, if you have a data table containing various countries, you can create a slicer that only displays records where the country is the USA. Check-out how to use EXCEL SLICERS in this step-by-step video!

If you find the video useful, subscribe to “The HR Diary” YouTube channel. Subscribing to YouTube channels is free, and you will be updated when new contents are uploaded.

Other related resources to this video:
~ XLOOKUP vs INDEX & MATCH
~ What is COMPA RATIO and how do you use it for pay decisions?
~ How to create a MERIT MATRIX to allocate salary increases!
~ How to create a SALARY INCREASE MATRIX with EXCEL!
~ How to find PERCENTILE in PIVOT TABLE
~ How to create a 9 BOX GRID for TALENT MAPPING with SCATTER CHART!
~ COUNT FUNCTIONS IN EXCEL (COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS)
~ How to use EXCEL INDEX Formula!
~ How to use EXCEL MATCH Function!
~ How to Use XLOOKUP in EXCEL!
~ XLOOKUP vs VLOOKUP vs HLOOKUP
~ How to use IFERROR in EXCEL
~ How to use HLOOKUP in EXCEL!

By Cedric Ng,
AUTHOR of International Best Sellers,
“Predictive HR Analytics, Text Mining & ONA with Excel” &
“IISS: Employee Experience & Engagement with Predictive Analytics”