advanced excel course - 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 » advanced excel course - Pivot tables

advanced excel course - Pivot tables

resolvedResolved · Low Priority · Version Standard

replyReply Tue 16 Oct 2007, 16:52Delegate Claire said...

Claire has attended:
Excel Intermediate course

Pivot tables

How do you set up a pivot table?

For upcoming training course dates see: Pricing & availability

replyReply Thu 18 Oct 2007, 10:36Trainer Rajeev said...

RE: Pivot tables

Dear Claire:

To create Pivot tables you have to ensure that you have selected any cell within the table!!

- From the Menu bar select Data > Pivot Tables and Pivot charts Report
- Click Finish if you want to keep the default settings
- Once you have a new sheet simply drag and drop the relevant fields from the Pivot table Field List box in to teh blue bordered area.

For hands on experience of this you might want to Book for Excel Advanced course which will cover this and many more topics that you will require to carry out your day to day activities!!

Please copy and paste the following following link and see when is our next Advanced course is scheduled:

http://www.microsofttraining.net/order/pricing_availability.php


 

Excel tip:

Auto-insert the current time

In Microsoft Excel, to enter the current time into a cell, hold CTRL+SHIFT and press SEMICOLON.

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