Advanced Excel - Creating Pivot Tables in Excel

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

[@GalvMermaid50]

Same. 😄

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

[@tracymendiola8345]

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

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

[@paulmclean1268]

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

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

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

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

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

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

[@tundeolaosebikan4643]

This is one of the best if not the best video tutorials I’ve watched on pivot table. Now I want to watch all your videos on excel training. Thank you for sharing

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

[@Flankadank012]

I don't know about you folks, but I think we owe it to this gem of a human to listen to some synthpop!

[@Flankadank012]

@technologyforteachersandstudents. I really appreciate the videos. Super helpful. Helped me score a job! BIG KISS :*

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

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

[@marybev77]

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

[@TheJester-ct5pi]

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

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

[@jenorjennifer]

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 KZbin comment ever.

[@excxmoody]

Seriously, thank you for presenting the info in a more compelling manner instead of Apples and Oranges. Some teachers don't have half a clue even with a degree.

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

[@allan-5141]

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

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

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

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

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

[@trep1269]

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

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

[@Kailasha502]

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

[@twilight9237]

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

[@vtvita]

Agreed. Well said.

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

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

[@maruemmanuel6319]

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.

[@tonytaf107]

I saved $ 625 in a basic excel course after following your vids, I can jump right to the Advanced class. 🙏🏼

[@worldsbestaquarium08]

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

[@CoronelOcioso]

Old Video, nice content, i googled without much hope to explain my spaniard GF withimages what pivot tables were. She even praised your effort at clear talk that allowed her to understand without much translation intervention from my side. Actually she commanded i look up in your channel the second pivot table video. (And she is not even thinking about using the tables... it came out in a conversation... Kudos man)

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

[@bluewaves9298]

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

[@mrblaze044]

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!

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

[@tahirrizwan3732]

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

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

[@tloubonolo4460]

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

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

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

[@ShooooEast201Knight]

If you're still active i just wanna say thankyou so much . Your video tutorials helps a lot godbless

[@seanaguilar2057]

What people often forget about Excel is Freezepop and Lady Tron. These small differences can make all the difference. Since all music has synthetic components now anything popular would be considered sythpop by those standards. Killers are Alt Rock. Then you have Dark NewWave, Retrowave, Synthwave, etc. Maybe throw some Cybertron in your next great video. Thanks for the info!

[@federicacamuffo1734]

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]

"No Clue!" Bingo!

[@BeEmpathic]

Hello! Thank you for sharing in your knowledge on the internet. I love to see such a good people. You are an awesome computer user for me, as you are a great teacher as well. It's really important to keep viewer focus on the video with fun and interesting stuff, like the bands and their albums, which you used in this video, and you aren't making people watch some long intro, and introduction to, what is going to be done, straight to the point. The world needs more people like you. Thank you one more time

[@billyoung8118]

Electrical engineering grad, emphasizing CPU design. I work as a statistician. I'm no idiot. I have been using Excel since it first came out, replacing Lotus 1-2-3. Have ALWAYS struggled with pivot tables. Need to try it again because of a work project I've been given. Fingers crossed. Thank you for this tutorial!

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

[@nahashonmueke9143]

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

[@signalsystems]

My favourite channel. Simple and clear. May Allah bless you.

[@neilxquan]

the best guide of microsoft powerpoint, excel and word

[@harrisonwright93]

You have phenomenal taste in music. And also great teaching ability.

[@marcusaurelius7438]

His taste in films, however, leaves much to be desired.

[@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 Blackmoore, Bob Marley, and Bud Powell (Jazz) Pianist. Love your video, check out Jimmy Page and the greatest Fuglehorn player ever Clark Terry.

[@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. The greatest band of all time, Led Zeppelin. I love Heart. BB King was a legend.

[@elizabethvanmeter3217]

I’ve watched this before, and wanted a refresher. Great video! Fun that you use data you are excited about!🎼

[@RaslanAli-d7r]

awesome tutorial, your explanation is simple and easy to understand

[@holapaw]

Watched because of learning pivot tables, subscribed because you also like the Killers!

[@jameswallace4191]

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

[@Shrihaanworld]

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.

[@bvresplendor3169]

Whats your name buddy? I recently was told by my mentor to learn excel so that it helps me in my business, thanks for the videos, I'm learning alot everyday

[@christianweyrauch4909]

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

[@wiclifftsheole4241]

Great stuff, reduced my work load by 90%

[@oliviahekondo7580]

I don't think I need any other teacher anymore, you're the best. Everything is becoming easier for me now. Much thanks from Namibia

[@samschlenner6582]

Been watching these all afternoon and I’m in love with this guy’s love for synthpop.

[@adelinerosales1292]

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

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

[@vhector480]

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

[@sachintelang2367]

Very well scripted and explained.. Great Channel for learning MS-Excel..

[@tojora1]

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

[@KrystalCJCheng]

The best excel tutorial ever!!! Really~~Simple easy to understand, even better than any of the description in my country.

[@vtvita]

"The best excel tutorial ever!!! Really" You said it!

[@cucharlie2006]

omg, thank you. after watching your video, I am not scared of Excel 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.

[@caroline377]

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

[@lavkedar4199]

You are the best explainer on youtube

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

[@milliet4982]

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

[@mamon88]

I had to google what is Synthpop music, forgive me... I like it tho. Thank you for this tutorial I am learning a lot while listening to Top Synth Pop Songs 2017. Part 4 of 8. Thanks, teacher!

[@nbkuycd]

x2

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

[@jenniferlogan-porter9788]

Talk about the "Policy of Truth", this makes Excel less daunting. Thank you for sharing your expertise 😎

[@vtvita]

I'm missing something. Where did the "Policy of Truth" enter the story? And agreed, and liked.

[@jenniferlogan-porter9788]

@@vtvita, if my memory serves me correctly, I think it just popped into my head when I saw Depeche Mode 🤭

[@Birbborb000]

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

[@michaelvandeventer9879]

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!

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

[@81970277324]

You have Future Islands! Thats my friend Sam's band. We grew up together. Sooper cool. Good to see he's got so many fans. I saw some of his albums at a record store too while vinyl shopping. Well thanks for the tutorial. Very nice.

[@babydollryan34]

GREAT tutorial and this guy is hysterical! Great musical taste.

[@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. The greatest band of all time, Led Zeppelin.

[@camillemarquizessepida9437]

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

[@cynthiaszczepaniak7050]

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

[@vtvita]

This is it!

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

[@cpnaresh]

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

[@Grinchthanksgiving]

Job interview coming up. This video is simple and easy to follow along. Thank you!

[@jennyr.5246]

The best excel tutorial , thank you for your thorough explanation and sharing your knowledge . :)

[@thegirlfromthehimalayas8066]

Thanks tons! not just learnt Pivot, but the way you have taught is engaging and humorous :)

[@Impurfecther]

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

[@robidarzi]

Best channel for learning

[@cynthiajacobson9702]

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

[@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 Blackmoore, Bob Marley, and Bud Powell (Jazz) Pianist. Love your video, check out Jimmy Page and the greatest Fuglehorn player ever Clark Terry.

[@kudakwashemadzikangava7024]

You made this so easy to understand. Great article

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

[@sheepma9905]

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

[@henrytrieu3429]

I learned a lot but also enjoy your personal taste in movie and music, Thank you!!

[@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 Blackmoore, Bob Marley, and Bud Powell (Jazz) Pianist. Love your video, check out Jimmy Page and the greatest Fuglehorn player ever Clark Terry.

[@SergioInzunza]

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

[@yolandamendezgonzalez3354]

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

[@missnanaheats1557]

Best pivot table explanation ever!!!!❤