E-Learning Library  *  Virtual Classrooms  *  Face 2 Face Workshops  *  Online Shop

 

Microsoft Excel - 'Summarise Values By' with Pivots


'Summarise Values By' lets you change what your PivotTable calculates, making it easy to look at the same data from different angles and 'Show Values As' allows you to quickly calculate percentages i.e. % of the Grand Total, and here's 3 good reasons why you should learn about them.

 

  1. Allows you to analyse the same data in different ways.
  2. Answer different questions i.e. Sum for total sales, Average for average order value, or Count for the number of orders, and
  3. Excel performs the calculation automatically, so there’s no need to create separate formulas in your worksheet.


Click here to learn more

Bright Ideas start with Brilliant IT Skills. Take a Bite today!

eLearning - Take a Bite


Three Month Winter Warmer - a great way to grow your Microsoft 365 skills.

Learn More

Your Place or Ours?


Deliver our CPD Courses and Tests on your own Learning Management System.

Learn More

Virtual Classes


Let us create a Bite Size Virtual class delivered on Microsoft Teams.

Learn More

 

Get in touch and find out more

Why not forward this newsletter to a friend or colleague to learn something new? They can sign up to our free weekly tips here

Learning Solutions for Business | Shop Now for Individuals  | Contact Us | Log in

Facebook  LinkedIn  X

You are receiving this newsletter because you requested our Tip of the Week or are a Member of our Bite Size Lesson Library. Our Weekly Tips are FREE and provide useful hints and tips on how to get the most out of your computer. You can manage your preferences at any time by using the update profile or safe unsubscribe links below.