INSYNTIVEAcademy
IDEN
Sign inSign up

Module 07 · Polish, KPIs & slicers

KPI cards: the big numbers on top

Pull the totals from a helper PivotTable with GETPIVOTDATA, then show them in text boxes linked to cells.

Step by step8 minLesson 30 of 37 Members

Before looking at any chart, a reader wants to know two things: how much was spent in total, and is it still under budget? Those answers go on four KPI cards along the top. The technique is the one used in Dashboard Expense - CONTOH JADI.xlsx: the numbers are calculated in helper cells from column BA onwards (outside the dashboard area), and each card’s text box simply points to one of those cells.

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