Excel Basics #20: Data Analysis Pivot Tables PivotTables

[@excelisfun]

Dear CLYVOUS, I am glad that you liked the video! I'll keep making them! --excelisfin

[@excelisfun]

Dear vanniesha1, I am glad that you liked the videos! OK! I'll keep making them! --excelisfun

[@excelisfun]

I am glad that you like the video!

[@excelisfun]

I am glad that you like the videos!

[@excelisfun]

I am glad that it helped! Here is another video title I made: Highline Excel Class 20: Pivot Tables 20 Examples

[@barnabasyohannes6338]

The guy makes it interesting with his humor and emotion. Knowledgeable, skillful, and able to teach --best instructor ever!

[@excelisfun]

You are welcome!! I am glad that the videos are helpful!

[@steviori]

This is the best instruction of Excel ever. I spend several hours to learn the "Excel Is Fun!" on your website. And I believe it will save me thousands of hours in my future work. Very very good instructor! Good luck forever!

[@excelisfun]

Dear alaaahmed, I am glad that you like the videos! I may not be the best (The Best Excelers are at the Mr Excel Message Board), but I am a guy having fun with Excel! --excelisfun

[@excelisfun]

Dear workhardsleepsound, No, not great, just a guy having fun with Excel!! I am glad that the videos help. --excelisfun

[@stephenput007]

Thank you so much for putting all of these. I can not tell you how many times you've helped me professionally! I literally just got a promotion and my excel skills (learned by watching your videos) played a big role in that. Your videos are always clear, informative and short and to the point!! Keep up the good work! I love learning new things in Excel.

[@excelisfun]

@Astroboy25 , you are welcome for all the videos!

[@excelisfun]

I am glad that you like it!

[@excelisfun]

I am glad that you like the vid!

[@excelisfun]

PivotTables do rock! I am glad that you like it!

[@excelisfun]

@Astroboy25 , there may be a blank cell, or the dates are stored as text. It can't group if there are blanks or dates as text.

[@excelisfun]

The key to getting exactly the video you want from the excelisfun channel is to search for and watch this video: Search For Excel Videos Download Excel Files excelisfun After you watch that you will know how to get to the Playlists. Then in the Playlist look for the "Payroll" Playlist.

[@excelisfun]

I am glad that you like them!

[@excelisfun]

You are welcome! I am glad that they are useful.

[@Mando_Lando]

I've seen flyers for $100 excel classes, but always thought it was a waste of money. Thanks for making these videos. They are awesome.

[@excelisfun]

Saving thousands of hours at work is why i post the videos!!

[@AmandaNagleChicoine]

This (and you) are the best thing I have seen in a very long time. Sir, you have a real talent! It is all so interesting and I have seen plenty of Excel Tutorial's and they were anything but! I am starting my dissertation soon and I noticed you had Excel and Statistics- plus it occurred to me if I watch all your videos (maybe an hour or 2 a day) I'll be a whiz. With all the new thing's I didn't know about, my dissertation will be done, probably published and I'll be Dr. Chicoine! THANK YOU!!!!

[@workhardsleepsound]

Hey, everyone here says you are great. What else can I say?.... YES, You Are Great!! Your video made excel so easy now for me. It ever was a confusion.. Thank you and God bless you!!!

[@rgrimes549]

I just subscribed to this channel. I can't believe I didn't find this amazing collection of Excel tutorials until now. The teacher is great and sounds like he is really interested in the subject and is very enthusiastic. This makes for very engaging viewing.

[@fizixx]

This THE BEST tutorial about pivot tables! I just spent 2 hours looking thru the various tutorials, and the others make it impossible to find the files to download, or they don't bother finishing the tutorial, or something. THANK YOU for the help. I'm very good with excel, but I know little about pivot tables.

[@excelisfun]

The video shows the field list on the right (Excel 2007) and then the pivotTable area, which has the pivotable options shown as Excel 2003) - so to match what you see in the video, drag and drop the fileds just as you see in the field list (right side) - then you should be able to get it to look like in the video.

[@excelisfun]

Thanks for the EXCELlent comment!

[@excelisfun]

@cardenasadi , you are welcome!

[@excelisfun]

Ctrl + 1 formats the cells, and if the PivotTable moves and uses different cells, then the Field does not know to move the formatting. However, if you use the Field Settings dialog box, the Field knows that it is formatted and when you Pivot the PivotTable, the formatting moves also.

[@excelisfun]

@iRyanww , I am glad that you like it!!

[@jennyzbz]

I love all the Excel tutorials by ExcellsFun! You really make Excel seems a lot more exciting and useful! Have learnt so much from you! Really appreciate these awesome tutorials! So clear, concise and interesting! Didn't realise there is so much Excel can do! Thank You!

[@excelisfun]

Dear manujarvinen, You are welcome! I am glad that it helped. --excelisfun

[@excelisfun]

This is video #20 in the Excel 2007 series. Sorry for the confusion...

[@excelisfun]

Dear kindred122 , I am glas that you find the videos useful! That is why I post them. I have about 20 videos on Pivot Tables. If you go to my channel, watch the introductory video and it will show you how to find the Pivot Table "Playlist". Let me know if you can't find it. --excelisfun

[@excelisfun]

I will make a video tomorrow! Do you know how to use the excelisfun channel to get the latest posted video?

[@excelisfun]

YOU ARE WELCOME!

[@excelisfun]

I am glad that the video helps!

[@excelisfun]

Dear hosafiictasikapa, It probably means that the Pivot Table was created and then converted to just values (copy, paste special, values). The only way I know to convert it back is to re-make the Pivot Table. It is common to make a Pivot Table and then convert it to a range so that user does not have to deal with a Pivot Table. --excelisfun

[@MuchLoveMa]

Have a job interview on Friday. Heard they were going to test on Pivot tables. I HAD NO IDEA what Pivot tables were. You made it so easy to follow and learn. I'm a hands on kinda person, it was great. THANK YOU SO MUCH MR. MIAGI...LOL

[@RudyDelgado]

Great pivot table demonstration as are all of your videos. I set up several pivot tables for analysis of the upcoming fiscal 2011 budget for our county's hospital district and the boss loves it. I LOVE pivot tables. Thanks for all you do.

[@excelisfun]

It is in the Excel Basics area.

[@newman785]

You are a great teacher much better explained than any books or instuctors I have ever come across

[@excelisfun]

If you set your data table up as an 'Excel Table', then all you have to do is right-click the PivotTable and point to 'Refresh'. See this video: KZbinrsLoveExcel#25: Dynamic Range for Pivot Table & Chart If you do not have data set up as an 'Excel Table', then in Excel 2007 / 2010 you have to go to PivotTable Tools Options ribbon and click on the 'Chnage Data Source' button. In earlier versions, go to the PivotTable wizard and in step 2 change data source.

[@excelisfun]

I am glad that the videos help!

[@excelisfun]

You are welcome!

[@carlosgrana]

Thank you for this pivot table tutorial. I've read books on this and still didn't couldn't get it. It was lot easier than I thought, and the group option makes a lot more easier to read. Best excel tutorial out there. Thanx again.

[@excelisfun]

Dear Tschano, You are welcome!! --excelisfun

[@excelisfun]

Try adding a new value field and in the Values Setting dialog box look through the list of "Show Values As". Depending on the version, there are at least a few "% difference from".

[@excelisfun]

I am not sure how KZbin does downloads. Try doing a Google serach - I think there is some good info there.

[@TheMrBenjamin]

Hey, Is about time I said thanks to you. Your videos are my first point of reference for anything in Excel. I have an interview tomorow. I only have a chance becuase of your videos so thank you.

[@excelisfun]

You are welcome!!

[@excelisfun]

That error usually means that you have a text date, or some other data inconstancy. If all the dates are not serial dates, it is hard to group. You may have to search through dates for problems.

[@excelisfun]

The trick is to drop the Age in the row labels, then grop while it is in the row label, then drag it to the Report Filter. That should do it!

[@excelisfun]

I am glad the video helps!

[@excelisfun]

9:35 in the video: I say in 2003 go to the Pivot Table Tool Bar drop down arrow. watch again, then try that!

[@excelisfun]

Dear Coachboot , I am glad it was of some use! --excelisfun

[@excelisfun]

Because formatting done through Value Field Settings is more permanent and thus formatting remains when you "pivot".

[@excelisfun]

Very good tip!! I love saving clicks!

[@excelisfun]

