Excel Pivot Tables Tutorial

Поделиться
HTML-код
  • Опубликовано: 25 дек 2024

Комментарии • 68

  • @LearnitTraining
    @LearnitTraining  7 месяцев назад +4

    Exercise Files: learnitanytime.com/p/exercise-files-excel-pivot-tables-tutorial-2024

  • @christianhennig4622
    @christianhennig4622 3 дня назад +2

    Your instruction has greatly impressed me; it is clear, calm, and simple to follow. Many thanks for making this video available.

  • @thaovu-fd8jy
    @thaovu-fd8jy 17 часов назад +1

    Thank you so much Mo Jones!

  • @MosGel-l2j
    @MosGel-l2j 3 месяца назад +4

    This video on Excel pivot tables is excellent. It provides a comprehensive explanation with clear examples. Great work!

  • @jazminsanez7980
    @jazminsanez7980 5 дней назад +1

    Amazing, thank you ❤️

  • @yugo6946
    @yugo6946 4 месяца назад +3

    Thank you so much Mo Jones, I thoroughly enjoyed this. You were very detailed, and you made Pivot tables tutorial look like its A, B, C. You are indeed a great instructor! Bless up!

  • @diaashaaban1111
    @diaashaaban1111 7 месяцев назад +4

    I just wanna send love and thanks to the great instructor Trish Connor ❤️

  • @valeriemac679
    @valeriemac679 3 месяца назад +2

    All the steps are easy to follow and remember. Thank you so much for this informative tutorial video!!

  • @entertaimentoo231
    @entertaimentoo231 7 месяцев назад +2

    Thanks for this kind of productive course of Excel. Please make more videos about excel we really want to learn Excel from this Channel.
    ❤ Love from India.

  • @samueltafere5400
    @samueltafere5400 7 месяцев назад +5

    I very much admire you for your presentation

  • @devicetest-b4h
    @devicetest-b4h 10 дней назад +1

    LIKED IT

  • @peterrandu7666
    @peterrandu7666 2 месяца назад +1

    Thanks for your hard work

  • @klyuvert
    @klyuvert 5 месяцев назад +1

    i didn't know anything about power pivot, thanks a lot

  • @kingsfordofori1887
    @kingsfordofori1887 4 месяца назад +1

    Thanks a lot for the training

  • @upishararuwan1881
    @upishararuwan1881 5 месяцев назад +1

    Great video. Very helpful. Thank you!

  • @lwazimthembu855
    @lwazimthembu855 7 месяцев назад +1

    I believe in this channel, you guys taught me Sharepoint 🙌, I'm still learning thou

  • @adamtabor6754
    @adamtabor6754 6 месяцев назад +2

    Easy explained and for that very useful.👍

  • @MicrosoftSolutions
    @MicrosoftSolutions 7 месяцев назад +1

    It seems you have done this work from the heart! Can you give me some tips after looking at my work too?🙏

    • @LearnitTraining
      @LearnitTraining  7 месяцев назад

      Thanks! We saw a few of your videos and our only advice is to ditch the AI voiceover and use your own voice. People love learning from people.

  • @rc3794
    @rc3794 6 месяцев назад +1

    Thank you ❤

  • @michelecuprak4266
    @michelecuprak4266 Месяц назад

    Thank you!!!!

  • @ragulmarley4900
    @ragulmarley4900 3 месяца назад +1

    😊 really good nice explanation any video for power bi sir

    • @LearnitTraining
      @LearnitTraining  3 месяца назад

      Here you go!
      ruclips.net/video/e6QD8lP-m6E/видео.html

  • @BelalNegm
    @BelalNegm 3 месяца назад +1

    Excellent

  • @sakottomitav
    @sakottomitav 2 месяца назад

    Thank you so much!!!

  • @sonalisinghal988
    @sonalisinghal988 7 месяцев назад +6

    Plz made the series on SQL too..

    • @LearnitTraining
      @LearnitTraining  7 месяцев назад +5

      That series is coming this October!~

    • @chukylo-k2h
      @chukylo-k2h 3 месяца назад

      @@LearnitTraining October is almost here.... I can't wait Moe..... You such a wonderful teacher 🤝... Do you have a power BI series yet?

  • @benosborne413
    @benosborne413 5 месяцев назад +1

    Great. Thanks. Pity it does not update automatically. Must refresh every time

    • @LearnitTraining
      @LearnitTraining  5 месяцев назад

      This article may help: www.howtogeek.com/789536/how-to-refresh-a-pivot-table-in-microsoft-excel/

  • @yehualashetTeklemariam
    @yehualashetTeklemariam 3 месяца назад +1

    great thank you

  • @jeangreen432
    @jeangreen432 7 месяцев назад +1

    This is a wonderful tutorial, thank you so much for the opportunity to learn about pivot tables! May I please ask your opinion on creating a payroll system for 10 employees using pivot tables? Do you see any cons? Thank you again for your expertise and time!

    • @LearnitTraining
      @LearnitTraining  7 месяцев назад +1

      You can definitely do it! This article may help: excel-dashboards.com/blogs/blog/excel-tutorial-create-payroll

    • @jeangreen432
      @jeangreen432 7 месяцев назад

      @@LearnitTraining Thank you for your kind reply, it was a nice article!

  • @benjiking-dj7zs
    @benjiking-dj7zs 3 месяца назад +2

    I like the ways

  • @masoudakbari6284
    @masoudakbari6284 Месяц назад +1

    awesome is the only thing I can say

  • @crimetimereports
    @crimetimereports Месяц назад +1

    Lab Task
    Total sales for state: TX = $17647
    Total sales for City: Salem = $21152
    # of Production packages sold = 16

    Insert a calculated Field
    Total commissions earned @5% = $7822
    Commission for Cara Olson = $1227

    Insert a Timeline
    Total sales for Q2 in 2023 = $44773

  • @xxLvlxx
    @xxLvlxx 4 месяца назад

    Hi, I wanted to follow the tutorial but I can't find the Excel options screen. In my ribbon I don't have the files tab next to home. Do you have any idea how to open that? Thanks 🙏

    • @LearnitTraining
      @LearnitTraining  4 месяца назад

      This article may help: support.microsoft.com/en-us/office/office-options-the-general-tab-c51b7db7-d59e-448a-aa8a-7e9310cebae3#:~:text=To%20see%20general%20options%20for,click%20File%20%3E%20Options%20%3E%20General.

  • @BelalNegm
    @BelalNegm 3 месяца назад +1

    ❤❤❤

  • @chukylo-k2h
    @chukylo-k2h 3 месяца назад +2

    Why is the Analyze Data shortcut is not popping up when I type the "quick access....." is there somewhere it can be turned on and off?
    1- Total sales for state: TX =$17,647.00
    2- Total sales for City: Salem =$21,152.00
    3- # of Production packages sold = 42
    4- Total commission earned @5% = $7,822
    5- Commission for Cara Olson = $1,227
    6- Total sales for Q2 IN 2023 = $2239........
    comment if you arrived at the same value.... T for Thanks..😛

    • @zezo977
      @zezo977 3 месяца назад

      Total sales for Q2 in 2023 = $44,773😁