Advanced Excel - Creating Pivot Tables in Excel

Рет қаралды 2,475,532

Technology for Teachers and Students

Күн бұрын

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...

Пікірлер: 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 KZfaq 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!

@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

@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!

@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!

@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!

@jenardennedeleon3603 4 жыл бұрын

THANK YOU FOR THIS WONDERFUL TUTORIAL! THIS IS AMAZING!

@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!

@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.

@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

@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!

@worldsbestaquarium08 3 жыл бұрын

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

@bluewaves9298 3 жыл бұрын

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

@HellAtlantic 2 жыл бұрын

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.

@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 KZfaq comment ever.

@milliet4982 4 жыл бұрын

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

@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.

@sheepma9905 2 жыл бұрын

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

@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!

@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.

@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!

@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

@cynthiaszczepaniak7050 4 жыл бұрын

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

@vtvita 3 жыл бұрын

This is it!

@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!.

@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!

@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.

@adelinerosales1292 3 жыл бұрын

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

@GenealogyTV 4 жыл бұрын

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

@alabanghills 4 жыл бұрын

Using the Killers in your example, love it.

@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 !

@private-signebogelund-jensen 5 жыл бұрын

You are a fabulous teacher- Thank you very much!

@MrStensnask 6 жыл бұрын

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

@alimumtaz7498 4 жыл бұрын

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

@katewolf1409 3 жыл бұрын

Great class on Pivot Tables!

@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!