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
Look forward to seeing you soon, Anita Lund Owner and Founder of Trainers Direct Pty Ltd (Sydney) www.trainers-direct.com.au & Storm Training & Solutions (UK) www.stormtraining.com Sometimes in Excel it can be hard to see what's going on, particularly if you inherit a spreadsheet from someone. How on earth did they do those calculations? Clicking on each individual cell and looking at the formula bar can be tiresome but luckily there's an easy way to unlock the formulas using a simple short cut key or a button. Watch this short video to find out how. Tell me what you think. We offer training courses in Sydney and the UK for all computer training apps. Look forward to seeing you soon,
Anita Lund Owner and Founder of Trainers Direct Pty Ltd (Sydney) www.trainers-direct.com.au & Storm Training & Solutions (UK) www.stormtraining.com |
About The AuthorAnita 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
Categories
All
|