excel pivot tables
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Excel pivot tables

resolvedResolved · Low Priority · Version 2007

replyReply Fri 9 Sep 2011, 13:54Delegate Phil said...

Phil has attended:
Presentation Skills course
Excel Intermediate course

Excel pivot tables

Hi Mark

I have a question about pivot tables. I have 2 files that use them and they don't seem to work as I think they should. In one case the months don't come in number order and in the other the pivot table goes horizontally and I would prefer it to be vertical. Can I send you the files to have a look please?

Thanks
Phil

For upcoming training course dates see: Pricing & availability

replyReply Sun 11 Sep 2011, 23:26Trainer Mark said...

RE: Excel pivot tables

Hello Phil,

Send the files over and we'll have a look.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

replyReply Mon 12 Sep 2011, 07:45Delegate Phil said...

RE: Excel pivot tables

Hi Mark

Can you give me an email address so I can send the files?

Phil

replyReply Tue 20 Sep 2011, 08:21Trainer Mark said...

RE: Excel pivot tables

Hello Phil,

It would be a start if you could send a sample of what you have so we can look and decide if we can solve the layout issue you are having.

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

replyReply Mon 26 Sep 2011, 12:52Delegate Phil said...

RE: Excel pivot tables

Mark

I still do not have an email address that I can send the file to. I cannot describe it in words, you need to see the file.

Phil
PS I was away on holiday for a week.

replyReply Fri 7 Oct 2011, 14:10Trainer Richard said...

RE: Excel pivot tables

Hello Phil,

Please send your example file to info for Mark's attention and we will get it to him.

Regards,

Richard

Mon 26 Sep 2011: Automatically marked as resolved.

 

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

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard