Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills
2016 2013 2010 2007 Apple Mac

Add a calculated field to a pivot table:

Lesson 5-17 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)
Add a calculated field to a pivot table
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2013 Expert Skills
Session: Session 5: Pivot Tables
Lesson: Lesson 5-17 Add a calculated field to a pivot table Excel Pivot Table Calculated Fields.  Thumbnail for lesson 5-17 in the Pivot Table session of the Excel Expert Skills training course
Description:

This free video lesson fully explains how Pivot Table Calculated Fields work in Microsoft pivot tables. This lesson will teach you why calculated fields are used and some alternative ways to achieve the same results. In this lesson's example, you'll see how to create a calculated field that automatically calculates a 3% bonus for each employee. You'll also see how to create a custom header row for a pivot table by hiding the automatically generated headers and replacing them with your own.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email