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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
microsoft-excel-courses - pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Pivot Table

microsoft-excel-courses - Pivot Table

ResolvedVersion 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.