Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

liz has attended:
Excel Intermediate course

Excel

where do i find the support info for pivot tables

RE: Excel

Hi Liz,
Thank you for your question;
In response;
Pivot Tables are covered on our Excel Advanced Course, A pivot table is a summarisation of data which can be viewed from a number of different perspectives. There are a number of books which will cover this subject, ranging from the Idiots guides to some seriously complex manuals.
If you want a quick fix the internet will return some varied levels of response to the search "Excel Pivot Tables" but you will have to look deeper for particular requirements. I hope that has helped... Pete

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.