Excel Basics #20: Data Analysis Pivot Tables PivotTables
HTML-код
- Опубликовано: 15 дек 2008
- Download file: excelisfun.net/files/ExcelBas...
Download file: people.highline.edu/mgirvin/Y...
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#20 Video topics:
1)PivotTables Pivot Tables Basics
2)Most Powerful Excel feature for summarizing data
3)Summarize Data Quickly
4)Group By Date
5)Format Fields
6)Format Pivot Table
7)Pivot the table
8)See Pivot Tables in Excel 2003 and Excel 2007
9)Page Filter
10)Show Page Filter
11)Report Filter
12)Show Report Filter 
Наука
Dear CLYVOUS,
I am glad that you liked the video! I'll keep making them!
--excelisfin
You are welcome!! I am glad that the videos are helpful!
You are welcome! I am glad that they are useful.
Dear workhardsleepsound,
No, not great, just a guy having fun with Excel!!
I am glad that the videos help.
--excelisfun
Dear vanniesha1,
I am glad that you liked the videos!
OK! I'll keep making them!
--excelisfun
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!
I am glad that it helped!
Here is another video title I made:
Highline Excel Class 20: Pivot Tables 20 Examples
I am glad that the video helps!
I am glad that you like the video!
I am glad that you like them!
I am glad that you like the videos!
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
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.
I am glad that the videos help!
You are a great teacher much better explained than any books or instuctors I have ever come across
I am glad that you like it!
I am glad the video helps!
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!!!
Dear Coachboot ,
I am glad it was of some use!
--excelisfun
I am glad that you like the vid!
Saving thousands of hours at work is why i post the videos!!
I am glad the video helped!
I am glad that it helps!
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.
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 : )
I am glad that they helped!
I am glad that it helped.
I am glad that it helped!
Dear manujarvinen,
You are welcome! I am glad that it helped.
--excelisfun
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!!!!
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
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.
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
YOU ARE WELCOME!
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.
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.
Me too - The Date Trick is very powerful!
Very good tip!! I love saving clicks!
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.
I am glad it helped!
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
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
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.
This is video #20 in the Excel 2007 series. Sorry for the confusion...
You are welcome so much!!
Dear valdez57,
I am glad that the videos are helpful! Now you can help you boss!
--excelisfun
You are welcome!
Dear Tschano,
You are welcome!!
--excelisfun
You are welcome!!
The guy makes it interesting with his humor and emotion. Knowledgeable, skillful, and able to teach --best instructor ever!
your the best. you make me understand so well. more than anyone else. thanks very much . keep up the excellent work
You are welcome!
Habe fun at the interview .
Dear angrychef1 ,
EXCELlent!
I am glad that is helped.
--excelisfun
@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.
Now you know! Excel is fun!
the 4th video in the "Various Excel Payroll & Time Tricks" playlist has most of the answer you need.
highline.edu/mgirvin/ExcelIsFun.htm
PivotTables do rock! I am glad that you like it!
people.highline.edu/mgirvin/ExcelIsFun.htm
The trick is to drop the Age in the row labels, then group while it is in the row label, then drag it to the Report Filter.
That should do it!
You are amazing. I actually think Excel is much more fun now. Thank you so so much.
This video is much clearer than those I watched before!! Thanks so much Sir!!
You are welcome!
@Astroboy25 , you are welcome for all the videos!
Great instruction! I've watched a lot of videos and these are very clear. Thanks a bunch!
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!
Great tutorial! Thanks for taking the time to add tutorials...
@iRyanww , I am glad that you like it!!
Yes, very similar, it is mostly the advanced statistical functions that they changed in 2010.
people.highline.edu/mgirvin/ExcelIsFun.htm
In the Excel Basics for Excel 2007
It is the file at the very top -- Excel Basics.
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.
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.
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.
Here:
people.highline.edu/mgirvin/excelisfun.htm
Excel 2007 Basics section
I like the way you separate your regions into tabs with just a few button !!!
people.highline.edu/mgirvin/excelisfun.htm
Excel Basics 2007 section
@cardenasadi , you are welcome!
So glad to have an instructor like you who is enthusiastic about the subject. Your level of excitement definitely helps with student learning outcome!
Glad the video helps!
Go to this web site and watch the auto play video, it shows how to get to all the files:
youtube[dot]com/user/excelisfun
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!
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:
RUclipsrsLoveExcel#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.
EXCELlent!!!
this presentation is exactly what i needed. AMAZING
I am happy to hear that you love them!
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 :-)
Love is good! I am glad that you liked it!
This guy is good at explaining things
Thanks for the EXCELlent comment!
Thank you Thank you Thank YOU! You have helped me so much and you also have perfect diction!
Search for "excelisfun", then click on the channel link, then watch the auto play video - it shows how to download the workbooks.
here:
people.highline.edu/mgirvin/ExcelIsFun.htm
@ Excellsfun.. You are the best!! You taught me something that I have been wanting to learn for years. Thank you! =)
Glad you like it!
@ishaq79 , I am glad that the videos help!!
@Jamesedwardkoch , thanks! I already have 100s of videos on CSE formulas that do data analysis. Check out:
youtube [dot] com/excelisfun
You are a wonderful teacher. THANK YOU sir. (Upper case to express it strongly)
thank you very much for helping us to learn pivot table and other functions...
It is in the Excel Basics area.
Love, love love pivot tables. I am known as the Pivot King but think this should be re-evaluated after watching your vids :). I like to have my years data in PT format and add to previous years then use the filter drop down to toggle via year. Keep up the good work.
Thanks bro.. that is really amazing... I learn a lot from your videos. God bless you...
You are welcome a tera!!