pivtoal tablecharts

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivtoal Table/charts

Pivtoal Table/charts

resolvedResolved · Low Priority · Version 2007

Pivtoal Table/charts

Want to recap it again?

RE: Pivtoal Table/charts

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 rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips


Server loaded in 0.07 secs.