A calculated field in Excel pivot table allows you to create a new field by performing arithmetic operations on existing fields, such as summing two columns.