Advanced Excel - Creating Pivot Tables in Excel

[@paulmclean1268]

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

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

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

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

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

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

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

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

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

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

[@digsinc91]

Thank you for explaining this slowly and clearly! Been searching tutorials for 3 days straight & your’s is the easiest to understand.

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

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

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

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

[@trep1269]

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

[@marybev77]

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

[@TheJester-ct5pi]

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

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

[@Kailasha502]

One of the best Pivot table tutorial I have ever watched! 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.

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

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

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

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

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

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

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

[@bluewaves9298]

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

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

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

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

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

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

[@twilight9237]

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

[@vtvita]

Agreed. Well said.

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

[@robidarzi]

Best channel for learning

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

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

[@susanbreen2694]

Just started watching, and I already know it's going to be a great video when a photo of Brandon Flowers from The Killers pops up.

[@worldsbestaquarium08]

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

[@ShooooEast201Knight]

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

[@tahirrizwan3732]

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

[@adelinerosales1292]

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

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

[@christianweyrauch4909]

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

[@elizabethvanmeter3217]

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

[@camillemarquizessepida9437]

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

[@tloubonolo4460]

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

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

[@caroline377]

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

[@RaslanAli-d7r]

awesome tutorial, your explanation is simple and easy to understand

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

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

[@neilxquan]

the best guide of microsoft powerpoint, excel and word

[@samschlenner6582]

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

[@vhector480]

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

[@Joanna_OTMH]

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

[@milliet4982]

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

[@holapaw]

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

[@tonytaf107]

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

[@lavkedar4199]

You are the best explainer on youtube

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

[@signalsystems]

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

[@cucharlie2006]

omg, thank you. after watching your video, I am not scared of Excel Pivot tables. Thank you.

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

[@sheepma9905]

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

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

[@kudakwashemadzikangava7024]

You made this so easy to understand. Great article

[@ahumanlewis]

Thank you for posting.

[@fileagramaje8521]

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

[@Grinchthanksgiving]

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

[@wiclifftsheole4241]

Great stuff, reduced my work load by 90%

[@sachintelang2367]

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

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

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

[@krishnasvsr]

excellent presentation and wow what clarity of voice

[@jennyr.5246]

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

[@serena3970]

The more of this man's videos I watch, the less I believe he does not have a synthpop store (very helpful content)

[@techteachersandstudents]

You might be on to something there. Very perceptive. :)

[@keysersoze9271]

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

[@Birbborb000]

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

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

[@alabanghills]

Using the Killers in your example, love it.

[@mushtaqrefai6956]

Thanks a lot for this

[@cynthiaszczepaniak7050]

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

[@vtvita]

This is it!

[@laurolopes9922]

Came here for the Excel tips, but loved to see Ulver and Depeche Mode mentioned in the video. Will check the other artists as well!

[@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. What about Heart, The Stones, The Who, Miles Davis, BB King, Paco DeLucia.

[@karengwede1349]

Great explanations ,am glad I opened his teachings...thank you so much ,you explain in full 🌝

[@missnanaheats1557]

Best pivot table explanation ever!!!!❤

[@GenealogyTV]

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

[@yolandamendezgonzalez3354]

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

[@varunpanday2494]

Great explanation on making it simple to understand

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

[@fonapycake3467]

Thanks dear, very understandable, clarification and explanatory💯 compares to others Pivot tables🏃‍♀️ you worth my subscribe button 💯%

[@stephanienanjuki8121]

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

[@julianagill9621]

Very well explained. Easy to understand. Thank you

[@teanatime]

thankful that you taught us the original way then the shortcut way.. i really appreciate it!!!! thankkkk youuuu

[@Impurfecther]

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

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