12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables!

Поділитися
Вставка

КОМЕНТАРІ • 305

  • @tristangeoffroy9286
    @tristangeoffroy9286 Рік тому +61

    Despite decades of pivot table practice, you just taught me fews things (template formating) I always looked for, in a cristal clear manner. Very professional. Thank you very much.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Рік тому

      Great to hear!

    • @marcovirtual
      @marcovirtual Рік тому +3

      Yes! I work with Excel pretty much everyday, but Mynda's videos never fail to teach me new things. I love it!

    • @koitaki
      @koitaki 7 місяців тому +1

      What Tristan said...some really creative stuff here, thanks Myanda!

  • @Adam_K_W
    @Adam_K_W Рік тому +15

    This is one of the best videos you've done to date! Thank you so much for consolidating all of this into a simple, easy to navigate, useful set of tips and tricks! Pivot tables are so widely used these days, and even though they are sort of being replaced by Power BI, they still have their place. Awesome.

  • @goingvenus5603
    @goingvenus5603 9 місяців тому

    THANK YOU! I've been an Excel trainer for over 30 years and using PivotTables since they first came out. I never did learn that you can set PivotTable defaults in the Options dialog box. I"m ecstatic because it never made sense to me that we had to change the PT layout every. single. time. to a specific option. Amazing!

  • @RobinBond-j2l
    @RobinBond-j2l 9 місяців тому +1

    Oh and.... I have learned sooo much from watching your videos! In case you've had your doubts... your time has been well spent!!!

  • @krishna6296
    @krishna6296 8 місяців тому +5

    Perfect tutorial, straight to the point. Great work. Thank you!

  • @mohammedelsakally540
    @mohammedelsakally540 Рік тому +10

    Thank you Mynda for your always valuable contributions to enhance the Excel skills which we are always awaiting from you especially that you are representing the content of each video by an easy and professional way ... Thank you and we are supporting you ever ...

  • @abdelouahedelmaazouzi6102
    @abdelouahedelmaazouzi6102 Рік тому +2

    Perfect format! Once done you can present directly to the Management without any changes or modifications.

  • @markanthony7078
    @markanthony7078 Рік тому +1

    Thank you Mynda, you have made my project i had so easy to present ..thanks for all the free tutorials you do here - I don't take it lightly as a lot of work gone in to prepare for free....I still intend to enroll on one of your paid programs in coming weeks! Thank you and see you on the other side very soon. Stay blessed!!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Рік тому

      Wonderful to hear you've found my tutorials helpful 🙏😊 see you in a course someday where I can share even more.

  • @therealjeffg
    @therealjeffg Рік тому +2

    Awesome Mynda, gold nuggets everywhere in that one. Thank you.

  • @ivanbork4175
    @ivanbork4175 Рік тому +4

    Thank you Mynda, always very inspirational to see your tutorials, sometime almost lifechanging.
    In this case I have done something similar, and have created my own PivotTable styles, and then saved the workbook as templates .xltx, including introduction sheet and print layout for some sheets added head and footer, and links to a couple of lists holding essential number /- names for categories. All in all it saves time end ensure a consistent in the way the different jobs have

  • @SeaOfMadness
    @SeaOfMadness 9 місяців тому

    The tip of adding the space is genius - Can't believe I didn't think of that before!

  • @NancyMancarious
    @NancyMancarious Рік тому +1

    I now know that I've mastered the pivot tables when all of these tips are not new to me. Thank you - always helpful.

  • @silversolver7809
    @silversolver7809 Рік тому +2

    Excellent! I've used pivots 'forever' but still learned a couple of things :)

  • @kevinbush4300
    @kevinbush4300 Рік тому

    Brilliant… pivot tables play such a big part in my stuff, but they ARE ugly.
    This will solve that.
    I have to say, you and Leila have given me so much finesse in my workbooks.
    Thanks Mynda

  • @MuhammadIrfan-wr8zo
    @MuhammadIrfan-wr8zo Рік тому

    Pronounce extreme convex and sweet accent and perfection..
    Outstanding.

  • @TheTinaMarbury
    @TheTinaMarbury Рік тому +5

    You are the BEST excel teacher EVER!😁

  • @Koel0202
    @Koel0202 8 місяців тому

    This is genius! Thanks, Mynda for all the tricks!

  • @ChessmasterSunnyKow888
    @ChessmasterSunnyKow888 Рік тому +1

    Hi Mynda
    You are really the best.

  • @alexanderbaranov5418
    @alexanderbaranov5418 Рік тому

    Best video book about Excel on the UA-cam 👍

  • @NewYears1978
    @NewYears1978 8 місяців тому

    The number of times I have had a pivot table that I had to go and convert to just a normal data table and try to move over to the left the main field....
    I had no clue you could repeat the labels and also TAB format which does what I was doing manually already. Wow. Great video =D

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  8 місяців тому +1

      So pleased you can save some time with these techniques 😊

  • @dompedro14
    @dompedro14 Рік тому

    As always Mynda you provide excellent tutorials in a simple and easy way to understand. Thanks so much.

  • @sjdyt
    @sjdyt Рік тому

    I use pivot tables a lot but I still learned a couple of things here which I hadn’t really thought about before. I’ll be amending my defaults after I press post!

  • @billyjayamunga
    @billyjayamunga Рік тому

    Exactly what I was looking for. Brilliant as always. Thanks Mynda!

  • @shadrackawunyo7786
    @shadrackawunyo7786 Рік тому

    Very well showcased Mynda. I love the presentation

  • @warrennalty6599
    @warrennalty6599 6 місяців тому +1

    To change the headings, I press ctrl-h replace, type Sum of (no space after of) and leave replace with blank. This removes Sum of leaving leading space. Great if there are many headings.

  • @JJ_TheGreat
    @JJ_TheGreat Рік тому +1

    10:07 Oh, wow! I didn't even think about re-naming the "(blank)" to "" (nothing). I always went into the Pivot Table options in order to hide blanks.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Рік тому +1

      Typing over the blank in the cell is just a shortcut to editing how the PivotTable handles blanks in the Options dialog box.

  • @vishwanath1810
    @vishwanath1810 Рік тому

    Learnt so many new things despite using excel for years now!! Thanks again 🤝

  • @JJ_TheGreat
    @JJ_TheGreat Рік тому

    5:07 Wow! That is brilliant 👏!
    I never knew you could do that! 😀

  • @Pshor
    @Pshor 7 місяців тому

    You are indeed the best I have watched! Thank you

  • @brianxyz
    @brianxyz Рік тому

    The sorting tip at the beginning is amazing. Had no idea you could do that!

  • @HenricAndersen
    @HenricAndersen Рік тому

    I feel much like a pivot table master, but newertheless I learned a few new things. Thank you very much Mynda 🙏

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

    thats another level of pivot table knowledge..thanks a alot for sharing it to us

  • @geovanrocha2822
    @geovanrocha2822 Рік тому +1

    Hi Mynda, Thank you very much for sharing this. It would be nice if you make another video about pivot chart formatting tricks.
    I always struggle with them because they change format when I use slicers, for example.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Рік тому

      With Pivot Charts, you must clear all filters, then apply formatting. HTH.

  • @marcolevasquez
    @marcolevasquez 9 місяців тому

    Hy Mynda, great video. This was very helpful for me; saving a bunch of time. Thanks!

  • @arkai59
    @arkai59 Рік тому +2

    I already knew some of these tricks but it is still very impressive. You really are at the top of your game, Mynda, thanks for your great input with your channel 🙂

  • @vijayarjunwadkar
    @vijayarjunwadkar Рік тому

    Thank you Mynda for yet another practical and useful video for the most commonly used but often confused; Pivot Tables. I got to know many new things. Keep up the great work!

  • @chrism9037
    @chrism9037 Рік тому

    Awesome. Tons of useful stuff, thanks Mynda!

  • @ynotedaw6960
    @ynotedaw6960 Рік тому

    Thank you! I did not know that pivot tables could have custom formatting. This is very helpful.

  • @JJ_TheGreat
    @JJ_TheGreat Рік тому

    Also, thanks for showing how to configure the default Pivot Table layout. I didn't know about that, either.

  • @jawadahmadehssan6251
    @jawadahmadehssan6251 Рік тому

    Thank you Mynda. It was indeed useful

  • @MegaTrickykid
    @MegaTrickykid Рік тому

    Simply great! Thanks for this outstanding tutorial!

  • @FutureCommentary1
    @FutureCommentary1 Рік тому

    I had noted this video and woke up super early today to watch it. Everybody is all power pivot and pivot tables from data models today when really sometimes a regular old pivot table does the job. They look so ugly. I have been using Excel forever. I don't know why I never really explored the formatting options. I usually copy the data from the table and do the formatting elsewhere (smh at myself lol). Thanks for this vid.

  • @ahmedshalaby9343
    @ahmedshalaby9343 Рік тому

    Greetings from Egypt , great and very simple video thank you

  • @2bczar4u
    @2bczar4u Рік тому

    Wow, quite a few little tricks I did not know. Thank you once again!

  • @luisalonso3018
    @luisalonso3018 Рік тому +1

    Excellent video, thank you! Suggestion: can you do a video teaching us tips on how to format the slicers for pivot tables. That would be great! Thank you once again.

  • @karennguyen7083
    @karennguyen7083 Рік тому

    Great video as usual. Thank u so much, Mynda 🤩

  • @kudifilipe9875
    @kudifilipe9875 Рік тому

    Thanks 4 sharing, and level up my Excel skills...

  • @TheIvalen
    @TheIvalen Рік тому

    Pivot tables are my life. I'll take any of your design tips any day! I usually find myself using the pivot table for data analysis and then copying pasting the data to a static table so I can make it pretty/ready for consumption. Ok, I will try from now on just to use the Pivot table only.
    The reason for the static table is I often have to insert rows of 'dates' with no additional data to provide a continuous timeline and the Pivot table doesn't let me do that (at least I don't think it can) without modifying the raw input data.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Рік тому

      Glad this video was helpful. This tutorial explains how to make PivotTables display missing dates: www.myonlinetraininghub.com/display-missing-dates-in-excel-pivottables

  • @vanbap5638
    @vanbap5638 Рік тому

    Great. Thank you very much!
    I applied it to my report.

  • @Earth-360
    @Earth-360 Рік тому +1

    You are a gem

  • @IsAllAboutHealth
    @IsAllAboutHealth Рік тому

    Thank you! Love your videos. Great explanation with great tips!

  • @ricardomantovaniassis
    @ricardomantovaniassis Рік тому

    Thank you so much, Mynda. 🥰🥰🙌

  • @txreal2
    @txreal2 Рік тому

    Forgot all about Default PivotTable Layout. Thanks!

  • @TheAndresOpeth
    @TheAndresOpeth 9 місяців тому

    AMAZING!
    Thanks a lot for everything!🤗

  • @mogarrett3045
    @mogarrett3045 Рік тому

    excellent tips as always...thank you

  • @jeannekoh9544
    @jeannekoh9544 Рік тому

    Just subscribed! Thanks for these tips!😊

  • @tomascoleto
    @tomascoleto Рік тому

    So cool and useful 👌. Lots of thanks 😊

  • @mehdishahidian2711
    @mehdishahidian2711 Рік тому

    You are the best, Thank you!

  • @rajeshmajumdar4999
    @rajeshmajumdar4999 Рік тому

    Superb Very Useful. Thank You so much!

  • @Everyonelovesyou
    @Everyonelovesyou 9 місяців тому

    Very useful video for all excel users

  • @internet_wanderer8316
    @internet_wanderer8316 Рік тому

    Thank you so much. Very useful info

  • @ashrafkamal2011
    @ashrafkamal2011 Рік тому +2

    please we need more videos related to financial statements and finance trick....

  • @djl8710
    @djl8710 Рік тому

    Thanks for doing this!

  • @StanEby1
    @StanEby1 Рік тому

    Wow! Thank you, Your Royal Awesomeness!

  • @raihansafa5514
    @raihansafa5514 5 місяців тому

    Thank you so much, really helpful

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

    1:03 ---> Blown my mind 🤯

  • @AmjadKhan-ng2xk
    @AmjadKhan-ng2xk 10 місяців тому

    good job, nice way of explaination

  • @danielhartjes2479
    @danielhartjes2479 Рік тому

    Very nice video. Thank you!

  • @Kursatural
    @Kursatural Рік тому

    Thank you for sharing!

  • @aicx40
    @aicx40 11 місяців тому

    Awesome. Thanks for sharing.

  • @MrJucesar2005
    @MrJucesar2005 7 місяців тому

    This is super helpful.

  • @mamtabhat5221
    @mamtabhat5221 9 місяців тому

    You are the best...Many many thanks

  • @BlackCowOppa
    @BlackCowOppa Рік тому

    Very useful, thanks! 😊

  • @saidechchababe9938
    @saidechchababe9938 Рік тому

    Thanks a lot, Very useful

  • @SybedeJong
    @SybedeJong Рік тому

    Hi Mynda, Thanks for the great video. I was wondering why you mentioned having all row labels on for lookup purposes, while you can also use the getpivotdata function. I see there may be situations in which one is preferred over the other. Maybe a nice one for another video some day?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Рік тому

      Thank you! GETPIVOTDATA can perform a lookup of sorts, but it's not as user friendly as XLOOKUP and for that you need row labels repeated. I love GETPIVOTDATA too. I did a video on it here: ua-cam.com/video/LDf_ORnSCu4/v-deo.html

  • @whazee
    @whazee Рік тому

    I had no idea that you could just sort the pivot table by overtyping the name of the row! (Mind blown!)
    Hiding (blank) with a space is also a handy tip!

  • @hazemali382
    @hazemali382 Рік тому

    Lovely Mynda ♥

  • @AZGATOR2002
    @AZGATOR2002 Рік тому

    Agreed, the content is of high value. But do you produce your own videos? A reall well polished product, audio, transitions, all of it. Thank you!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Рік тому +1

      Thanks so much! Yes, I record, edit and produce my own videos 😊

  • @eleburciaga6769
    @eleburciaga6769 Рік тому

    Hello, can you do a center of gravity tutorial to select an optimal location for an office?

  • @robparker1625
    @robparker1625 Рік тому

    Very useful 👍

  • @miqueldespuig
    @miqueldespuig Рік тому +1

    It would be sooooo useful to be able to save a Pivot Table Style to be used on all excel files. I usually populate the PnL from a PowerBI Dataset and recreating the style every time is painful

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Рік тому +2

      You can save the style in your default workbook and it will be there in all new files: www.myonlinetraininghub.com/customize-default-excel-workbook

  • @ConnerZee
    @ConnerZee 9 місяців тому

    I thought I i knew all there was about pivot tables and im no novice haha! Im definitely going to implement a few if these tips ASAP

  • @GothicPrincezz
    @GothicPrincezz Рік тому

    Great vid!

  • @ARTHURYUNZAL
    @ARTHURYUNZAL 7 місяців тому

    thank you, much appreciated :)

  • @gabytobin2695
    @gabytobin2695 Рік тому

    Thank you!

  • @datareggibi
    @datareggibi Рік тому

    Amazing!

  • @budiwijoyo8388
    @budiwijoyo8388 Рік тому

    This video are nailed, but i wondering how you made that financial statement template ?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Рік тому

      Thanks so much. See this video for creating the P&L: ua-cam.com/video/5kUQSxBVlZ8/v-deo.html

  • @surkewrasoul4711
    @surkewrasoul4711 Рік тому +1

    Thanks luv , Gotta get mi blauuwwdy job first.

  • @cogiangxcel693
    @cogiangxcel693 7 місяців тому

    thank you, very hepful

  • @CideeStudio
    @CideeStudio 11 місяців тому

    thanks for the sharing..

  • @the_legend3185
    @the_legend3185 11 місяців тому

    Great video, if you were to add another field under your accounts and add a blank rows it adds rows between each item. Do you know of any way around this?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  11 місяців тому

      Glad you liked it. Blank rows are pretty limited in options, they simply get inserted after each item based on the last item in the row labels area.

  • @tanweerabbasabbas649
    @tanweerabbasabbas649 11 місяців тому

    mynda. you are cool!!

  • @Mark-Bench
    @Mark-Bench 7 місяців тому +1

    one addition.
    The only way to transfer a style from one excel file to another is by copying a pivot table with it's style into the other one and then delete it. the style formatting will stay and is now available in the sheet. also works for slicer styles created for Pivot tables.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  7 місяців тому +1

      I assume you mean PivotTable styles, in which case, great tip. Thanks for sharing.

    • @Mark-Bench
      @Mark-Bench 7 місяців тому +1

      @@MyOnlineTrainingHub I just checked, doesn't work anymore, only works with slicer style - disappointed now 😞

  • @rexbk
    @rexbk 5 місяців тому

    Thank you, Minda.
    Q: Do you have a video that explain how to do pivot table to show petty cash in hand on any selected date?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  5 місяців тому

      I don't have anything that specifically covers that scenario, sorry.

    • @rexbk
      @rexbk 5 місяців тому

      @@MyOnlineTrainingHub Thanks

  • @balasooriyamahesh
    @balasooriyamahesh Рік тому

    Thank you ❤

  • @steven.h0629
    @steven.h0629 Рік тому

    ❤Yes.. useful and been there 👍😎✊

  • @峰王
    @峰王 Рік тому

    thanks you!

  • @AlbertoSaravia
    @AlbertoSaravia Рік тому

    Thank you :)

  • @GiteshBajaj
    @GiteshBajaj Рік тому

    Helped!

  • @amralsabban3533
    @amralsabban3533 Рік тому

    Thanks