INSYNTIVEAcademy
IDEN
Sign inSign up

Module 07 · Polish, KPIs & slicers

Slicers that drive every chart

Add Departemen and Tipe Biaya slicers, then connect them to all five PivotTables with Report Connections.

Step by step7 minLesson 31 of 37 Members

A slicer is a row of filter buttons the reader can click. One click on Marketing should make the whole dashboard (four charts and the KPI cards) show Marketing figures only. You will add two slicers, then do the step people forget most often: connecting them to every PivotTable.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

  • 5 steps with a numbered picture
  • All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
  • A new Excel & dashboard template every day, with resell rights
  • Take paid client projects on the Project Board
Become a member & unlock allAlready a member? Sign in

One payment for 12 months, no automatic renewal. Back to the free lessons