microsoft excel training class - 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 » microsoft excel training class - Pivot tables

microsoft excel training class - Pivot tables

resolvedResolved · Low Priority · Version Standard

replyReply Wed 23 May 2007, 16:31Delegate Lucy said...

Lucy has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course
Access Intermediate course

Pivot tables

Will they update themselves?

For upcoming training course dates see: Pricing & availability

replyReply Thu 24 May 2007, 16:56Trainer Richard said...

RE: pivot tables

HI Lucy,

No they will not. You must update them by right clicking on the pivot table and then clicking on the red exclaimation mark to REFRESH.

Regards

Richard

 

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

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