Module 05 · Data Model & measures

Total Expense & Total Budget measures

Build your first two measures with SUM, complete with a thousands-separator number format.

Step by step7 minLesson 21 of 37 Members

A measure is a formula you create once and then use in every chart, KPI card and PivotTable. If the formula needs to change, you change it in one place instead of checking 300 cells full of copied formulas. In this lesson you build two basic measures: Total Expense and Total Budget.

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 all Already a member? Sign in

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