Yes, very similar, it is mostly the advanced statistical functions that they changed in 2010.

[@excelisfun]

Search for "excelisfun", then click on the channel link, then watch the auto play video - it shows how to download the workbooks.

[@excelisfun]

@parkalvarun , rightclick PT and point to Refresh

[@excelisfun]

I am happy to hear that you love them!

[@excelisfun]

What error message are you getting?

[@excelisfun]

Love is good! I am glad that you liked it!

[@excelisfun]

the 4th video in the "Various Excel Payroll & Time Tricks" playlist has most of the answer you need.

[@excelisfun]

I am glad that it helped!

Thank you very much. This is exactly the information I always wanted to keep track of my bank statements. Excel should have this video appear immediately after its installation to demonstrate pivot tables. Thank you

[@CLYVOUS]

Thank you very much!!! you are the greatest. please keep up ur excellent standard videos!!! Microsoft has to pay you for such superb explanation of their complicated stuff

[@zt.5677]

I just love these older videos. Still as valid and useful as back then, and Mike had a certain stylistic way to narrate them. I feel.

[@excelisfun]

Yes, this is old. I was younger, did not have a good mic, and did not do any editing on the video. Thanks for watching the old ones too : )

[@excelisfun]

maybe try right clicking pivottable and point to file list?

[@excelisfun]

You are welcome so much!!

[@RandomsforFuns]

So glad to have an instructor like you who is enthusiastic about the subject. Your level of excitement definitely helps with student learning outcome!

[@excelisfun]

Glad the video helps!

[@excelisfun]

I am glad that it helped.

[@excelisfun]

Dear valdez57, I am glad that the videos are helpful! Now you can help you boss! --excelisfun

[@excelisfun]

Dear angrychef1 , EXCELlent! I am glad that is helped. --excelisfun

[@excelisfun]

KZbin does that sometimes. You have to try the video later.

[@excelisfun]

It is the file at the very top -- Excel Basics.

[@excelisfun]

Dear outlawdevil , Without a description of how your data is set up, I do not know how to answer your question. --excelisfun

[@excelisfun]

Me too - The Date Trick is very powerful!

[@vanniesha1]

your the best. you make me understand so well. more than anyone else. thanks very much . keep up the excellent work

[@excelisfun]

Right-click, PivotTable Options, on Layout & Format tab Check "For error values hsow"

[@excelisfun]

I am glad it helped!

[@excelisfun]

@ishaq79 , I am glad that the videos help!!

[@excelisfun]

Here: people.highline.edu/mgirvin/excelisfun.htm Excel 2007 Basics section

[@PlayMoreLoud]

@ExcelIsFun Thanks! You're a life saver. It strikes me as an obscure way of doing it. I think they should make this type of function much simpler.

[@excelisfun]

No. For all Pivot Tables if you want to update, you have to right-click in Pivot Table and point to Refresh.

[@excelisfun]

That is it, but you must scroll forward through the sheets to get to that sheet.

[@excelisfun]

people.highline.edu/mgirvin/ExcelIsFun.htm In the Excel Basics for Excel 2007

[@excelisfun]

You are welcome! Habe fun at the interview .

[@excelisfun]

Search for this video title and then watch it: excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks

[@jlynnkarpins]

Great instruction! I've watched a lot of videos and these are very clear. Thanks a bunch!

[@cardenasadi]

Great tutorial! Thanks for taking the time to add tutorials...

[@Educated1ify]

You totally Rock!! Your videos have help me professionally as well. It's so easy to follow along with you..Can't thank you enough...Keep up the good work!!! I LOVE EXCEL :-)

[@excelisfun]

You are welcome! What were you drinking to cause such a burp?

[@excelisfun]

Glad you like it!

[@excelisfun]

people.highline.edu/mgirvin/excelisfun.htm Excel Basics 2007 section

[@akbender]

This helps me so much to learn for my IT exam!!! I just love you! thanks a lot!

[@excelisfun]

here: people.highline.edu/mgirvin/ExcelIsFun.htm

[@tykeintsouth]

Clear and informative as always. Thanks. When you've created a table can you then analyse within the table (eg product of some of the columns) or do you have to copy and paste values elsewhere and then analyse further?

[@MyFavouriteOfAllTime]

You are amazing. I actually think Excel is much more fun now. Thank you so so much.