Advanced Excel - Creating Pivot Tables in Excel

Подписаться 1,5 млн

Просмотров 2,5 млн

0% 0

Learn how to create pivot tables in Excel and how to use them to draw out the information you want to see. Pivot tables are intimidating to many Excel users, but they don't have to be. This tutorial clarifies and simplifies the key information you need to get started using pivot tables in Excel. Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Click here for the example Excel file used in the video: bit.ly/pivotsynth
Join this channel to get access to perks:
/ @techteachersandstudents
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
See below links to the CDs and bands mentioned in the video:
The Killers - Wonderful Wonderful: amzn.to/2G7AKlF
Brandon Flowers - The Desired Effect: amzn.to/2G6gBMG
Blaqk Audio -Material: amzn.to/2DUOfo1
Covenant - The Blinding Dark: amzn.to/2n1J0uH
Depeche Mode - Spirit: amzn.to/2E0BUio
Erasure - World Be Gone: amzn.to/2G46U1t
Future Islands - The Far Field: amzn.to/2DC7yVx
Hurts - Desire: amzn.to/2DX6Dww
OMD - The Punishment of Luxury: amzn.to/2DpzVmA
The Frozen Autumn - The Fellow Traveller: amzn.to/2DXfA9f
The Jellyrox - Bang and Whimper: amzn.to/2Drnvue
Ulver - The Assassination of Julius Caesar: amzn.to/2DoFLEB
***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...

Хобби

Опубликовано:

26 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 710

@corytatum2229 4 года назад

Came for the pivot table, left with a new playlist!

@size8kate 4 года назад

LOL

@nbkuycd 4 года назад

@jigri_pokhri 3 года назад

I think that was OP's plan. Well played OP, ULVER rules!

@papa5637 3 года назад

ahahahaha

@eurisko7119 3 года назад

me too.

@agr3131 5 лет назад

I am an older person that normally finds this type of new information very confusing. Thank you for making it easy to understand. God bless you.

@vtvita 3 года назад

FACT: Everyone is older every minute of the day! And your comment is very nice.

@calybwilliams5565 2 года назад

I already liked this guys tutorials so much and now he keeps mentioning the killers! Can this guy get any better? It's pretty wonderful wonderful

@tracymendiola8345 6 лет назад

Just took the official Excel tutorial on Pivot Tables and I can say that yours is much better.

@steve94044 5 лет назад

I've been a phone co. tech in the field for 38 years and recently hired back to work in a Lab environment. Your video's have helped me to understand how to navigate and use Excel. Thanks!

@bethw2424 6 лет назад

I have gone through many different excel tutorials recently in my attempt to understand how to use it and nothing has been as helpful as this series! You have a great way of breaking down the information and explaining that makes for very effective learning, thank you so much, hanging out for the next one to come out! (Hopefully this Monday?)

@sabestianmascarenhas7462 4 года назад

Same here

@GearheadExplorer85 3 года назад

I laughed out loud at the 4 tips you provided prior to setting up the pivot table. On my tool database at work, I pretty much broke every single one of those rules. However, my excel skills weren't as advanced then as they are now.

@mansoorthottiyil 2 года назад

Absolutely right

@lakapenostra 2 года назад

im a highschooler and im relearning excel in my 1st year and its very helpful..

@MsShemetov Год назад

Same here! Big Thank you,

@michaelalderete9622 3 года назад

I've put off learning about pivot tables for quite a few years, and suddenly need to know for my work. This tutorial and example are amazingly clear, with the process steps and rationale quite easy to follow. 16 minutes is a good length for a one subject tutorial, and this is why I chose to watch this first among other RU-vid videos I'd found. Well done!

@yolaktv7274 5 месяцев назад

I love how this guy simplified the terms. I was a quality analyst before but transferred to a non-voice and now I'm rusty. Not only I was refreshed by these tutorials but I actually learned new things that could've made my life easier as a QA before. Thank you dude!

@joaoviegasalmeida9361 2 года назад

Your work is amazing sir, I thank you immensely for this support. I'm a Brazilian student, doing a Business Administration Major Degree, your videos are, indeed, extremely helpful to my work and academic life! May the universe always reward you, for your kind and precise work!

