Advanced Excel - Creating Pivot Tables in Excel

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

[@corytatum2229]

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

[@size8kate]

LOL

[@nbkuycd]

x2

[@jigri_pokhri]

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

[@papa5637]

ahahahaha

[@eurisko7119]

me too.

[@tracymendiola8345]

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

[@agr3131]

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]

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

[@calybwilliams5565]

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

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

[@bethw2424]

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]

Same here

[@GearheadExplorer85]

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]

Absolutely right

[@lakapenostra]

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

[@MsShemetov]

Same here! Big Thank you,

[@steve94044]

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!

[@marybev77]

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

[@TheJester-ct5pi]

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

[@michaelalderete9622]

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 KZbin videos I'd found. Well done!

[@yolaktv7274]

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]

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]

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

[@zenzybar]

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]

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.

[@twilight9237]

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

[@vtvita]

Agreed. Well said.

[@khairallahdh]

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]

Im starting mine in January, doing the same thing!

[@anjalirajagopal4841]

even im starting mine

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

[@camillemarquizessepida9437]

Thank you so much for this dont stop making tutorial this such a big help for us. 💗💗💗💗

[@vmperkins9168]

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.

[@Kailasha502]

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

[@2094studios]

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

[@deanatoribio9574]

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.

[@tahirrizwan3732]

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

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

[@mlauracampos]

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!

[@mspa91]

Brother Thank you so much for this tutorial video. Its really help me a lot. Last few months am watching so many videos but today I watch the right video for good learning, thank you so much.

[@Birbborb000]

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

[@user-fh2nn7sj8g]

awesome tutorial, your explanation is simple and easy to understand

[@trep1269]

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

[@fileagramaje8521]

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

[@cpnaresh]

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

[@tloubonolo4460]

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

[@sashi6736]

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

[@beautyteen15]

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

[@thanksforthefish5620]

You're like the Bob Ross of Excell

[@arnisdaddy7905]

Yeah, and I love Bob Ross too!

[@lightlife917]

Yes

[@davidfaherty3709]

i'm a Vrit whos Bob Ross?

[@ergosum5260]

@David Faherty do you not have KZbin?

[@knaw35]

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!

[@georgerest2115]

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!

[@MidnightTrigger650]

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

[@ianbovic1802]

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

[@manekpr]

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!

[@michelemcnally6598]

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]

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]

Agreed, and your comment is very nice.

[@worldsbestaquarium08]

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

[@davidcallen2166]

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.

[@sumakanigalla7908]

This video is really simple for beginners to understand thank you...

[@Impurfecther]

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

[@jenardennedeleon3603]

THANK YOU FOR THIS WONDERFUL TUTORIAL! THIS IS AMAZING!

[@kumheekwag2553]

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

[@1987phil48]

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

[@wendyreyes95]

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!

[@choobv2]

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

[@fernandovera9207]

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.

[@paulmclean1268]

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

[@Magpieme98]

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]

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.

[@karthikkiran338]

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

[@kelvinbenjamin4832]

P00p0000po

[@SergioInzunza]

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

[@davidchao685]

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

[@aceaxel1255]

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]

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

[@HellAtlantic]

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.

[@user-yi5hu8qw4s]

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

[@RLWMJW07]

Took the crazy out of learning how to do this. Thank you.🤩

[@Noelle7676]

Incredibly helpful! Thank you for posting

[@sheepma9905]

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

[@rachelleleduc1681]

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.

[@aberaabdurahman8906]

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

[@brendamaxwell181]

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

[@sanjaykumarsharma2111]

Thank you for sharing this tutorial video. Great job.

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

[@bluewaves9298]

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

[@matthewhassan3133]

Great video - very helpful. Thank you!

[@AllaboutSunshines1994003ss]

This tutorial is so useful... Learning excel by your videos

[@amandao-n6584]

Such a clear explanation- thank you!

[@user-yb7uy1mo4v]

Very in depth and helpful. A trainer under Data Analysis.

[@tojora1]

Not only did you help me understand pivot tables, but I also ordered a Level 42 CD. You got me!

[@katewolf1409]

Great class on Pivot Tables!

[@krishtrinity]

Thanks to your tutorial I am listening to synthpop

[@kundrah3232]

Thanks you so much am really understanding the basics of excel

[@laurenjatich5682]

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

[@milliet4982]

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

[@alimumtaz7498]

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

[@julianagill9621]

Very well explained. Easy to understand. Thank you

[@krishnasvsr]

excellent presentation and wow what clarity of voice

[@varunpanday2494]

Great explanation on making it simple to understand

[@damsiriperera771]

Excellent , very simple and understanding

[@DB-kv3wu]

Awesome tutorial! Thank you!

[@phillipluu8089]

This is an excellent tutorial! Thank you!

[@hermilapile7315]

This was really helpful and easy to understand. Thank you.

[@christianweyrauch4909]

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

[@alabanghills]

Using the Killers in your example, love it.

[@wiclifftsheole4241]

Great stuff, reduced my work load by 90%

[@tnt_castillejos5892]

Thanks for the previous series excel toturial. I'm still watching the rest of the toturial.

[@sanjeetprasad9775]

Very well explained.Thank you

[@wineblue2]

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!

[@private-signebogelund-jensen]

You are a fabulous teacher- Thank you very much!

[@vhector480]

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

[@mariodominguez69]

Excellent thanks for teaching us. Very helpful

[@adelinerosales1292]

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

[@yolandamendezgonzalez3354]

I love how perfectly well you explain it, thank you!!

[@haythamabukahdeir5113]

These videos are amazingly helpful. Thanks man

[@lisabhuiyan3212]

Your tutorial is so awesome and helpful, I just wanna say Thank you

[@PersonOfBook]

Such an easy to follow tutorial!

[@stephanienanjuki8121]

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

[@JordanRae]

Thank you so much. Great instructions!