Introduction to Excel Pivot Tables

[37no37]

0 Times 18 23 54 55 56 57 58 59 1 Time 14 30 35 47 2 Times 6 12 19 20 21 25 27 33 36 40 41 46 49 53 3 Times 1 2 5 7 8 13 17 29 31 32 43 50 4 Times 4 15 22 26 28 44 45 52 5 Times 16 37 38 39 42 48 51 6 Times 10 11 24 7 Times 9 8 Times - 9 Times 3 10+ Times 34 how to get ffrequency like this

[elegantserenade]

Great tutorial. Very easy to understand.

[DannyRocksExcels]

@elegantserenade

Thank you for adding your comment. I am pleased that I was able to help you to understand how to work with Pivot Tables in Excel.

Danny Rocks

The Company Rocks

[coolkenny13]

@DannyRocksExcels hi danny , im plannign to go for a course in excel . its called advanced excel where they teach you formulas , s look ups , v look ups , creatings pivots etc. now i only know the basics of excel . i dont know head or tale of formulas . how easy is it to grasp all this ?

[DannyRocksExcels]

You do this in the "Group Field By" dialog box. There you can decide the "Frequency Distribution" for your Pivot Table. E.g. Start at - 2 and Group by 10.

Search my website - thecompanyrocks. - for a video that I created. Use the Keyword Frequeny in the search box.

Danny Rocks

The Company Rocks

[PlayMoreLoud]

Let's say I have a list of 'ages' in my table. I add the 'ages' to my report filter but the report filter only shows the ages individually as they appear in the table. I want the report filter to show the ages in ranges instead, for example: 20-29, 30-39,....etc instead of individual values. How do I do this? Please help!

[yourahova]

Thank you

[DannyRocksExcels]

@yourahova

My pleasure. Thanks for writing to tell me that you enjoyed my video.

Danny Rocks

The Company Rocks

[richhaaaaard]

HAHAHAAHAAH

[ozgursavas1]

never thought pivot tables were so easy !! thanks big time

[DannyRocksExcels]

@ozgursavas1

My pleasure. Yes, Pivot tables are really easy to create and modify. Many people, however, are reluctant to experiment with them. It is hard to believe that something as powerful as a Pivot Table could be so easy to create.

Enjoy your new knowledge.

Sincerely,

Danny Rocks

The Company Rocks

[JHakaJoeVanni]

Thanks a whole lot!!!

[DannyRocksExcels]

@JHakaJoeVanni

My pleasure. I am pleased that I could help you to understand Pivot Tables.

I invite you to visit my website (thecompanyrocks) to see many more tutorials on Pivot Tables.

Sincerely,

Danny Rocks

The Company Rocks

[Elsterclick]

nuub

[lucifreak]

this is huge, thanks man! I have to present to my research team next week, I think I'll just use your video!

[DannyRocksExcels]

@lucifreak

Thank you! Let me know how you did with your exam.

Danny Rocks

[tonylie079]

how do i add new data to the pivot table?

[DannyRocksExcels]

Tony

You can not add data directly to a Pivot Table.

Rather, add the data (rows and / or columns) to your source data worksheet. Then:

On the Pivot Table Toolbar choose Pivot Table Wizard. Go BACK to step 2 and choose the new range of data. Finish.

Finally, you will need to REFRESH your Pivot Table to update the data.

Sometimes, it is just easier to restart and create a new Pivot Table.

Danny

[meelee]

thx dude, helped me a lot.. keep up the good work!

[DannyRocksExcels]

Thank you for taking the time to write. I am pleased that the video helped you.

Danny Rocks

[pradjohn]

This is the best video i had seen explaning the Pivot table ! Danny is really rocking Excel !!

[DannyRocksExcels]

Thank you! I am pleased that my video helped you - and several others - to understand how easy it is to tap into the power of Pivot Tables.