Multiple Pivot Tables and Pivot Chart with very Simple Macro

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

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

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

    This work & automation is unbelievable!! hats off Nabil Sir. Love from India

  • @venkatiyer7459
    @venkatiyer7459 2 года назад

    Nabil Sir ... I couldn't believe my eyes that I could do it after watching your video step by step ... of course I made mistake and I cleared the macro and did once again ... thank you so much

  • @kamleshrana391
    @kamleshrana391 3 года назад

    Very nice. Explained in lucid way

  • @felipegarduno7949
    @felipegarduno7949 3 года назад

    Excellent tutorial my friend.Thank you so much

  • @nadeemjohn6126
    @nadeemjohn6126 4 года назад +1

    Excellent Tutorial Sir! Great Effort. Thank you very much.

  • @LotfyKozman
    @LotfyKozman 6 лет назад +4

    Great efforts as usual. Thanks.

    • @Officeinstructor
      @Officeinstructor  6 лет назад +1

      Thank you for the continuous encouragement
      متشكر جدا

  • @MAsOCLisMO
    @MAsOCLisMO 9 месяцев назад

    Nabil, thank you so much for the help but I would like to know how to make that macro but using a button in a another worksheet.

  • @camilali8913
    @camilali8913 5 лет назад +1

    Very good tutorials every time! Thank you so much!

  • @sasavienne
    @sasavienne 5 лет назад +1

    An excellent tutorial.. 🌟 🌟 🌟 Thanks a lot. 👍 🌟 🌟

  • @gosuprateja
    @gosuprateja 6 лет назад +2

    Very good presentation

  • @saremammar9246
    @saremammar9246 4 года назад +1

    Cool Video
    Thank You Dr. Murad

  • @venkatiyer7459
    @venkatiyer7459 2 года назад

    My smiley is not in color when I added the same to the QAT ... any specific reason !!!!

  • @Robert8455
    @Robert8455 5 лет назад +1

    Very impressed by your high quality presentation. No stumbling over what to say, clear and concise steps and several excel tricks rolled together. You have a new subscriber for your efforts!

    • @Officeinstructor
      @Officeinstructor  5 лет назад

      What a nice comment... Subscribe to my blogsite to receive a Free copy of my text book"Pivot Tables from Zero to Hero"

  • @aermecsales7350
    @aermecsales7350 3 года назад +1

    Nice one

  • @ساجدصديق
    @ساجدصديق 3 года назад

    A wonderful..Empty cells cause a problem in the Pivot Table and appear in print that I want to cancel or not show

  • @faizaziz6024
    @faizaziz6024 5 лет назад

    Great, Useful and helpful.

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

    In mine it is showing subscription out of the range

  • @samyraad5258
    @samyraad5258 4 года назад +1

    Nabil , that’s amazing , could you please create food cost calculator , showing margin and cost % with a pie chart . That’s will be helpful.

    • @Officeinstructor
      @Officeinstructor  4 года назад

      Thanks Samy.
      That's a good idea by the way which could lead us to much more topics. I kindly ask you to send me detailed raw data and requirements to think how I can build a project out of it. Check my company website for my contact information.

    • @samyraad5258
      @samyraad5258 4 года назад

      Officeinstructor appreciate the fast reply,i dont have any raw data in hands, but can be a simple example for food recipes, like tabouleh
      With drop down list for kg, grams exc.
      And to make it more attractive we will add reset button, tank you much and keep up the great lovely lessons .
      Samy

  • @sunilsidam
    @sunilsidam 4 года назад

    How to creat buttons in sheet with this pivot table

  • @yacniandou2753
    @yacniandou2753 6 лет назад +1

    Hi thanks. Awesome

    • @Officeinstructor
      @Officeinstructor  6 лет назад

      Thank you

    • @yacniandou2753
      @yacniandou2753 6 лет назад

      Officeinstructor . Thanks. Looking for a simple way to drill down data in a dashboard worksheet based on 3 worksheets customers, invoices and payments. Kind of relationships in Excel

    • @Officeinstructor
      @Officeinstructor  6 лет назад

      Very easy to do in Power Pivot

  • @laurisolja
    @laurisolja 4 года назад

    Great tutorial. I got so much out of it!
    Do you have any idea why I get error's for my Macros if i use any kind of Pivot Table in them? I've followed every step you showed in this video but when running the macro I've just recorded I get error '424' or '5' and the Pivot Table doesn't look right.

  • @venugopal7161
    @venugopal7161 5 лет назад +1

    Good morning Nabil sir I am big fan of you.But my concern is try to publish your excel videos at least one video for a week sir.I am very much anxiously waiting Nabil sir.

    • @Officeinstructor
      @Officeinstructor  5 лет назад

      Thank You Venu Gopal for being a loyal fan... I will do my best to post more frequently... Stay Tuned.
      Nabil Mourad

  • @tamerghounem1181
    @tamerghounem1181 3 года назад

    mazing

  • @nathanwalsh3829
    @nathanwalsh3829 5 лет назад +1

    uhhhgggg.. the video was great but you didn't show me how to record the pivot chart :( my recording does not work :(

    • @Officeinstructor
      @Officeinstructor  5 лет назад

      Select any cell in the Pivot Table and hit Alt + F1

  • @Tina-gp4rg
    @Tina-gp4rg 5 лет назад +1

    100000 likes