Building a Pivot Table in Excel 2010 -- Part 1
HTML-код
- Опубликовано: 21 авг 2024
- Get the free 7-hour Learn Excel 2010 course. Over 70 videos to help you master Excel. Click here to get the free course: simonsezit.lea...
Watch the full course at SimonSezIT.com
In this 4-part series on Microsoft Excel 2010 Pivot Tables, we start with Part 1 -- the basics of creating to use Pivot Tables.
Get the full course on Excel 2010 course here: www.simonsezit...
Excellent class. Clear and straightforward. Highly recommended.
You are a very good teacher. I wish all University professors in the world are clear in their teaching as you are...and I am not joking. Well done. Thank you. Keep it up. (from Malta)
This was the most important feature I had to learn to use. Thank you very much.
I can NOT believe i didn't know about this feature. It is so important and relevant to my work.
Thank you very very much. Video is well done, simple to understand. Thank you for taking the time to explain in great detail. Very helpful.
Ctrl + T = Excel Table ::MIND BLOWN::
this was a good video. I had to sift thru 10 LONG ones to find this gem.
Really good video. Lots of information presented in a clear and good example. Thanks
Thanks Mr Proffessor! It's really really well explained and clear. I'm following you from now on! :)
Ramon Pijoan Thanks Ramon. All the best with your Excel training!
The series of excel pivot videos uploaded were very informative . Thanks a lot for your efforts . It really helped me in understanding the concept behind it very clearly through these videos.
Thank you so much for these tutorials. You do an excellent job of teaching.
Thank you for your kind comments ;-)
Great video. I really appreciate the effort put in to show in detail how the pivot tables/charts work. I will feel far more confident now in my work when using them.
Great tutorial. Am applying for new job which I believe a knowledge of pivot tables will help obtain. Thank you so much for these videos.
Good luck with the job application ;-)
I like your way of teaching. I was able to understand right away. Thank you.
Thank you Mary ;-)
I work in an auction and I use excel, and I do pivot tables every Monday, Thanks for sharing.
Janie Melgoza Thanks for watching and your comments.
Very informative, covering detailed practical application and use. Great service.
Good way of teaching sir. I understand about pivot chart in just one view!!
besides I prefer british accent too. Keep up the good work!!
Thanks very much for your kind comments. All the best with your Excel learning ;-)
Thank you - I picked up some good tips - off to create my first pivot table!
I am new to pivot tables/charts, thanks for making such an easy to follow tutorial!
Thank you for your time and clarity. This has been very valuable to me.
Maria Chat You're very welcome, and thanks for watching!
I like the "control-T" to make a table instead of selecting the table range each time!
You're an incredible instructor. Thank you for these!
***** Thanks for watching and the feedback!
Excelent videos, very easy to understand thank you SimonSezIT from Caracas Venezuela
Good job Simon, thank you for clear explanation. So clear makes me enjoy the lesson.
Thanks alot for the tutorial. Clear and concise!
Excellent tutorial!
Extremely helpful tutorial!! Thank you very much!
Thanks for sharing - what a time saver!
Thank you so much, for your taking your time and explaining the pivot table step by step. Best video every!!!!
+Vee Tech hanks for watching and for your kind comments ;-)
+Simon Sez IT Apologies for the typo, I meant "Thanks....." :-)
No problem, this video has help me with my homework.
+Simon Sez IT KITÉÉÉÉÉÉÉDEKEEE?
thank you teacher your learning method is very well.
This is awesome, very easy to follow! I just subscribed! Thanks!
Thank you Sir for this great video.
Excelent information! Thanks!
You are the man!!!
Excellent! Very helpful.
+Tarek El Hajj Mohamed Thanks for watching and for your comments!
This is very good, thanks.
I am looking forward to the training.
Is it necessary to make the data into a table? Isn't it already in a table format? What does this do to better the Pivot Table? Thanks, these are fabulous! Very clear to understand.
It is relevant in applying audit analytical procedures
great stuff - thanks for this - most excellent.
Excellent video. I enjoy the pace of the course and his voice. Very informative.
Do we have access to the original data set being used in the video? It would be so helpful mirror the instructor while watching the video.
thanx for such a great video training .its help me lot..........:)
thanks for this!
Excellent.
Thanks!
Thank you for the informative videos. I am a beginner and trying to absorb all this info! What would be most helpful is knowing if a PIVOT TABLE/Chart can be used to track test percentages of employees when several tests are involved and an average of a groups percentage? I may be jumping the gun and need to watch more videos. Thank you again.
Thank you
Thank you Sir
thank you very useful this video
I can't really learn what you're teaching without having the same files.
thanks for sharing
Great tutorial... Some advice: The transitions were too slow. Lose the fancy transition and just cut or use a simple fade.
Great content and depth though. Thank.
thank you :)
great series, helped a lot. Is there any way of getting hold of the data set? Playing around with it would be a great help, cheers
video starts at 1:45
thank You it is useful
Well Done
skip to 1:44
Why is the value for smoothies higher than gross sales? Other than that great video!
because he's punched in random figures just for the purposes of this instructional video...
don't even skip to 1:45 because that is for pivot chart not pivot table
good
try to get to the point in the future.
Excelent
got a job interview in an hour and a half! stop beatin round the bush bro!!!
I've found some decent sample pivot data to follow along with your tutorial but it would be great to have your same data. Anyway to make that available?
Apologies Trevor, there is no sample data available :-(
Only 2 out of 3 people who viewed this video viewed to part 2. Ranking of "Amateur" because: More than 3 minutes of introduction before infomation given for a 14 minute demo. Then frequent re-introduction of the same things. Slow reading of obvious text on screen. Constant vouching of ease of use; "straight forward," "easy," "just." Slow introductions then much useful information given in de soto voice. Be respectful of audience's time and intelligence to increase rating.
Is it possible to download the workbook you are using in order to practice with it?
any chance you can upload the data so that I can have a play around myself?
Can u write definition in few lines, if some one asks to explain what is pivot table
Did you end up finding practice data?
Your voice sounds like Hugo Weaving's voice
Gross Sales is not a department. Is that an error in the data ?
I havent as yet. could you upload this data set?
AWIITE MATE IM FRAM GRAVESEND INNIT
how can you stop the pivot table to calculate the year. Cause I have a table Year and it freakin calculate all the year... I have it as 2010, 2011, and 2012.
Why would Gross Sales be part of your data? You cant say Gross Sales are 50% of total sales, its just a total not a number..... ???
It will NOT download for me.
да есть тока 2 я и ты
Thank, hated the transitions though, they were old fashioned, slow, and made me feel nauseous
Tedious...provides information like pouring molasses in winter.....
А русские куда делись???
wait this isn't porn. why am i watching this?
Quite Boring
This is awesome, very easy to follow! I just subscribed! Thanks!
Vijian Narayanasamy Thanks for watching and the comments.
Thanks !