↑ Return to Pivot Table

Presentation

A Pivot Table is a powerful tool which calculates data very easily. For some reason I can not explain, many people thinks that the knowlage of a pivot table is the ultimate stageĀ  of Excel. But, if you know how to drag & drop, you can work a pivot table.

Beginning

To create a PivotTable, you just need a data table, simple, without subtotal. But one thing is compulsory, your column must have a header.

A common mistake is to try to activate a pivot table with a document that already contains the intermediate calculations (like the example where you have subtotals).

For instance, you can not create a pivot table with this document. If you try, you will have this warning on the screen. To make a pivot table, just use the raw data and it is the pivot table who will do all the calculations you want.

 

Activation

With the versions 2007 and 2010, you can activate the tool by clicking on a pivot table this icon in the Insert tab.

For the earlier versions you find the tool ins the menu Data / pivot table

Then, you fill the range of cells your your data is and the structure of the pivot table appears on the worksheet.

Interface

There is a significant difference between the versions 2007 / 2010 and the earlier. However, older versions have the potential to make drag / drop much more convenient than current versions. This is why, I prefer to check the option new version ‘so-called’ classic, we will only work on the classic version.

Once you have changed the interface you see on the left structure summary table on the screen. On the right you have the list of selected column headers (hence the need for column headings at the time of selection)

33 comments

Skip to comment form

  1. Anonymous

    really nice, too bad you don’t provide the excel file to practice while following the tutorial

  2. No hai hitla

    weaboo

  3. Anonymous

    phucers

  4. No hai hitla

    Dis thing is a MESS

  5. Hai Hitla

    dr agmen

  6. Hai Hitla

    hav u sin saaaaaaaaaaaaanic?

  7. Hai Hitla

    Karrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrla

  8. sancho panza

    hola karlangas

  9. Hai Hitla

    hola rapapauuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

  10. sancho panza

    estoy fuera, ya no me escriban

  11. Rapapauuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

    hi my name is jefffffffffffffffffffffffffffffffffffffffffffff

  12. Jefffffffffffff

    hi mi neim is jeffffffffffff

  13. Hai Hitla

    Hows it going bros ma name is pewwwwwwwwdiepieieeeeeeeeeeeeeee

  14. sancho panza

    ola k ase

  15. juana de arco

    sweden!

  16. RAAAAAAAAAAAAAPAPPPPPPPPPAUUUUUUUUUU

    RARAAAS MIS AMIGAS

  17. Hai Hitla

    DEUTCHSLAND!

  18. juana de arco

    solos la lady gaga

  19. Hai Hitla

    juana de arco, Miley Cyrus quiere tomar tu puesto

  20. Hai Hitla

    explotaria el mundo

  21. Hai Hitla

    69 mas 666?

  22. juana de arco

    yo 69

  23. Hai Hitla

    Cuanto es 1 mas 1?

  24. juana de arco

    amorrrrrrr fritangerooooo

  25. Hai Hitla

    Quien quiere ir a la fritanga conmigo???

  26. juana de arco

    han escuchado la cancion de amor fritangero

  27. juana de arco

    this is shit

  28. German Napolion

    no puedo hacer esto I give UPPPPPPPPPPPPPPPPPPPPPPPPPPP

  29. juana de arco

    kawaiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii

  30. Anonymous

    So kawaiiiiiii

  31. juana de arco

    como te va karla

  32. German Napolion

    hola Jaime

  33. German Napolion

    hello my dear friend

Leave a Reply

%d bloggers like this: