This Week’s Tip – MS Excel Pivots – Creating Calculated Fields
MS Excel Pivots – Creating Calculated Fields
DID YOU KNOW …that you can use custom formulas to create calculated fields and calculated items in a pivot table?
Its calculation can use the sum of other items in the same field. It’s just as easy as writing a formula – but using item names rather than cell addresses.
It sounds complicated – but it’s not. Take a few minutes to learn about it, and then give it a go. Click the play button below to get started.
Our Weekly Tips are delivered via email every Tuesday. Learn something new every week – in Bite Size bites of learning. To sign up to our Weekly Tip Newsletters – sign up here.
E-Learning Library – Three Month Pilot (includes FREE Remote Working Courses!)
Virtual Classes – 90 minute classes tailored for your organisation
Can’t find what you need?