@gloriabelford7020 2 года назад

I needed a refresher course as I have not used V-Lookup and Pivot Tabels in a few years. This is the best tutorial. Very easy to understand and the communication is great!!!

@marybev77 5 лет назад

What a beautiful voice you have! Thanks for the tutorial.

@TheJester-ct5pi 3 года назад

*Bane Voice* "That's a lovely lovely voice"

@twilight9237 3 года назад

Love how you smoothly explain the excel concepts along with letting us into your music favourites ♥️

@vtvita 3 года назад

Agreed. Well said.

@tanzilahasanpinky8748 Год назад

I started learning again about Excel after many years and my supervisor suggested me your channel. All I can say, your videos are the clearest among all of the others I viewed and I was able to do per my need. Thanks a lot

@deanatoribio9574 4 года назад

So glad I have this video to watch. I haven't learned a lot more than what I knew before from just basic Excel. Didn't realize I could make tables like this and have a video to follow along. Thanks for making these videos.

@vmperkins9168 5 лет назад

Thank you so much. Out of all the videos I have watched this one is very easy to following along with and under- stand. I'm a subscriber now.

@zenzybar 3 года назад

I love that I came to learn about pivot tables, and left with recommendations for a whole load of music in a genre I don't listen to, along with now knowing how to handle a pivot table. Best tutorial I've ever watched.

@ronalda.saname396 3 года назад

My favorite types of music: Blues, Classical, Flamenco, Rock/Hard Rock/Heavy Metal, Jazz, and Reggae. All are GREAT musicians. Like BB King, Miles Davis, Paco DeLucia, Vladimir Horowitz, Jimmy Page, Ritchie Blackmore, Bob Marley, and Bud Powell (Jazz) Pianist. Love your video, check out Jimmy Page and the greatest Flugelhorn player ever Clark Terry. Check out Heart, Miles Davis, BB King, Deep Purple, Led Zeppelin, Sabicas, Rainbow, The Who, AC/DC, some Beethoven, and Chopin.

@2094studios 4 года назад

The best Tutor i have come across in a long time. I always find myself back here when i get a student to teach. Thank you so much

@khairallahdh 6 лет назад

Needed to brush up on pivot tables for an internship and this was super helpful! Thanks a bunch! Looking forward to that future video!

@ohThatsTeku 2 года назад

Im starting mine in January, doing the same thing!

@anjalirajagopal4841 2 года назад

even im starting mine

@cpnaresh 4 года назад

thank you, after so many years of using excel, I learnt to use pivots and its so simple, great job!

@mlauracampos 4 года назад

Man, you are like the best. I just can't tell you how grateful I am for finding your tutorials. I know literally nothing about excel. Will have a job interview in a couple of days, and now I am like this pro fully prepared candidate. You just rock!

@davidcallen2166 3 года назад

I needed a refresher on Pivot Tables. This is a bulls eye for me as it explained the essential features, how to build a table ready for developing a Pivot Table, then illustrated how to use the the features and for what purposes.

@dreamchaser4822 Год назад

Thank you! You understand what really matters to the user and explains it in a clear and easy to understand fashion that no other tutors can.

@knaw35 4 года назад

I went through few pivot trainings on YT and none of them was as useful as this one. Why? All teachers and experts treat me as I have some things sorted out already. They have no idea that even one single information can open a door which remains closed if not defined correctly. In this presentation the most valuable for me was how the table should looks like before starting pivotal part - and what was more important - what should not be included in the table or what should not be done (as for example comments or purchase sum). I like also that he is playing with pivot table fields what gives in the end good overview what it is about. Thank you, teacher!

@manekpr 2 года назад

These videos are so helpful! I need to learn excel for a job test and I’ve been watching and practicing with them. I was feeling so lost and nervous, I didn’t want to blew my chances at a better job because of Excel, but I feel so much better!

@tahirrizwan3732 Год назад

An easy and to the point to explain Pivot Table. Great job.

@wendyreyes95 3 года назад

