This Week’s Tip – MS Excel Pivots – Creating Calculated Fields

Posted in Weekly Tips

MS Excel Pivots – Creating Calculated Fields Excel

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.

Take a look at our Microsoft Office Courses – available within our E-Learning Library and as Virtual Classes.

E-Learning Library – Three Month Pilot (includes FREE Remote Working Courses!)


Virtual Classes – 90 minute classes tailored for your organisation

Virtual Classes

Can’t find what you need?



Sign up for our free weekly tip

Receive a free nugget of IT Learning every week! It will give you a good feel for how we write and design our lessons and you could learn something new every week too!