Best Pivot Table Design Tips to Impress Anyone

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

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

  • @KenjiExplains
    @KenjiExplains  Год назад +13

    🔥 10x Your Excel with our course: www.careerprinciples.com/courses/excel-for-business-finance

  • @bellalisah8174
    @bellalisah8174 2 дня назад

    You Do a Remarkable Job in ALL Your Video's.......THANK YOU so very much for them. Im able to learn new functions, features, ... Do you have a video on all of Excel's short-cut keys?

  • @musamaiza6259
    @musamaiza6259 11 месяцев назад +7

    You're just a blessing to me Bro. Can't stop looking out for your videos. Truly appreciate

  • @Quintero243
    @Quintero243 Год назад +28

    This has become my new favorite channel on RUclips.😇 Props to you for all the hard work you put into these videos, I've been a member of this amazing society of investors for a while now, and I can't articulate how much it has transformed my life. We're not just here to earn money; we're here to uphold one another, grow collectively, and rejoice in every stride toward our financial aspirations...

    • @Krystyna768
      @Krystyna768 Год назад +1

      I completely resonate with your experience, if you are talking about expert Mrs Josefina then yes ,working with her transformed my life also, suprised to see other people here work with her after her skills was talked about on the show i started working with her , Before, I was uncertain and made impulsive moves. With our her insights, I've learned patience and strategy. My investments are flourishing, and I'm on my way to achieving my financial goals. Let's inspire others to take control of their finances! Great channel

    • @Quintero243
      @Quintero243 Год назад

      Your words really hit home. I'm talking about expert Mrs Josefina She didn't just teach me about the market; she taught me about myself as an investor. I've found my niche, and my portfolio reflects that. Together, we're not just trading; we're building futures. Here's to more informed decisions and shared successes

    • @razyadat4601
      @razyadat4601 Год назад

      I'm so grateful to have found this community and Mrs Josefina A. Gallardo, just like you her guidance helped me navigate the complexities of market. I used to fear losses, but now I view them as opportunities to learn and grow. I've not only seen huge monetary gains but also a boost in my confidence as an investor. i am happy to keep learning and evolving

    • @martina7786
      @martina7786 Год назад

      Though I'm not a subscriber here, I've heard wonderful things about Mrs.Josefina A. Gallardo .It's disheartening that she's often fully booked, making it challenging to connect with her directly. I'm truly hoping for an opportunity to engage with her in the future.

    • @shuchangtianyu2799
      @shuchangtianyu2799 Год назад

      Your story is inspiring , Expert Josefina Gallardo impact goes beyond numbers; it's about personal growth. I've learned discipline, resilience, and the importance of continuous learning. Every trade is a lesson, and I've gained a wealth of knowledge along the way. Let's stay committed to evolving as investors and supporting one another. Here's to meaningful growth and lasting success!..

  • @joaolucas5396
    @joaolucas5396 Год назад +17

    The camera tip is a gold bonus! Awesome!

    • @KenjiExplains
      @KenjiExplains  Год назад +1

      It really is! thank you

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

      Thank u. Thats a game changer ❤

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

    The camera tip was mindblowing!

  • @adderlyacevedo8232
    @adderlyacevedo8232 Год назад +5

    All of your videos are pure gold! I learn something new in every one!

  • @AmolMY
    @AmolMY 8 месяцев назад +1

    This was one of the most useful videos I have seen. Thanks for teaching new skills to make my excel sheet impressive. 🙌

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

    Many years doing many stuffs with excel, i realize i knew camera icon just know. it's amaze me. subscribe

  • @kaushiksrivatsa
    @kaushiksrivatsa Год назад +5

    The camera feature could be a game changer in my line of work❤

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

    Generally I forget to post comments on the videos that I like. But posting it today since I really really loved this video. Great work, keep it up!

  • @PreethyKarthik
    @PreethyKarthik 8 месяцев назад

    Excellent Kenji. Thanks for the incredible teaching

  • @KManvik
    @KManvik Год назад

    Kenji...you are amazing...one of the best learning youtube channel!!

  • @williamchurch711
    @williamchurch711 Год назад

    This has become one of my favorite RUclips channels.

  • @MrFuegi
    @MrFuegi Год назад +1

    loved this video! you don't always have time to make a nice chart/graph or put it all in a PPT so these tricks to make a pivot table more "share-friendly" are great

  • @WanHui-g3j
    @WanHui-g3j 9 месяцев назад

    Extremely impressed by the camera function !!!🎉 really superrrr nice vedio 🎉❤

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

    for bonus feature use camera function copy the pivot table, if we copy to totally new excel file, email or word file, changes in master table still can reflect?

  • @PorshaLaVieBelle
    @PorshaLaVieBelle Год назад

    Kenji you have the best channel

  • @brightappiah7809
    @brightappiah7809 11 месяцев назад

    You are the best Kenji..
    thanks

  • @camlex6310
    @camlex6310 Год назад +2

    Super helpful!! The table looks great

  • @AprilAi-sj5pp
    @AprilAi-sj5pp 5 месяцев назад

    This is a really good video, thank you! a question for you, on 4:59, when you move your cursor to the minus sign, the cursor changed to a black arrow and pointed to the right, my cursor does not work this way, it is still a white arrow and pointed to the upper left. The reason I am asking is I need to get this black arrow and click a cell so the values on the same category will be highlighted for a formatting task, do you have any idea?

  • @nurasafewo9781
    @nurasafewo9781 10 месяцев назад +1

    As helpful as usual, thank you indeed.

  • @chimfwembechipili
    @chimfwembechipili Год назад +1

    Indeed kenji explains 💯

  • @atatinatiqotulm.f3950
    @atatinatiqotulm.f3950 6 месяцев назад

    Thank you Kenji, Excel looks great and interesting to me now. It's really nice meet your channel :)

    • @KenjiExplains
      @KenjiExplains  6 месяцев назад

      Thank you for dropping by :)
      Really appreciate your comment!

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

    thank u so much sir for better and clean explanation

  • @adambalaz1604
    @adambalaz1604 8 месяцев назад

    Really good tips, thanks! :)

  • @TVSCDN
    @TVSCDN 10 месяцев назад +1

    Thanks🌹🌹🌹🙏🙏🙏😊
    Would like to know from you how an individual should analyse
    his bank statements to present it easily to the Income Tax official😅

  • @hishamsenossy7165
    @hishamsenossy7165 Год назад

    thaaanks you helped me a lot in my work 😄😍😍

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

    amazing teacher.

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

    Nice job!

  • @skip031890
    @skip031890 Год назад

    You uploaded this video right on time because I am trying to put something together using a pivot table right now and was having trouble. Amazing video and great channel. Thanks a lot.

  • @luisllontopbarahona3188
    @luisllontopbarahona3188 Год назад

    Good job with the video. THE last feature is very good. Quick question... does it also update when copied in a word document?

  • @antonynganga7868
    @antonynganga7868 Год назад

    Awesome job Kenji,💪💯

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

    Omg, wish I watched this couple years ago

  • @rexbk
    @rexbk Год назад

    Thanks Kenji.

  • @pradipmajhi8636
    @pradipmajhi8636 Год назад

    Dear Kenji sir please again bring video tutorial on data cleaning deeply in a different way. Thank you

  • @willzinner8813
    @willzinner8813 Год назад +1

    thanks sir very useful

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

    camera tip is mind blowing

  • @SeemaSharma-lj3cf
    @SeemaSharma-lj3cf 11 месяцев назад

    very useful👌

  • @wesamaraj8705
    @wesamaraj8705 6 месяцев назад

    many thanks

  • @jiggssales3071
    @jiggssales3071 6 месяцев назад

    You're awesome!

  • @TamTinHoc2024
    @TamTinHoc2024 6 месяцев назад

    Thanks so much

  • @helmyhelmy3767
    @helmyhelmy3767 Год назад +1

    A question. When I click on a value in the pivot table, it opens a new sheet with the values, how to fix the column width and the number formatting each time ?

  • @hasanmohammadtareq89
    @hasanmohammadtareq89 8 месяцев назад

    Awesome!

  • @ReaganShrestha
    @ReaganShrestha Год назад

    Make a video on KPIs for finance.

  • @SudhanshuBadge
    @SudhanshuBadge 10 месяцев назад

    You must add one more sheet in which we can see client requirements. So we can directly execute and practice by seeing the sheet of client requirements.

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

    Bonus trick super

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

    Hi Kenji, if we have 3 sheet (raw, pivot, table), can the table(from pivot) automatically updated if we change the raw data?

  • @nishanth4323
    @nishanth4323 Год назад

    Yeah now that's some useful tips 👌👌......🙏

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

    RUclips University. Awesome

  • @samuelkim5996
    @samuelkim5996 8 месяцев назад

    @kenji Explains about the certificate pls?

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

    Coool🎉❤ thanks s lot

  • @foreverriver4989
    @foreverriver4989 Год назад

    What is the best to learn excel or access?

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

    Great

  • @joewahosky5223
    @joewahosky5223 Год назад

    wow! camera could be a game changer

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

    Hi, I have a data sheet that I want to calculate. 1 = Contractual, 2 = Actual, 3 = Variance. In the variance I want to indicate a positive or negative value. If the actual are less that the contractual, then it must be minus or indicated in red. If the actual are more than the contractual, then it must indicate a plus. How would I do that?

  • @gecarll26
    @gecarll26 Год назад

    Next, can you make a percentage computation using excel and also chart percentage. Thanks God bless, just wanna learn more. #favorpls

  • @rexbk
    @rexbk Год назад

    Hi Kenji, oot.
    Do you sell an Accounting Book Keeping in Excel?

  • @gecarll26
    @gecarll26 Год назад

    Thus, this tutorial can apply in what windows version?

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

    Cannot edit subtotal, block total or grand total names. (Error message from Find and Replace Sum of) Please help me out what can I do?

  • @samuelkim5996
    @samuelkim5996 8 месяцев назад

    Please is the certificate internationally recognized?

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

    Can you just give a discount on that course I eagerly wanted to learn excel from you but im having fund issues!! Could you please help me get it in a low price pls

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

      Hey thanks for your interest. For queries regarding the courses reach out to info@careerprinciples.com

  • @mrpdmasta
    @mrpdmasta Год назад +5

    Biggest problem with pivot tables, you can’t lock the work and filter by largest to smallest. You can only do that with tables, so I’ve abandoned pivot tables.

    • @laminulams8723
      @laminulams8723 11 месяцев назад +8

      You can filter, just you don't know how.

    • @mrpdmasta
      @mrpdmasta 11 месяцев назад

      @@laminulams8723 you can sort largest to smallest with a locked pivot table?

    • @waqasmaqbool3356
      @waqasmaqbool3356 10 месяцев назад

      you can filter on pivot

  • @jessray721
    @jessray721 11 месяцев назад

    Why does my excel not have certain features such as "timeline" ?

  • @ajraol9032
    @ajraol9032 Год назад +2

    Do you think if investment bankers paid more attention to the content than to the presentation, it would save a lot of time ? 🤔 I mean yes, the format looks ugly but at least I don’t have to expect calls in midnight to correct the text alignments 😂

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

    👏🏻👏🏻💯

  • @DzunisaniChauke-zp1dv
    @DzunisaniChauke-zp1dv 5 месяцев назад

    Nah, he's good

  • @debasishsamal4646
    @debasishsamal4646 Год назад +1

    1st to comment 🤗

  • @punditgi
    @punditgi Год назад

    😊

  • @aymanalrumaihi
    @aymanalrumaihi 10 месяцев назад