I know the basic since we used to have it at work. and from what I learned today from the tutorial. I am more likely to catch up the step by step tutorial pretty easily. ANd now, I begin to further my knowledge with your help. Keep up the good work!

@Birbborb000 6 лет назад

Your explanation is so easy to understand and I'm so grateful that I found your tutorial video!!! Thanks

@sashi6736 6 лет назад

The tutorials are amazing! Although I have Excel skills, I learn diff. key functions and short cuts. Thank you!

@Magpieme98 3 года назад

First thing first, as a child of the 80’s, I adore your music choices! ☺️ Second, I have applied for a promotion at work and I will need to become more proficient in excel. Your videos are so easy to understand and explain everything so clearly that I am sure I will be much better in no time at all! Thank you so much for this education, I appreciate you more than you know

@ronalda.saname396 3 года назад

@karthikkiran338 2 года назад

I'm just curious.....what kind of work do you do?

@kelvinbenjamin4832 2 года назад

P00p0000po

@fileagramaje8521 2 года назад

Such an easy way of learning about pivot tables. You made it so easy to understand. Thank you. You're amazing.

@MidnightTrigger650 5 лет назад

You literally just saved my life man, thank you so much for these tutorials!

@georgerest2115 3 года назад

Love your videos, so clearly explained and helpful, currently applying for a resource analyst job, feel a lot more confident with excel after watching your videos!

@mrblaze044 6 лет назад

I watched all your excel tutorials and it's all amazing. I'm not a native English speaker but I understand all your words perfectly. Wonderful voice too. Thank you!

@brendamaxwell181 3 года назад

I LOVE YOU TECHNOLOTY for Teachers and Students!! I always wanted to get into this - It will def. take me some time to get - BUT THIS IS FRIGGIN AMAZING! I AM IN LOVE ALREADY!!

@beautyteen15 3 года назад

So helpful! Easy to follow - simple and to the point. Thanks!

@fernandovera9207 4 года назад

Very well explained! The pace is right on the money. The rational why you do this or that is also very helpful for this initial learning. I watched a least 10 videos about this subject and seriously learned nothing and got frustrated that a tool that suppose to be so useful is hard to understand.

@tloubonolo4460 3 года назад

Your voice and teaching method just makes me want to learn more . thank you

@SergioInzunza 3 года назад

Educational with a dash of humor, amazing work. Thank you!

@jenardennedeleon3603 4 года назад

THANK YOU FOR THIS WONDERFUL TUTORIAL! THIS IS AMAZING!

@wineblue2 2 года назад

After 2 years of being laid off due to Covid this was a nice refresher heading back to an employed state. On a side note, I personally record a lot of Synth and Depeche Mode still rules! LOL!

@Impurfecther 4 года назад

Thank you for this video. Your videos always make Excel easier to understand.

@choobv2 2 года назад

A wonderfully clear and precise tutorial, thank you so much.

@paulmclean1268 Год назад

Formatting data as a table before creating pivot.... genius. That has saved me a lot of headaches. Thanks!!

@ianbovic1802 6 лет назад

Watched all your excel tutorials and its excellently explained and demonstrated kudos!

@gabrielfreeman8660 Год назад

OH my gosh...THANK YOU. My Pre rec class is teaching about pivot tables and after all the reading I was so confused, and now after watching this I know what pivot tables do now, thank you again. Also: Connecting this to your own interests made this fun

@michelemcnally6598 4 года назад

Your V-LOOKUP and PIVOT TABLE tutorials are fantastic! The information is clear and concise, and the pace is perfect! I am viewing them as a refresher, but I would recommend them to beginners as well! Thank you for putting useful and free content out there! I appreciate you!

@michelemcnally6598 4 года назад

I want to add that my state has been under a "stay at home order" due to the Corona Virus. I have been itching for something to binge on that is a bit more stimulating... your playlist fits the criteria! I am now happily geeking- out with a cup of coffee, my dog, and YOU! Thank you and wash your hands! ; )

@vtvita 3 года назад

Agreed, and your comment is very nice.

@matthewhassan3133 5 лет назад

Great video - very helpful. Thank you!

@Noelle7676 5 лет назад

Incredibly helpful! Thank you for posting

