abc MICROSOFT EXCEL 2010 - Pivot table
Creating pivot table

For data crate oivot table :proizvodi,rows Predavavi and ostvareni iznosi.Created pivot table just like on the picture


Picture 1. Prodavači i porizvodi

Creating pivot table, steps:

  1. Select data;
  2. INSERT TAB:
  3. PIVOT TABLE button:
  4. choose range .
  5. Choose place of displaying pivot table.
  6. OK button
  7. choose elemente table.
  8. edit table.
  9. The end (Kraj).

N O T E:pivot tables can just be created from already existing files
Data forCreating pivot table 1

 Index