excel pivot tables

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 » Excel pivot tables

Excel pivot tables

resolvedResolved · Low Priority · Version 2003

Michelle has attended:
Excel Introduction course

Excel pivot tables

what is a pivot table?

RE: Excel pivot tables

Hello Michelle

Thank you for your question, and welcome to the forum.

A pivot table provides a table area which you can put data into and pull it out of so it can be analysed from different perspectives.

The Microsoft website has an introductory tutorial which looks at the concept of pivot tables and how they work:
http://office.microsoft.com/en-us/excel/HA010346321033.aspx

Also we cover pivot tables on our Excel Advanced course.

Amanda


 

Excel tip:

Keyboard Shortcuts to Add Rows or Columns

Couple of other keyboard shortcuts. Shift+spacebar selects a row, Ctrl+spacebar selects a column. Select either row or column (or several) and use Ctrl and + to insert or Ctrl and - to delete rows or columns.

View all Excel hints and tips


Server loaded in 0.08 secs.