Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivtoal Table/charts
Resolved · Low Priority · Version 2007
Mumtaz has attended:
PowerPoint Introduction course
Excel Intermediate course
Excel Advanced course
PowerPoint Intermediate Advanced course
Word Intermediate course
Word Advanced course
Want to recap it again?
Hi Mumtaz
How are you doing, sorry its taken me a while to get back to you
So to recap on what pivot tables are about, from your data that you want to make into a pivot table select the entire data area including headings, then go to the insert ribbon and click on the pivot table button
Then go through the steps that follow
after you have completed these you can layout the table as you want from the boxes on the righthand side of your screen
every field in your pivot table is also filterable from the dropdown lists on the fields
if you need anymore help on this please let me know
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
|
Excel tip:Sorting data stored in rowsPrimarily Excel is set up to sort data that is stored in columns rather than rows. |
We'll call during UK business hours
Server loaded in 0.07 secs.