microsoft-excel-courses - pivot table

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 » microsoft-excel-courses - Pivot Table

microsoft-excel-courses - Pivot Table

resolvedResolved · Low Priority · Version Standard

Merline has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Pivot Table

How do I create a pivot table?

RE: Pivot Table

Dear Merline,

Thank you for your question.

In order to build PIVOT TABLES, you will need to locate the data source table first:

  • Click anywhere within your data table
  • From the DATA menu > click PivotTable & PivotChart Report
  • Press NEXT, Confirm Data region, Press NEXT again.
  • Choose either generating the table on a new sheet or on the same sheet
  • click on FINISH


See if this helps.

Regards,

Katie


 

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips


Server loaded in 0.1 secs.