excel training class - 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 training class - Create pivot tables

excel training class - Create pivot tables

resolvedResolved · Low Priority · Version Standard

Byron has attended:
Excel Intermediate course

Create pivot tables

How do I create Pivot Tables?

RE: Pivot Tables

1. Place you cursor in the data table you want to create a Pivot Table from.
2. Click DATA > PIVOT TABLE AND PIVOT CHART WIZARD
3. Follow the wizard to create the basic structure
4. Drag the fields you want to see summarised into the pivot table


 

Excel tip:

Reset Excel toolbars to default settings

If you find any of your toolbars in Excel have changed (i.e. they are missing or have extra buttons) then you can reset them to their defaults.

1. Go to Tools - Customise.
2. Select the Toolbars tab.
3. Select (highlight) the name of the toolbar you wish to reset, then click the Reset button on the right.
4. Close the dialogue box.

View all Excel hints and tips


Server loaded in 0.09 secs.