Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot tables

Resolved · Low Priority · Version X

Reply Tue 25 Oct 2011, 16:35Delegate Gabriel said...

Gabriel has attended:
Excel Intermediate course

Pivot tables

can you collate date from multiple tables?

For upcoming training course dates see: Pricing & availability

Reply Wed 26 Oct 2011, 07:02Trainer Andrew said...

RE: pivot tables

Hi Gabriel

Thank you for your question. Pivot tables work from one source so it's better to merge the multiple sheets into one sheet before pivoting. You may wish to apply a table format to the data to remove duplicates.

I hope this helps - do let me know if you have any further questions.

Kind regards,
Andrew

Reply Wed 26 Oct 2011, 18:00Delegate Gabriel said...

RE: pivot tables

Andrew,

Just want to say thanks very much for your great tuition over the past 2 days!
I really enjoyed the course and feel it was a huge benefit to the work which i will be doing at Badoo.

I'm sure i will be in touch for help as there are things i need to practice but I have definitely learned a lot already.

Plus, I will also be in touch for assistance with Skynet and Siri!!! lol

Many thanks and all the best,

Gabriel.

Excel articles

· Correct In, Garbage Out
· Learn How To Use Index And Match Functions In Excel
· Replacing Cell Formats In An Entire Excel Workbook
· Coping With Compatibility In Excel 2007
· Utilise the web's information banks with Microsoft Excel

Please browse our web site to find out more about
excel training london and other Microsoft training courses.

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips