Excel 365

This Week’s Tip : Microsoft Excel – Creating Calculated Fields

Posted in Weekly Tips

Microsoft Excel – Creating Calculated Fields in Pivots
Excel 365

DID YOU KNOW … you can add extra fields in a PivotTable without touching your source data?  For example, if you want to add 20% VAT to a price list, you can create the calculation directly inside the Pivot – no cell formulas needed. It’s quick, clean, and super easy to do.

Take 10 minutes now and save yourself time in the long-term.  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.


Start your learning journey with Bite Size

On demand e-Learning LibraryTry our three month taster for your Business – start anytime.  >>Learn more
Your Place or Ours?Deliver our CPD courses in your own Learning System. >>Learn more
Virtual ClassesTailored for your organisation.  >>Learn more

Let’s have a conversation.  Get in touch.

bitsy

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!