@user-yi5hu8qw4s 10 месяцев назад

A wonderfully clear and precise tutorial, thank you so much.. So helpful! Easy to follow - simple and to the point. Thanks!.

@alanhill5756 Год назад

I have never heard any of the music in your list, neither have I even heard of the genre. At 76 I bet I am not missing much. Your videos are really good and I thank you.

@davidchao685 3 года назад

Thanks for the easy-to-follow instructions and good examples. Also, I love the content used for this tutorial.

@kumheekwag2553 5 лет назад

Thanks for all of your amazing tutorials. Please keep uploading more videos!

@trep1269 2 года назад

You are giving me peace of mind as I prepare for an interview today to discuss pivot tables. Thank you.

@Kailasha502 2 месяца назад

One of the best Pivot table tutorial I have ever watched! Thanks!

@bluewaves9298 3 года назад

Greetings from Istanbul-Turkiye and many thanks for your help. It really was very helpful and easy to understand. Thanks.

@worldsbestaquarium08 3 года назад

You are an Excel God! you saved me having a panic attack. Made my life soooooo much easier!

@HellAtlantic 3 года назад

I absolutely *loved* the synth pop genre as an example, so much so that I clicked like and subscribed. The tutorial or guide was very concise and informative - typically I need to be hands on the learn but the way you went about making this video I can absolutely replicate what you did without needing to do it myself. Great teacher and music lover, you got yourself a fan.

@milliet4982 4 года назад

Once again...you do not disappoint! Thank you.

@jenniferkim9325 3 года назад

I've been trying to learn Excel, and the tutorials I've found before this one were so monotone, dry, and boring that I couldn't stick with them even though their content was good. This is the first video I'm watching in your playlist, and your synthpop joke was so refreshing, I went back to replay the video from the top, and decided to leave my first RU-vid comment ever.

@sheepma9905 2 года назад

Your tutorials are very helpful and great. I even like all the CDs you recommend. Thank you for sharing.

@maruemmanuel6319 2 года назад

I had faced difficult during an interview creating a Pivot table, it was something new for me to hear. As I see it would have been a 1 minute work.

@1987phil48 Год назад

Very good and straightforward! I understood this video a lot more than others I have seen.

@aceaxel1255 4 года назад

this guy has done everything from the top to the bottom only for us and he has given his time to put in all the links in the bio as no other youtuber would do Hands Off to this guy :) :) :) ;)

@vtvita 3 года назад

You mean "Hats off," don't you? Otherwise, Yes!

@christianweyrauch4909 5 месяцев назад

Love the music from the table. Agreed with your choices! Best music! Oh, and excellent tutorial as well!

@saraheisel9457 2 года назад

Thank you for a clear, concise tutorial. I was having trouble managing the data in my pivot tables and this tutorial has me starting them more logically. Much easier. Thank you!

@ama_kwame Год назад

you are my best excel tutor. You bring so much clarity charley. On behalf of all excel learners, thank you! and we love you.

@vhector480 2 года назад

Very helpful. I finally understand how to build Pivot Table. I will put it in practice this week !!! Amazing thanks!!

@keysersoze9271 2 года назад

Very well done. Easy to follow, and perhaps more importantly, I learned about Synthpop (with playlist now saved on Spotify!). Thanks!

@rachelleleduc1681 3 года назад

I am lucky to have found this perfectly explained tutorial on my first video pick. I'm adding you to my bookmark bar. Nice voice.

@laurenjatich5682 2 года назад

You're amazing at teaching! Thank you for your videos and tips!

@allan-5141 6 лет назад

Great job at simplifying a tool that, for some reason, has the reputation of being so complicated and intiminating. Whenever I see job descriptions requiring "expert" Excel skills, they always list as examples pivot tables and lookup formulas.

@PJMcInerney Год назад

Actially Pivot tables and V look ups (despite the intimidating reputation) are pretty easy once you do them once or twice

@jameswallace4191 4 года назад

