Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Use Data Type with a slicer - How to connect them?. That video is uploaded by Excel Exercice at 2021-11-18T04:10:03-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [QN7--it_PVY]
| Name | Use Data Type with a slicer - How to connect them? |
| Video Uploader | Video From Excel Exercice |
| Upload Date | This Video Uploaded At 18-11-2021 12:10:03 |
| Video Discription | Discover the trick to connect Data Type with a slicer. This trick will transform your dashboard to another level of analyse. All the explanations are detailed in this article https://www.excel-exercise.com/connect-slicer-with-data-type/ 00:00 Introduction 00:12 What is Data Type 01:27 Create a Table with your field and an ID 04:02 Insert the slicer of the column of the Table 04:27 Function SUBTOTAL 05:36 Embedded the result in the function XLOOKUP 06:26 Creation of the formula with FIELDVALUE 08:34 Correct the N/A error if there is no selection 09:22 Correct the SPILL Error when Data Type return more than one result 10:15 Add new field for the slicer QN7--it_PVY |
| Category | Education |
| Tags | data type | slicer | excel data type | datatype | excel slicers | using slicers in excel | how to use excel slicers | filter excel data with slicers | subtotal | subtotal in excel | xlookup | xlookup in excel | fieldvalue excel | arraytotext | dynamic array | dynamic array excel | frederic le guen | excel tricks | expert level excel | Data types |
