PivotTables for Excel: A Quick 1-Hour Crash Course!

แชร์
ฝัง
  • เผยแพร่เมื่อ 31 ธ.ค. 2024

ความคิดเห็น • 40

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

    ✅Download the free demo file and follow along
    ➡www.simonsezit.com/article/pivottables-in-excel-webinar/
    🔥Check out our FREE 300+ hour training course playlist here ➡️
    th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
    🚀 Boost your Excel skills with these free Excel playlists 👉🏼
    th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
    & here 👉🏼 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
    & Pivot Table training here 👉🏼th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html

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

    It is so nice to have an instructor that knows what she is talking about. The student goes from "Gee I don't know?" to I can actually do it and is so thankful starts to equates the teacher as some kind of divine being.

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

      I'm glad you found the instructor helpful! It's always great to have someone who can guide you through the learning process.
      We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
      For more information about Simon Sez IT courses, visit:
      SimonSezIT.com: www.SimonSezIT.com/
      Stay in touch!
      TH-cam Channel: www.youtube.com/@SimonSezIT
      LinkedIn: www.linkedin.com/company/simon-sez-it/
      Please SUBSCRIBE ► th-cam.com/users/simonsezittraining
      ♥️ We appreciate your support!

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

    At the very end, when combining data from another worksheet…The currency for July data is not in U.S. dollars, so before adding the ‘July’ data to the ‘Store’ data the currency should be formatted to U.S. so that the sales amount remains consistently formatted. This instructor states in several videos to always clean data; formatting is a form of cleaning. What an awesomely, awesome trainer; thank you. No more pivot table anxiety for me.

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

    Hello Simon Sez and to the trainer here. This was an EXCELLENT Video. I learned SOO much from this video. You explained Pivot Tables very very well. Thank you soo much :)

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

    You are the best! Thank you!

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

    Pivot tables are powerful ways to summarize information. Excellent video!

  • @junevibes.365
    @junevibes.365 2 ปีที่แล้ว +4

    This is very crucial topic in Excel after Vlook up and Hlook up.

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

      There is additional Excel training here if you need it -> th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html

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

    Thank you so much for making things easy to understand

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

      Glad it was helpful! 🙂

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

    Thanks for sharing your valuable knowledge,

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

      You're very welcome! Thanks for watching!

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

    I'm late so I'm going to watch this again. I've always been curious about pivot.

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

      Hope you like it,, Mavro Syvannah 😉

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

    Excellence mist be celebrated. Much appreciated and inspired.

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

      Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
      th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html

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

    Excellent

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

    Excellent Video!

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

      Glad you enjoyed it. Thanks for watching! 🙂
      🔥Check out our FREE 300+ hour training course playlist here 👉
      th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html

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

    thank you, really helpful

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

    Useful Thank you 🤝

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

      Welcome 👍 😉

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

    useful course!

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

      Glad you enjoyed it. Thanks for watching! 🙂
      🚀 Level up your Excel skills with free training here 👉 th-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 th-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
      & Pivot Table training here 👉 th-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html

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

    Good luck for your channel

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

    Thanks for this wonderful tutorial. Unfortunately, I've not been able to download the demo file to follow along. it's always asking to create an account and there's no free account.

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

      Hello there. We shared the download link in the description. Please check it out.
      Thanks for watching!
      🔥Check out our FREE 300+ hour training course playlist here 👉
      th-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html

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

    Thank you, how can I get a link to the webinar?

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

      Hi Marcel. The video is available on our TH-cam channel, so you can rewatch as needed.

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

    When formatting numbers, if we are supposed to use Value Field Setting and Number Format then why are the options for Format Cells and Number Format in the right click list? I don't see the answer to that.

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

    I am not able to download the demo file, it is asking me to create and account and pay!

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

      Hello, Please try the link again and you should be able to download them now.

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

      @@SimonSezIT still the same problem bud

  • @arifkhan-sy1it
    @arifkhan-sy1it ปีที่แล้ว +1

    I love u

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

    Why can’t we see the table in the field list? How to add calculated measure - fields ?