Pivot Table Excel Tutorial

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ก.พ. 2025

ความคิดเห็น • 1.4K

  • @KevinStratvert
    @KevinStratvert  5 ปีที่แล้ว +176

    ✅ Access the sample data in the spreadsheet here: 1drv.ms/x/s!AmxrofZZlZ-wg_xUE4vA3D_5qdbRjA
    🏫 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com
    ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
    🧙‍♂️ Advanced Pivot Table Tips & Tricks: th-cam.com/video/3g1CSG5zvQ0/w-d-xo.html
    📩 Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/

    • @nairahyusuf2501
      @nairahyusuf2501 4 ปีที่แล้ว

      Dose pivote works on every test?

    • @saadatsabur6748
      @saadatsabur6748 4 ปีที่แล้ว +2

      Saadat Sabur
      1 second ago
      Hi @Kevin Stratvert. The link to the sample spreadsheet has expired.

    • @blrichwine1
      @blrichwine1 4 ปีที่แล้ว

      The sample data says it doesn't exist or I don't have access to it. Can you repost a link to the sample data? Thanks!

    • @suroyobimantoro6427
      @suroyobimantoro6427 3 ปีที่แล้ว

      Thank you so much kevin

    • @meemie8180
      @meemie8180 3 ปีที่แล้ว

      can't access the sample data

  • @happyworldland82
    @happyworldland82 5 ปีที่แล้ว +3131

    when you tell the job that you know how to do pivot tables and actually make it to the third round of interviews and there is an excel assessment and you dont know jack sh*t about pivot tables so you run over to youtube. thanks kevin, you helped a lot! lol

    • @KevinStratvert
      @KevinStratvert  5 ปีที่แล้ว +191

      ha, that's awesome. Hope you got the job, that'd be a first for my channel :)

    • @happyworldland82
      @happyworldland82 5 ปีที่แล้ว +519

      @@KevinStratvert I got the call today, I did in fact get the job, senior acct 😁👍🏾. Thank you

    • @KevinStratvert
      @KevinStratvert  5 ปีที่แล้ว +78

      @@happyworldland82 Brilliant :)

    • @gianniferrari1122
      @gianniferrari1122 5 ปีที่แล้ว +39

      @@happyworldland82 LOL NICE

    • @sinistersmallblock
      @sinistersmallblock 5 ปีที่แล้ว +94

      I'm in the same boat, hence the reason why I am up at 3:38am trying to learn about this before my 9am interview! Lol. Come to find out, I was creating my own pivot tables as a Data Subject Matter Expert for AT&T in order to track and forecast Data sales by each dept, but I had no idea that was the name of my graphs...and certainly not to the extent of the video. Thank you. Each one teach one.

  • @Arbitraritorian
    @Arbitraritorian 2 ปีที่แล้ว +612

    Best pivot table intro I've seen. Covers more in 10 minutes, more clearly, than some courses do in 4 hours.

  • @WillDixonMusic
    @WillDixonMusic 2 ปีที่แล้ว +176

    I literally just got a job this week because of this video. Keep saving lives Kevin.

  • @dioniesueiti-toka4622
    @dioniesueiti-toka4622 4 ปีที่แล้ว +170

    I cried a little, thank you for helping me to understand it's not magic. People are often impatient during work. They show once, and quickly, and expect us to get it. You are a gift to many.

    • @bargeld09
      @bargeld09 3 ปีที่แล้ว +1

      I agree watching this video is way better than having someone else show you.

    • @chilledClouds
      @chilledClouds 2 ปีที่แล้ว +6

      Yesss! I was getting ready for a full night of work trying to prepare a few monthly reports for an upcoming meeting and then I saw this Video, now I will be able to make those in less than an 30 mins.... so yeah, I was jumping all over the place from happyness :D

    • @reneeoreilly3092
      @reneeoreilly3092 หลายเดือนก่อน

      took the words write out of my mouth. This man has found his 'calling'!

  • @daniel.s844
    @daniel.s844 11 หลายเดือนก่อน +45

    thank you. just landed a job that requires a lot excel analysis, luckily my boss gave me 1 week to get it on hand. this tutorial helped a lot.

  • @donjoe5285
    @donjoe5285 3 ปีที่แล้ว +990

    You’re probably quite aware...but you’ve helped kickstart A LOT of careers 😭

    • @sleipnirnordic1426
      @sleipnirnordic1426 3 ปีที่แล้ว +5

      Amen brother, amen

    • @dyscea
      @dyscea 3 ปีที่แล้ว +79

      I just lied to a recruiter that i knew what pivot tables are. Thank you, TH-cam.

    • @man159159
      @man159159 3 ปีที่แล้ว +30

      Have an interview in 5 days, brushing up on my excel knowledge. What a life saver!!!

    • @Lowkeyme-s7w
      @Lowkeyme-s7w 3 ปีที่แล้ว +2

      Mine 😂

    • @MacBaza
      @MacBaza 3 ปีที่แล้ว +22

      I'm here because I have an interview in an hour and need to brush up on this

  • @curtisholsinger6023
    @curtisholsinger6023 4 ปีที่แล้ว +355

    You are a born video instructor. Your voice is engaging, your speed with the mouse is not too fast and not too slow, and your progression made sure I did not get lost. I am absolutely coming back to watch this again when I need another refresher. Subscribed!

  • @sophiacykert3037
    @sophiacykert3037 2 ปีที่แล้ว +3

    Thank you!! I was feeling a little overwhelmed at my new data analyst job, but this video really helped me reset my focus and clean up a lot of my work!

  • @jordansmithson9602
    @jordansmithson9602 4 ปีที่แล้ว +52

    Prepping for a job interview, and this made me feel a lot more confident about my changes of getting the job. Thanks!

    • @DrSpaceman42
      @DrSpaceman42 2 หลายเดือนก่อน

      Did you get it?

  • @axion8788
    @axion8788 3 ปีที่แล้ว +202

    Extremely helpful. I've watched so many Excel videos and what they almost always lack is a cogent, real-world framework for why you would want to do this. Your context-driven approach adds a great deal of value. Many thanks and subbed.

  • @larrymagruder8385
    @larrymagruder8385 4 ปีที่แล้ว +81

    Well done, Kevin! You covered a lot in 13 minutes. Quick, concise, and eye-opening for countless uses and options for analyzing data. Yes, you moved fast, but that easily should be the preference for all of us since we can pause, replay, and replay again to gradually gain understanding on a topic we didn’t quite grasp the first time - or not repeat something at all if we were already comfortable with our understanding, It’s the power of a video. Again, well done, Kevin!

  • @cutelipsy1
    @cutelipsy1 4 หลายเดือนก่อน +1

    I should have just come straight to your channel first.You literally made pivot table FINALLY make sense. This is after spending hours scouring through videos to understand why what goes where in those 4 boxes, you're the first to actually explain in beginner talk! Thank you Kevin.

  • @dhivyadiwakar
    @dhivyadiwakar 6 หลายเดือนก่อน +11

    For years i have thought pivot tables are a complex functionality. My perception has been quickly turned around with this video. That was a nice ice breaking session for me!

  • @AlexanderCotton-h4c
    @AlexanderCotton-h4c 6 หลายเดือนก่อน +6

    I created a fake data set after watching this video and then rewatched and did everything like you did. This was incredibly helpful. Definitely going to help me in the job I just landed!

  • @lachlan1971
    @lachlan1971 2 ปีที่แล้ว +4

    Job interview tomorrow. This was a great help. Thanks!

    • @lachlan1971
      @lachlan1971 2 ปีที่แล้ว

      Unfortunately not quite enough to seal the deal. Oh well. Next time.

    • @RomarioDawood
      @RomarioDawood 17 วันที่ผ่านมา

      @@lachlan1971 any update? i have an internship interview tomorrow with KPMG and im nervous

  • @ogprodigyy___
    @ogprodigyy___ 9 หลายเดือนก่อน +1

    Kevin this is a lifesaver! I had an interview recently in which they asked me about pivot tables, and I’ve always been so intimidated that I never even looked into it. This video was so simple and helpful, and I will continue to mess around with data until i am confident in using these tables, thanks so much!

  • @jasmineleeann5998
    @jasmineleeann5998 4 ปีที่แล้ว +27

    Have an interview Wednesday that requires knowing about pivot tables! You actually made learning this exciting! Thank you ☺️🙌🏽

  • @ishmaelmartey6140
    @ishmaelmartey6140 7 หลายเดือนก่อน +1

    Live saving video 😃
    I watched this video 2 hours before my interview. Surprisingly at the interview, I was given a large data to work with which required using a pivot table, I just smiled and answered all questions on point and in time. Thank you 👍

  • @tammihayward1937
    @tammihayward1937 4 ปีที่แล้ว +12

    Thank you Kevin!! I am starting a new job and have never used pivot, macros, vlookup etc.. Having watched your video's over the past few days I feel so much more confident. You explain it simply and easily. THANK YOU x

  • @leixiao169
    @leixiao169 ปีที่แล้ว

    Thanks! This helps me a lot!

  • @erindeblois3825
    @erindeblois3825 3 ปีที่แล้ว +24

    By far the simplest and easiest to follow of all Excel tutorials I have looked at (and there have been a LOT!). Thanks so much! I have now subscribed, and you're now my first go-to when I need a refresher, or a crash course on Excel!

  • @alexyershov7580
    @alexyershov7580 ปีที่แล้ว +2

    I really like his style - fast paced and to the point, no lengthy preamble. Expertly explained.

    • @dalenjurgens6751
      @dalenjurgens6751 6 หลายเดือนก่อน

      "No lengthy preamble"... for sure, I like that as well.

  • @edvalentine8617
    @edvalentine8617 4 ปีที่แล้ว +4

    Kevin really knows how to present the basic concepts to allow them to become daily tools. Kudos.

  • @lesliehamilton2020
    @lesliehamilton2020 6 หลายเดือนก่อน +4

    This just taught me in 7 minutes what other videos couldn't teach me in 2 hours.

  • @rudygutierrez20
    @rudygutierrez20 3 ปีที่แล้ว +40

    I believe that everyone should learn this. You are amazing! Thanks you

    • @tramellmalone9146
      @tramellmalone9146 3 ปีที่แล้ว +1

      True. I'm learning database management and I know I'm going to run across pivot tables at some point.

  • @thepineappleburster4439
    @thepineappleburster4439 3 ปีที่แล้ว +12

    Thanks for making this. Missed all my classes this year and you explaining how it works is ten times better than any other person.

  • @tadasuko8935
    @tadasuko8935 2 ปีที่แล้ว +3

    An entire semester spent learning Excel, and you did a better job at explaining pivot tables to me in fifteen minutes.

  • @agabon1
    @agabon1 2 ปีที่แล้ว

    I'm a beginner in the use of Pivot table but you tutorial really made me more interested to learn..its hard to understand first thing but gradually following steps by steps and writing notes , I think, I learned so much and my worries of every time I be asked during work interview if I know Pivot Table I honestly said no...but with your tutorial I know I'm ready to say yes, I know Pivot Table. Thank you so much, you are a great teacher to novice like me.

  • @scorpio19771111
    @scorpio19771111 2 ปีที่แล้ว +5

    You are a star teacher. Take the pain out of learning unfamiliar functions. Keep up the superb work!

  • @frobinson1981
    @frobinson1981 4 ปีที่แล้ว

    Thx. I have been intimidated by pivot tables for a few years now. But recently I jumped in and just started dragging titles into a different market and was able to see how the pivot table works to summarize large amounts of data for different kind of analytical purposes. Your video helps reassure me that I’m moving in the right direction thank you again

  • @antriggs4190
    @antriggs4190 3 ปีที่แล้ว +6

    So concise and easy to follow. I didn’t even know what these were until an hour ago when my engineering lead asked me to organize my data into a pivot table. Thanks!

  • @geewill99
    @geewill99 2 ปีที่แล้ว

    I know this video was made 3yrs ago but man this was by far the best explanation I've seen on TH-cam about pivot tables. Thank u!!

  • @lola.ooshin9315
    @lola.ooshin9315 4 ปีที่แล้ว +9

    Amazing! Amazing! Amazing! For YEARS, I had gone out of my way to avoid using pivot tables - Until Today! Thank you so so much for this extremely simple way of using this magnificent tool. Keep up the great work and God bless you!

    • @alishaks8190
      @alishaks8190 4 ปีที่แล้ว

      Thank you so much sir

  • @coastal4074
    @coastal4074 10 หลายเดือนก่อน

    Thanks Kevin. You’re the best. I’ve been using excel for decades but I find you get stuck in your own way of doing things that you’ve taught yourself. I’m here to find out all the functionalities I’ve overlooked and learn how to do things better. So many hints and tips. You’re a great teacher so much clarity. I’m going through all your videos. Thank you very much 😊

  • @ShaundrickRoberts
    @ShaundrickRoberts 3 ปีที่แล้ว +3

    Listen, bro, that expand and collapse has saved me sooooo much time at work. THANK YOU!!!!

  • @menchiedelosreyes5591
    @menchiedelosreyes5591 7 หลายเดือนก่อน

    I'm reviewing Pivot Tables which I used a year ago. This is in preparation for job interview. Your videos are very helpful, concise, and easy to understand. Thank you so much. Watching from Manila, Philippine

  • @diandracoleman8847
    @diandracoleman8847 3 ปีที่แล้ว +19

    Thanks, Kevin! Great refresher and thanks for giving us access to the data--I'm a hands-on learner so that helps tremendously

  • @mybestideas1
    @mybestideas1 2 ปีที่แล้ว

    Thank you so much. Before you I spent one hour of Simon Saiz explanation of Pivot Tables. While I feel that she did give lots of info, the whole idea was not explained well. So glad I saw your video, as you explained everything in a fraction of time.

  • @cynthiabussey6917
    @cynthiabussey6917 4 ปีที่แล้ว +8

    I had a phone interview and they asked me about pivot tables. I simply said that I didn't not use them on a daily basis for my job. I am not familiar at all. I am looking through your videos to refresh some knowledge before my interview. I have watched other videos and yours I like the best. Some of the other videos I literally was falling asleep watching.

  • @tracygiles8789
    @tracygiles8789 3 ปีที่แล้ว

    Sobbing over PivotTable chapter in the MOS Study Guide for the Excel Expert exam and decided I despised PivotTables. 15 minutes of your video and they made perfect sense.

  • @kristicobbs5967
    @kristicobbs5967 3 ปีที่แล้ว +2

    Wow! Kevin ... that was a great tutorial. I have never used a pivot table, nor have I even thought about one before beginning my research on how to create my own CRM tool in Excel. Thank you for the lesson - but mostly, thank you for talking in regular terms because that made the information easier to follow and easier to digest.

  • @carolind6264
    @carolind6264 3 ปีที่แล้ว

    I have tried to understand why pivot tables were at all useful for a long time. After watching your video, I finally understand! Thank you!

  • @tracycoles704
    @tracycoles704 2 ปีที่แล้ว +7

    All your EXCEL teaching videos have helped me in my online college course. If it weren't part of the course material that I need to graduate, I would buy your tutorial. If there were a way for you to sell your videos or learning program to online college campuses, that would be awesome! Thank you for doing this! You have obviously helped thousands of people with these videos!

  • @sundaymichael9754
    @sundaymichael9754 4 หลายเดือนก่อน

    Six minutes into your video and I was able to spend 15 minutes on a task that could have taken half of my day. You are the best!!! THANKSSSSS!!!!

  • @jimpeters9511
    @jimpeters9511 5 ปีที่แล้ว +8

    Thank you. Excellent tutorial to remind me how this is done, It's been about 5 years since I did this professionally on a routine basis. Now that I'm retired, I want to use it to analyze our church financials.

  • @azadmeer5221
    @azadmeer5221 2 ปีที่แล้ว

    Best video on You Tube I've seen yet, educating the masses on how to use Excel Pivot Tables. Great work!

  • @ihababdelaziz
    @ihababdelaziz 5 ปีที่แล้ว +34

    Thanks a million, i watched several videos on pivot tables! yours is by far the best and easier to follow and understand!

  • @boyanfilipov3190
    @boyanfilipov3190 3 ปีที่แล้ว

    Most legit tutorials for MS stuff. People like you help others to expand their knowledge in a vary interesting way. THANK YOU!

  • @simeonesprit834
    @simeonesprit834 5 ปีที่แล้ว +6

    Very helpful. as someone looking to break into management consulting and/or business analysis roles, your vids are extremely helpful. New sub.

  • @MattKelm
    @MattKelm 24 วันที่ผ่านมา

    My man, Kevin, thank you! I have worked some with Excel, but I am just learning about pivot tables. This short tutorial was super informative and exactly what I needed.

  • @leonardo47000
    @leonardo47000 4 ปีที่แล้ว +9

    Wow, you're great teacher.
    I'm an older guy but I need to use excel for my work for each project. I'll be watching all of your lessons going forward.

  • @polreamonn
    @polreamonn 2 ปีที่แล้ว

    Thank you Kevin. I start a job in Supply Chain tomorrow and will be using Pivot Tables so this tutorial is really helpful.

  • @AthenaGM
    @AthenaGM 5 ปีที่แล้ว +33

    Thank you Kevin! I have an important job assessment test coming up and I needed to understand this functionality that has given me many days of headaches! It was easy to follow (thanks for the data provided as well). New sub here. Continue with your content and a Happy New Year to you and yours!!!

  • @missgonzalez2253
    @missgonzalez2253 2 ปีที่แล้ว +2

    Loved that this video is not a few hours long. It's straight to the point and easy to understand.

  • @aimhi5804
    @aimhi5804 5 ปีที่แล้ว +12

    Awesome, thank you for making this simple to follow. Best tutorial video for pivot tables on TH-cam.

  • @jazzyjaz2024
    @jazzyjaz2024 5 หลายเดือนก่อน +1

    What an amazing tutorial!! I just applied to a job that requires you to be comfortable with pivot table (WHICH I AM NOTTTTT )- I will be practicing everything you mentioned here - THANK YOU :)

  • @reywriter7107
    @reywriter7107 5 ปีที่แล้ว +5

    Excellent video Kevin! Great help for rookies like me!

  • @elelwanitshifularo9417
    @elelwanitshifularo9417 2 ปีที่แล้ว +1

    This helped me alot in my third round of interviews and I made it to the final stage....thank you

  • @v36nismo
    @v36nismo 5 ปีที่แล้ว +5

    Thanks for this vid! I just recently started messing about with Pivot tables for work I picked up a few little tricks I can use moving forward

    • @KevinStratvert
      @KevinStratvert  5 ปีที่แล้ว +3

      Great to hear :) thanks for the note!

  • @laucameia7140
    @laucameia7140 2 ปีที่แล้ว

    Thank you so much Kevin! You have made this old head wanting to learn more again, your voice, your speed, the way you walk us thru are all very easy to follow, good on you!

  • @kbroomall
    @kbroomall ปีที่แล้ว

    Just created a killer pivot table to analyze a large dataset using this guide. You are the man!

  • @carolinacastro2440
    @carolinacastro2440 5 ปีที่แล้ว +6

    Thanks Kevin, good approach.

  • @ahyungrocks5509
    @ahyungrocks5509 9 หลายเดือนก่อน

    At my work, I have done a lot of data collection and analysis using Python scripts and industry tool call Spotfire. This week I had an initial interview and this guy said they use Excel (Pivot Table). Thank you for this video as I have never even heard of Pivot Table after using Excel for thirty years.

  • @iamkimtisaac
    @iamkimtisaac 2 ปีที่แล้ว +4

    I got my job because of this video 🙌🏽🙌🏽

  • @tun-tunninc.6492
    @tun-tunninc.6492 3 ปีที่แล้ว +1

    Thank you. I just started my role as a data analyst at my worksite and this is extremely helpful. I really appreciate your work and time.

  • @denisenellis4626
    @denisenellis4626 4 ปีที่แล้ว +4

    Thank you so much Kevin! Now it left me with one question. How do you add to the data and update the pivot chart?

  • @lilimarie269
    @lilimarie269 2 ปีที่แล้ว

    Thank you Kevin! I started a new position where they use Excel much more. Which was my weakness. I appreciate your calm tone and easy approach. I can now feel more confident using Excel for my tasks.

  • @QUEENfknJASS
    @QUEENfknJASS 5 ปีที่แล้ว +14

    Thank you! I’m going to practice on the free online version for my job interview 😩🤞🏾

  • @ianpatrick23
    @ianpatrick23 ปีที่แล้ว

    This is such a great introduction to Pivot Tables in Excel. As a novice to Excel and Pivot Tables, I appreciate this clean, simple tutorial very much. Thank you!

  • @mattfasullo1477
    @mattfasullo1477 4 ปีที่แล้ว +8

    Very well taught! Appreciate your very understandable explanations on the how's this is useable and why's it is practical in the real world. Terrific!!

    • @meahkim8672
      @meahkim8672 ปีที่แล้ว

      Thank you!!!!! I've been in tears trying to learn this.

  • @EricAyensu-t9z
    @EricAyensu-t9z 5 หลายเดือนก่อน

    This is the best piece of tutorials on the internet, the teaching skills and presentation are on point. Good work done.
    Watching from Ghana.

  • @MrItsjustmeok
    @MrItsjustmeok 4 ปีที่แล้ว +4

    Hey, can you drop a skincare routine? Skin goals!

  • @enda19
    @enda19 3 ปีที่แล้ว +1

    Thank you Kevin! You had a very nice tone of voice that made it very easy to listen to.

  • @richardlabonne4913
    @richardlabonne4913 4 ปีที่แล้ว +5

    Could you do a part 2 where you show us how to create a pivot table from multiple worksheets?

  • @anthonyelliott243
    @anthonyelliott243 2 ปีที่แล้ว

    You Sir, are amazing!!! Been scared of pivot tables for years…you just made them far less scary!

  • @Хонгор.Одгэрэл
    @Хонгор.Одгэрэл 5 ปีที่แล้ว +11

    youre a damn life savior kevin

  • @dannyjfunez
    @dannyjfunez 2 ปีที่แล้ว

    This is so well done! the bags under his eyes alone, are enough proof that he knows exactly what he is doing and has extensive knowledge

  • @michellewilson6575
    @michellewilson6575 2 ปีที่แล้ว

    I opened my own excel file and copy pasted your spreadsheet from the sample data in the first link below and switched back and forth watching your video and performing the same functions. That was awesome. Some commands on my quick access tool was grayed out though but I found other ways on MS 365 to finally be able to perform the function, such as expand and collapse button. All in all I was able to follow along. It just takes getting familiar with. You did a great job making it feel easy. I did watch a few times too.

    • @CharlesBBB
      @CharlesBBB ปีที่แล้ว

      what was the solution to collapsing and expanding that you found?

    • @CharlesBBB
      @CharlesBBB ปีที่แล้ว

      Nevermind-- I figured it out...😁 (you just have to click on the "make" first to select a collapsable/expandable item)!😬

  • @jaynemathiot6617
    @jaynemathiot6617 2 ปีที่แล้ว +1

    You are really great to watch Kevin. Love your videos - really enjoyable tutorials. Thank you.

  • @JPWick
    @JPWick 2 ปีที่แล้ว

    this guy is hands-down the best MS tutor

  • @LAZOBY
    @LAZOBY 2 ปีที่แล้ว +1

    Wow, very clear, you made it see like is very easy. I really appreciate it. May God bless you.

  • @tourdeforce2881
    @tourdeforce2881 2 หลายเดือนก่อน

    Learning is so much easier listening to someone who can articulate clearly

  • @jenbcosgrove
    @jenbcosgrove 4 ปีที่แล้ว

    This video saved me so much time! I only had to watch a couple of minutes before it told me exactly what I needed to know. Thanks!

  • @carl8689
    @carl8689 4 ปีที่แล้ว

    The Video is very detailed in explaining what a Pivot table does and how to do a pivot table on your own. Really do appreciate this video Kevin, thanks for sharing!

  • @chilledClouds
    @chilledClouds 2 ปีที่แล้ว

    Ooh man, I was getting ready for a long... long night, I have to prepare a few monthly reports that I might need for an upcoming meeting, it would've easily taken me hours, then I remembered seeing someone using Pivot some time ago, I did a search and this Video was the first I clicked. I am so happy right now, wow... it took me minutes to doit using this Video. Thank You Kevin, it always looked so Scary but you made it so very easy to follow. I'm subscribing now.

  • @stovietex
    @stovietex 2 ปีที่แล้ว

    Good job showing the basics. I wish I had found this years ago as it would have been very helpful to get started! I avoided Pivot Tables like the plague and did my slicing and dicing manually and with filters.

  • @nxtchpforme9154
    @nxtchpforme9154 3 ปีที่แล้ว

    You are a born teacher
    Engaging context. Hoping you explain the KIND OF DATA and how text impacts the count calculations!! Data in. Data out!!

  • @shadetreesam250
    @shadetreesam250 ปีที่แล้ว

    Great Introductory Tutorial! The most valuable feature for me was that it not only explained _how_ to create pivot tables and pivot charts, but _why_ .

  • @fakeobsession
    @fakeobsession 2 หลายเดือนก่อน

    Thank you so much. No matter the outcome of the interview I had, you helped me terribly, and I was able to use pivot tables with zero prior experience 😄

  • @chrisjaggernauth1023
    @chrisjaggernauth1023 ปีที่แล้ว

    Excellent video. Clear, concise and I was able to do what I needed to do 2 mins after watching the appropriate section. Well done!

  • @marshallhosel1247
    @marshallhosel1247 3 ปีที่แล้ว +1

    I find your tutorials engaging and helpful refreshers for us experienced excel users. Thank you.

  • @lachicaSVT
    @lachicaSVT 3 ปีที่แล้ว

    thank you!!! I am doing a stats project with 3 guys who are amazing at understanding the data and Excel and...here is me. this tutorial helped!

  • @sabrinasantillanhernandez4003
    @sabrinasantillanhernandez4003 2 ปีที่แล้ว

    Prepping for an interview and refreshing- this was PERFECT! Thank you!

  • @taliahh25
    @taliahh25 ปีที่แล้ว

    Thanks for the lesson! This was to the point, and the flow of the lesson was great; not too fast or slow. I will continue to watch your other videos.

  • @MrHansBattle
    @MrHansBattle ปีที่แล้ว

    Thank you! Short and simple -- great explanation for anyone starting from zero on pivot tables.

  • @janicesmyth2183
    @janicesmyth2183 ปีที่แล้ว

    thank you for your videos. You Mynda, Leila are my favorite excel teachers. I wished you kids were around in the 80's to teach me!

  • @Queenshadea86
    @Queenshadea86 2 ปีที่แล้ว +1

    Wonderful ! Thank you so much for taking time out to help me.

  • @MrAllister88
    @MrAllister88 3 ปีที่แล้ว

    Hey Kevin, thanks for this - I've always hated Excel with a passion and would always stay away from it when possible. I've got an interview tomorrow on Pivot Tables, and I'm sure this will help me greatly tomorrow!

  • @bobdunyak9869
    @bobdunyak9869 2 ปีที่แล้ว +2

    Hi Kevin - Thank you for the outstanding presentation of pivot tables. I appreciate your practical and clear teaching style.