microsoft excel training london - 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 » microsoft excel training london - Pivot table

microsoft excel training london - Pivot table

resolvedResolved · Low Priority · Version Standard

replyReply Tue 27 Feb 2007, 09:51Delegate Holly said...

Holly has attended:
Excel Intermediate course

Pivot table

please can you tell me how to create a pivot table and why are they used?

For upcoming training course dates see: Pricing & availability

replyReply Tue 27 Feb 2007, 11:01Trainer Tracy said...

RE: pivot table

Hi Holly,

1. Enter the data you require for the Pivot table.
2. Select any cell within that data range
3. Then click Data > Pivot Table and Chart Reports
4. Follow all the steps of the wizard
5. Drag the fields you want to see onto the pivot table from the field list.


Pivot tables can be a more efficient way to view data

Hope that helps and enjoy your training

Tracy

 

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

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