Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to create a pivot table in Excel 2013?

How to create a pivot table in Excel?

user-image
Question ajoutée par Mohammed El Tahir Mohammed Yousif , Finance Manager , Factory of Golden Block Company for Cement Products
Date de publication: 2017/03/21
Phyllicia Kekana
par Phyllicia Kekana , Chairperson of REMCO , Bonitas Medical Scheme

Go to insert

Pivot Tables

Choose Data source

Arrange the data the way you want to present it

Create pivot chart

Ahmed Farouk Mahmoud
par Ahmed Farouk Mahmoud , Country HR Lead , Ali Bin Ali Group

a good option in Excel 2013 is to select your data then click Ctrl and excel will give you multiple options to utilize your data, one of the options is Tables; which will recommend most obvious 4 tables, if not the required pivot, select More and build your own.

Firas Shahadi
par Firas Shahadi , Human Resources Director , SAUDI UNION

Good question

just select a cell inside you data.

go to insert tab >> insert pivot table command.

 

or use the very fast way

Alt+N+V

 

done.

Hope this helps you.

Mohammed El Tahir Mohammed Yousif
par Mohammed El Tahir Mohammed Yousif , Finance Manager , Factory of Golden Block Company for Cement Products

To create a PivotTable:
  1. Select the table or cells (including column headers) containing the data you want to use. ...
  2. From the Insert tab, click the PivotTable command. ...
  3. The Create PivotTable dialog box will appear. ...
  4. A blank PivotTable and Field List will appear on a new worksheet.

More Questions Like This