Onsite Computer Training in Sheffield, Derbyshire, Yorkshire & UK
  • Home
  • About
  • Microsoft Training
    • Microsoft Word Training
    • Microsoft Excel Training
    • Microsoft Project Training
    • PowerPoint Training
    • Microsoft Access Training
    • Microsoft Outlook Training
    • Microsoft Publisher Training
    • MS Office Tips & Tricks
    • Office 365 Training
    • SharePoint Training
    • Visual Basic Training
    • MS Office Upgrade Training
    • OneNote Training
    • Email Merge Workshop
  • One to One Training
  • Adobe Training Courses
    • Photoshop Training
    • Illustrator Training
    • InDesign Training
  • Professional Development
    • Handling Difficult Situations and People
    • Change Management
    • Assertiveness and Personal Effectiveness
    • Time Management
    • Effective Telephone Techniques
    • The Effective Team Leader
    • Presentation Skills
    • Managing Poor Performance
    • Customer Service
  • Pricing
  • Contact

Raise Your Game

The raise your game blog will ensure you do just that.

Create a Pivot Table using Multiple Data Sources

4/7/2016

0 Comments

 
For those of you who are already familiar with using Pivot Tables, this is a really useful tip. If you want to combine data from more than one sheet, use the short cut key Alt D and then press P (Alt D is the old Data tab command and P is Pivot Table). This launches the old user friendly pivot table wizard where you can choose to add 'Multiple Consolidation Ranges'. You can then select more than one data source for your report.

Check in again soon for a short tutorial to guide you through those steps.

Look forward to seeing you soon,

Anita Lund
Owner and Founder of Trainers Direct Pty Ltd (Sydney)  
On Site MS Office, Excel, Word, PowerPoint, Outlook and computer training courses and workshops in Sydney
www.trainers-direct.com.au
​& Storm Training & Solutions (UK) www.stormtraining.com

​ 
0 Comments



Leave a Reply.

    About The Author

    Anita Lund is an avid MS Office evangelist, trainer and Company Owner. Passionate about sharing the most useful tricks of the trade using plain English. 

    Archives

    June 2016
    April 2016
    March 2016

    Categories

    All
    2 Minute Tutorials
    Excel
    Outlook
    Word

    RSS Feed

    View my profile on LinkedIn

 

MS Office Courses Sydney







​Email louise@stormtraining.com 
or call Louise on ​07305 444769

  • Home
  • About
  • Microsoft Training
    • Microsoft Word Training
    • Microsoft Excel Training
    • Microsoft Project Training
    • PowerPoint Training
    • Microsoft Access Training
    • Microsoft Outlook Training
    • Microsoft Publisher Training
    • MS Office Tips & Tricks
    • Office 365 Training
    • SharePoint Training
    • Visual Basic Training
    • MS Office Upgrade Training
    • OneNote Training
    • Email Merge Workshop
  • One to One Training
  • Adobe Training Courses
    • Photoshop Training
    • Illustrator Training
    • InDesign Training
  • Professional Development
    • Handling Difficult Situations and People
    • Change Management
    • Assertiveness and Personal Effectiveness
    • Time Management
    • Effective Telephone Techniques
    • The Effective Team Leader
    • Presentation Skills
    • Managing Poor Performance
    • Customer Service
  • Pricing
  • Contact