Thank you very much for the informative video. I had graduated with an accounting degree two years ago and was taught how to use pivot tables, but in the working world I haven't had the need for pivot tables until recently. I've just been hired as a junior accountant where pivot tables and V-Lookup are constantly used, and while I memorized the V-Lookup and H-Lookup formulas I had a dream in which I failed a test in pivot tables. I took notes and now I'm relaxed enough for my first day of work! Thank you again!.

@cynthiaszczepaniak7050 4 года назад

Needed a well rounded explanation in a hurry for work. This is definitely it! Thank you.

@vtvita 3 года назад

This is it!

@caroline377 2 года назад

These videos are super helpful! Thank you! Also, love how this one talks about music... and the BEST music is synthpop! 🙂

@nahashonmueke9143 3 года назад

Wooow!! Thank you so much, have been anxious, on how to use Pivot Table, but finally have just learned it within, 13 mins time!!

@michaelvandeventer9879 4 года назад

I've recently identified this gap in my education and your video's have made a huge difference. A few more months and I am on to Microsoft SQL so if you trained that I'll be excited!

@cynthiajacobson9702 4 года назад

I appreciate a practical example to learn effectively- so helpful. I appreciate the enthusiasm for his interest in music!!

@ronalda.saname396 3 года назад

My favorite types of music: Blues, Classical, Flamenco, Rock/Hard Rock/Heavy Metal, Jazz, and Reggae. All are GREAT musicians. Like BB King, Miles Davis, Paco DeLucia, Vladimir Horowitz, Jimmy Page, Ritchie Blackmoore, Bob Marley, and Bud Powell (Jazz) Pianist. Love your video, check out Jimmy Page and the greatest Fuglehorn player ever Clark Terry.

@sanjaykumarsharma2111 Год назад

Thank you for sharing this tutorial video. Great job.

@phillipluu8089 4 года назад

This is an excellent tutorial! Thank you!

@adelinerosales1292 3 года назад

I love that this video was a 2 for 1. I def left with new tips & new tunes 👍🏽

@payalshah5205 6 лет назад

Thanks for introducing us to Synthpop :D Also, great Excel videos!

@ronalda.saname396 3 года назад

My favorite types of music: Blues, Classical, Flamenco, Rock/Hard Rock/Heavy Metal, Jazz, and Reggae. All are GREAT musicians. Like BB King, Mile Davis, Paco DeLucia, Vladimir Horowitz, Jimmy Page, Ritchie Blackmore, Bob Marley, and Bud Powell (Jazz) Pianist. Love your video, check out Jimmy Page and the greatest Flugelhorn player ever Clark Terry. Give me Rainbow any day or Miles Davis.

@alabanghills 4 года назад

Using the Killers in your example, love it.

@GenealogyTV 4 года назад

Wow, I learned something new today. Very cool. Thank you.

@heathergordon4910 3 года назад

excellent music choice - The Killers and Brandon Flowers.....awesome

@aberaabdurahman8906 4 года назад

Great presentation. Short, clear, and precise ! Thanks again.

@user-fh2nn7sj8g 9 месяцев назад

awesome tutorial, your explanation is simple and easy to understand

@diekleinediesnervt 6 лет назад

Thank you for doing this awesome work !

@MrStensnask 6 лет назад

Great tutorial as with all your tutorials. I'm slowly but surely becoming a jedi master at Excel!

@private-signebogelund-jensen 5 лет назад

You are a fabulous teacher- Thank you very much!

@katewolf1409 3 года назад

Great class on Pivot Tables!

@alimumtaz7498 4 года назад

Thank you for your tutorails, they are very easy to understand and follow.

@julianagill9621 2 года назад

Very well explained. Easy to understand. Thank you

@DB-kv3wu Год назад

Awesome tutorial! Thank you!

@amandao-n6584 8 месяцев назад

Such a clear explanation- thank you!

@haythamabukahdeir5113 4 года назад

These videos are amazingly helpful. Thanks man

@stephanienanjuki8121 2 года назад

Love your taste in music and great presentation as well, thank you.

@federicacamuffo1734 4 года назад

It's the first time that excel make sense to me! Your way to explain makes it simple and at reach for who like me has no clue of where to start! THANK YOU

@vtvita 3 года назад

"No Clue!" Bingo!