Call us on 0844 800 7880
Tip of the Week

ms office 2016 logoMS Excel - Pivot Tables - Working with multiple ranges

DID YOU KNOW... that your Pivot Table can include data from multiple locations?

Last week I needed to create a Pivot Table using various quarterly figures in different worksheets.  Normally I would only use one range of data but using this feature enabled me to select them all very easily. Let's explain.

To learn how, click on a link below to see how it works:

Click here for MS Excel 2016
Click here for MS Excel 2013
Click here
for MS Excel 2010

 


We are no longer providing weekly tips for MS Office 2007 and 2003, but you can search for this lesson on your Dashboard if you are a member of that library.

If you are a member, just close this pop up window to go back to your Learning Dashboard.

If you'd like to become a member ...
and gain access to thousands of Bite Size lessons like these, please complete our contact form here.

If you'd like to receive our Weekly Tip emails every Tuesday ... 
Just complete the green box on the right hand side of this page.

If there is a computer tip you'd like to see in the coming weeks ... 
Let us know by completing our contact form here.

 

 

My Bite Size Login

On-line Courses
Facebook Twitter LinkedIn Google+ YouTube