Pivot Table Excel | Step-by-Step Tutorial

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 56

  • @KevinStratvert
    @KevinStratvert  2 місяці тому +2

    🥷 FULL EXCEL COURSE: Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
    🙏 REQUEST VIDEOS - forms.gle/BDrTNUoxheEoMLGt5
    📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/

  • @dhritimangiri4092
    @dhritimangiri4092 14 годин тому

    man you seriously have the best video on pivot table. concise , informative yet understandable

  • @aubreygonzalez4715
    @aubreygonzalez4715 Місяць тому +8

    I am just started to really get into Excel and this video was so easy to follow and straight and to the point. You sir are amazing. Thank you for this!

  • @Gorman-84
    @Gorman-84 Місяць тому +5

    Thanks Kevin, as always. After watching many videos, this is the first time pivot tables have clicked for me. You showed all the perfect examples for fields. Thanks for all you do.

  • @lydethful
    @lydethful 2 місяці тому +5

    The best Pivot table guide I've watched

  • @alegit123456
    @alegit123456 2 місяці тому +1

    Love the videos very helpful!
    I handle medical data and my challenge is getting all the different health screenings to be easily displayed with their benchmarks. I was wanting to build an interactive dashboard but getting the data to appear with all the information easily accessible is a challenge. Man I miss working in retail environments😂 so much easier.

  • @johnakinbowale1571
    @johnakinbowale1571 2 місяці тому +1

    Good job Kevin as always. Please keep it coming.

    • @KevinStratvert
      @KevinStratvert  2 місяці тому

      More to come! Let me know what other topics you're interested in. 👍

  • @kudiratakanbi4458
    @kudiratakanbi4458 2 місяці тому

    This is fantastic, explained in a concise manner. Thank you Kevin

  • @BlackRussian0795
    @BlackRussian0795 Місяць тому

    Wow!!! I feel like a genius now, thank you, Kevin!

  • @lorenakademar5267
    @lorenakademar5267 2 місяці тому +1

    Amazing explained!! Thank you Kevin!!

  • @ZephyrusMHawkCollege
    @ZephyrusMHawkCollege Місяць тому

    Thank you for this I can now complete my project with clarity

  • @Indezine
    @Indezine 2 місяці тому

    Explained in simple terms. Thanks, Kevin.

  • @jeffp3873
    @jeffp3873 2 місяці тому +2

    My burning question is about the set-up to have the sum of sales default to currency? I always have to manually adjust the formatting and when you dragged the field, it looked like currency was automatic.

    • @ogaufiponyane8098
      @ogaufiponyane8098 Місяць тому

      i have the same problem too. when i drag the Sales Amount to Values it gives me different values than what is shown on the video. and now am stuck

  • @curtisviewpoints3947
    @curtisviewpoints3947 23 дні тому

    You are the BEST!!!!!!! Well Done thanks for ur help.

  • @radleywilks9371
    @radleywilks9371 5 днів тому

    Great Video thanks so much

  • @nagireddysomula3103
    @nagireddysomula3103 2 місяці тому +4

    Nice tutorials

  • @MohamedMahat-xl7ie
    @MohamedMahat-xl7ie Місяць тому

    Fantastic and enjoyable. thanks sir for your commitment.

  • @AbdulRahman-yp6oy
    @AbdulRahman-yp6oy 2 місяці тому +5

    Excellent
    Sir please make videos on PowerBI and Power Query

  • @luukscheepers-ii6ye
    @luukscheepers-ii6ye Місяць тому

    your the goat kevin

  • @qudratullahstanikzai408
    @qudratullahstanikzai408 11 днів тому

    Thanks very useful

  • @LauraandLeeSheridan
    @LauraandLeeSheridan Місяць тому

    Very useful. Thanks.

  • @Alibeysuleimanoglu
    @Alibeysuleimanoglu 2 місяці тому +1

    I love this

  • @rachellsta.brigida3034
    @rachellsta.brigida3034 2 місяці тому

    Very helpful guide❤❤❤

  • @mariaknais9296
    @mariaknais9296 2 місяці тому +1

    Thank you!

  • @damilolaoyadongha6749
    @damilolaoyadongha6749 2 місяці тому

    Great delivery.

  • @JoseTavares-xu8pc
    @JoseTavares-xu8pc 2 місяці тому

    Awesome like always.

  • @GlitchNigh721
    @GlitchNigh721 2 місяці тому

    Very helpful thank you ❤

  • @vinshuks1579
    @vinshuks1579 2 місяці тому

    Excellent!!! Thanks very much

  • @romaine3083
    @romaine3083 2 місяці тому

    very helpful. thank you!

  • @octaveng
    @octaveng Місяць тому

    I have a question, while putting sales of salesperson om the table, how do we arrange it on the table in the event multiple people sold that day

  • @carbsnnnnn
    @carbsnnnnn 2 місяці тому +1

    thank you

  • @vaibhavvaishnav6519
    @vaibhavvaishnav6519 2 місяці тому

    Hey Kevin, is your default font in excel Aptos Narrow

  • @4GQTV
    @4GQTV 2 місяці тому

    Nice!

  • @mash_0t099
    @mash_0t099 2 місяці тому

    thank you🙂

  • @MyeCommerceJourney
    @MyeCommerceJourney 2 місяці тому

    Super video

  • @les_studio_room
    @les_studio_room Місяць тому

    Can you create a pivot table using headers from a column instead of a row?

  • @chizobaesthernkwoopara5675
    @chizobaesthernkwoopara5675 2 місяці тому +1

    How can I download the data set

  • @sparklegirl1111
    @sparklegirl1111 Місяць тому

    I don't have the design tab or the PivotTable Analyze in mine. So I'm not able to follow after that. How can I fix that

  • @filipatan
    @filipatan 2 місяці тому

    Great video, thank you! Except I always want cookies after watching them.

  • @bhavneshparikh8283
    @bhavneshparikh8283 2 місяці тому +1

    Can be available 101 ways to master pivot tables pdf?
    Pl share it

  • @gadget_Bob
    @gadget_Bob 2 місяці тому +9

    Good info but I'd rather have it 2 minutes longer and talking a little slower.

    • @KevinStratvert
      @KevinStratvert  2 місяці тому +12

      Here's the extended version which goes into more depth: ua-cam.com/video/PdJzy956wo4/v-deo.html

    • @Lionel_T_Pereira
      @Lionel_T_Pereira 2 місяці тому +4

      The play speed of the video can be adjusted to slow down or speed up speech.

    • @NitroVenom777
      @NitroVenom777 2 місяці тому +3

      Or slow the video

    • @gadget_Bob
      @gadget_Bob 2 місяці тому

      ​Or just speak at a normal rate of speed​@@NitroVenom777

    • @TheRealPetunia
      @TheRealPetunia Місяць тому

      MUCH slower!

  • @dwang085
    @dwang085 2 місяці тому

    K🍪Co.

  • @beastmodebrother4337
    @beastmodebrother4337 2 місяці тому

    I thought this guy was thio joe

  • @moeomeohuyenmeo1883
    @moeomeohuyenmeo1883 2 місяці тому +1

  • @jingong2404
    @jingong2404 10 днів тому

    Nice tutorials and very helpful guide, Thank you🙏🙏🙏