Use table slicers to their full potential with the SUBTOTAL function in Microsoft Excel

[@johanneskeller3794]

Many thanks for this very useful tutorial . It allows filtering a table by the condition of the visibility of cells depending on selection by slicer. Very useful is the possibilty of creating a dynamic diagram depending on the selection of the underlying data by slicers .

[@practicalspreadsheetsolutions]

Thank you very much for your comment!