learn excel - pivot table
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 » learn excel - Pivot table

learn excel - Pivot table

resolvedResolved · Low Priority · Version Standard

replyReply Wed 31 Jan 2007, 10:07Delegate Brenda said...

Brenda has attended:
Excel Intermediate course
Excel Advanced course

Pivot table

How do I create a pivot table?

For upcoming training course dates see: Pricing & availability

replyReply Wed 31 Jan 2007, 10:46Trainer Richard said...

RE: Pivot table

Put your cursor into the data you want to go into your pivot table.
Select DATA> Pivot table. Then follow the wizard
Drag the relevant fields to the PIVOT TABLE. Adjust as necessary

 

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

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