7 Clever Excel Custom Formatting Tricks (Advanced)

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

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

  • @sansnomnull2799
    @sansnomnull2799 3 ปีที่แล้ว +50

    Finally someone clearly explained the custom formatting, not just how but also why. Thank you!

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว +3

      Thanks for commenting... Glad you found the video useful :)

    • @keithau8159
      @keithau8159 3 ปีที่แล้ว

      Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot @t wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at @t ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

    • @keithau8159
      @keithau8159 3 ปีที่แล้ว

      Hello,my dearest Indian Friend,how are you.Happy new year 2021 to you and to your family."Tai chi?Num ma stair?Kee sai ho?T-Cool.Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek du.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he,kai ah mei two mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei Hindi,Hindo,Nepalese art dee hei.Mei India kam kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Eight lai jar dar kam ho dar hei,kar jar kee,saw jar dar hung bo ho tek kee hung.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it ,mei ban lee.So kar lee ah.Ug ly hip see dai mei link it."

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

    One of the few people has the clear and awesome way to explain and deliver the information & knowledge!
    Thank you sir!

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

    you are one of two youtubers for whom I have hit the bell icon. Bro you are king of formatting

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

    This is an incredible video.
    This really helped me in work as an accountant I wanted my excel workings to match exactly the figures in the PDF without effecting others.
    Thank you so much

  • @supplychainsys
    @supplychainsys ปีที่แล้ว +3

    I have been using custom formatting for years but your explanation was the best explanation I have seen on the subject. Provides insights on how to combine multiple formatting techniques. Great stuff! Thanks

  • @trumpexcel
    @trumpexcel  3 ปีที่แล้ว +8

    If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
    Also, I have made all of my Excel courses available for free. You can check these out using the below links:
    ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
    ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
    ✅ Free VBA course - bit.ly/excel-vba-course
    ✅ Free Power Query Course - bit.ly/power-query-course

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

      You have been an amazing trainer❤️🙏 #respect

    • @sushilnoatia6076
      @sushilnoatia6076 3 ปีที่แล้ว

      @@rachitthakur3779 v

    • @karthikiyer9502
      @karthikiyer9502 3 ปีที่แล้ว

      Hi sumit. Needless to say, you are doing a great job. Keep it up. Your videos are very useful. Presentation is crisp and clear.
      I calculate more in excel like many of us. Just wondering if there is any option that would pop up instead of save your file when we are done calculation in that file. Pop up like, " Did you cross check your calculations" reminding to verify the sheet once again and then close the sheet. Kindly make a video or let me know if there is way out like that.
      Thank you
      Karthik.

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

    Finally I find a good thing which is truly helpful for us

  • @vramarathnam
    @vramarathnam 2 หลายเดือนก่อน

    useful areas covered. excellent esplanation. thank you

  • @quduslawal2591
    @quduslawal2591 3 ปีที่แล้ว +4

    Sumit Bansal is an Excel Sage. Hats off

    • @sanjaybetme
      @sanjaybetme 3 ปีที่แล้ว

      Yes indeed 👍🏻👍🏻👍🏻🔥🔥🔥

  • @UniversalEngineer
    @UniversalEngineer 5 หลายเดือนก่อน

    This is FANTASTIC! Clearly communicated and demonstrated. So helpful. Thank you! 👏👏👏

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

    Very well presented! This is the best Custom Number formatting explanation I have seen. Thank you very much, Sumit.

  • @muhammada.muhammad6287
    @muhammada.muhammad6287 3 หลายเดือนก่อน +1

    extremely great, finally I understood it clearly

    • @trumpexcel
      @trumpexcel  3 หลายเดือนก่อน

      Glad the video helped 🙂

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

    Your videos best than the short videos I watch. You have explained the reason behind why we write this or that . Thank u & I subscribed and liked the video.

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

    Great explained with concept. Watched so many videos about custom cell formatting but the way you explained is amazing.

  • @srmchinni3
    @srmchinni3 3 ปีที่แล้ว

    Really, your work is awesome and I see that all your videos are with extraordinary content. I will surely buy a coffee for you, soon.

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

    Really great. Thank you very much. Keep sharing such insights. Many prays from Pakistan.

  • @thiyakup7333
    @thiyakup7333 3 ปีที่แล้ว

    Very Nice teaching, it's very useful

  • @h33t18
    @h33t18 3 ปีที่แล้ว

    Thanks for the tips!! I needed to hide non numerical data and this will help.
    No matter what I do my cells remove the negative sign - ??

  • @MostofaKamal-ll5dx
    @MostofaKamal-ll5dx 3 ปีที่แล้ว

    It's so much helpful indeed. Thank you very much.

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

    he knows perfectly what he is doing, a real guru in excel.. awesome presentation very brief clear and concise

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for commenting Penny... Glad you found the video useful!

    • @keithau8159
      @keithau8159 3 ปีที่แล้ว

      Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple and no wonder draw tourists come to Holly Khilasa temple to vist at all,as long as modification of all kinds of hotels,motel facilities of all classes,definitely make big money globally at all,particularly from Europe,North America,Japan,Korea@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become flourish in different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century,if not famous geologist,cosmology and archeologist not interested to visit the greatest nation of India.Last century 80-2 thousand ,movies as Fly and Lara Croft: Tomb Raider still have good memory in 21th@@@@@

  • @smitapatwardhan975
    @smitapatwardhan975 3 ปีที่แล้ว

    Your videos are very interesting and to the point

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

    beautifully explained

  • @raziajeena9861
    @raziajeena9861 3 ปีที่แล้ว

    been using excel for a while and learned lots. thanks

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Glad you found the video useful!

  • @vijaykishan8649
    @vijaykishan8649 3 ปีที่แล้ว

    Your explanation is superb Sumit. I always appreciate your work. Thank You.🙏🙏🙏🙏🙏

  • @rashidfaridkhan2664
    @rashidfaridkhan2664 3 ปีที่แล้ว

    Simple & Excellent way..Thanks Sumit

  • @ramamohanpathapati7694
    @ramamohanpathapati7694 3 ปีที่แล้ว

    Thank you for clear explanation

  • @AkachukwuUdechukwu
    @AkachukwuUdechukwu 8 หลายเดือนก่อน +1

    Best explanation on this subject

    • @trumpexcel
      @trumpexcel  8 หลายเดือนก่อน

      Thanks 😊 Glad you found the video helpful!

  • @excelworx8712
    @excelworx8712 3 ปีที่แล้ว

    Very informative. Knew the hiding using ;;; but learning number formatting for the first time

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for commenting... Glad you found the video useful!

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

    I have been using Excel since 1993 & even learned a couple of things from this video.

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

      Excel is such a well developed tool and I keep learning new things about it every now and then... Glad you found the video useful!

    • @keithau8159
      @keithau8159 3 ปีที่แล้ว

      Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot @t wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at @t ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

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

    excellently explained, thank you

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

    thanks buddy .. last one was really good

  • @Lalit_4166
    @Lalit_4166 3 ปีที่แล้ว

    Wonderfully explained

  • @AlejandroMora29
    @AlejandroMora29 3 ปีที่แล้ว

    Sumit, you are a wizard!

  • @askulasaatwik8thc644
    @askulasaatwik8thc644 3 ปีที่แล้ว

    Thank you Awesome Excel tricks!

  • @pprathamesh
    @pprathamesh 3 ปีที่แล้ว

    Super like ALL your videos. Your difference lies in the innovative application of the same function for which there are 100 other videos on how to use it.

  • @sanjaysrivastava9671
    @sanjaysrivastava9671 3 ปีที่แล้ว +5

    Your deliberation and presentation are just excellent. Just by watching your videos, I have been able to learn it to a respectable level. It may be noted that I am from mini drafter and calculator era. Hats off

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for the kind words Sanjay... Glad you found the video useful!

  • @kprakashsha
    @kprakashsha 3 ปีที่แล้ว

    Its explained very very very excellent

  • @zohurulislam7628
    @zohurulislam7628 3 ปีที่แล้ว

    Very useful,
    Very advance.
    Thank you sir,
    Thank you so much.

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for commenting... Glad you found the video useful!

  • @jawaidiqbal945
    @jawaidiqbal945 3 ปีที่แล้ว

    Nice way to make understand
    Well done

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

    very nicely explained,Good job

  • @w.a.schull1357
    @w.a.schull1357 3 ปีที่แล้ว

    Excellent explanations of these very useful techniques.

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Glad you found the video useful!

  • @stanlomas
    @stanlomas 3 ปีที่แล้ว

    Very useful. Thank you. Will be using them today.

  • @Jack-er2uj
    @Jack-er2uj 2 ปีที่แล้ว

    Thank you very much for sharing your knowledge.

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

    Very well explained! Thank you so much.

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

    Finally i found the excel king

  • @musajuma7374
    @musajuma7374 3 ปีที่แล้ว

    Simple and Excellent way to teach
    Thanks for your efforts you did for us,

  • @jbcosta51
    @jbcosta51 3 ปีที่แล้ว

    Very good explanation.

  • @FsoOmar
    @FsoOmar 3 ปีที่แล้ว

    I've seen this custom format (hide) ;;; but kept forgetting it after months of not using it.
    Your explanation at ~ 3:30 will make it stick to my head forever. Thanks a lot! 🙏

  • @alialbayati9368
    @alialbayati9368 3 ปีที่แล้ว

    Thanks Sumit for making this video.

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

      Glad you found the video useful!

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

    Thanks for giving us a new and important knowledge!!! You have no idea how much that’s important to me!!!

  • @swathic1621
    @swathic1621 3 ปีที่แล้ว

    Wisely explained ..worth watching bro.. keep it up👍

  • @vinaykhadilkar
    @vinaykhadilkar 3 ปีที่แล้ว

    I liked the video. Very well explained and to the point.

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

    Was just finishing a profit margin review for 2020. These formats really made an impressive report. Thanks for your hard work.

    • @keithau8159
      @keithau8159 3 ปีที่แล้ว

      Hello,my dearest Indian Friend,how are you.Happy new year 2021 to you and to your family."Tai chi?Num ma stair?Kee sai ho?T-Cool.Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek du.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he,kai ah mei two mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei Hindi,Hindo,Nepalese art dee hei.Mei India kam kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Eight lai jar dar kam ho dar hei,kar jar kee,saw jar dar hung bo ho tek kee hung.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it ,mei ban lee.So kar lee ah.Ug ly hip see dai mei link it."

  • @ashokkhegde
    @ashokkhegde 3 ปีที่แล้ว

    Unbelievable Sir. Awesome

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for commenting Ashok... Glad you found the video useful!

  • @shahzadsami5613
    @shahzadsami5613 3 ปีที่แล้ว

    100% having a worth to watch, High Quality Information

  • @uolaod
    @uolaod 3 ปีที่แล้ว

    Really it so an amazing explanation even though if you done a mistake during the tutorial still we learn. Mush thankful

  • @dhapumdhap
    @dhapumdhap 3 ปีที่แล้ว

    Simply Too Good and Simple! 👌👏👏👏

  • @ramk1969
    @ramk1969 3 ปีที่แล้ว

    excellent tips sir...Thanks....

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

    good video with best knowledge

  • @mohanv3614
    @mohanv3614 3 ปีที่แล้ว

    Very well explained with reasons

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for commenting Mohan... Glad you found the video useful!

  • @nitinparmar5117
    @nitinparmar5117 3 ปีที่แล้ว

    Your all videos are very useful for us thanks for such an amazing videos.

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for commenting Nitin... Glad you found the video useful!

  • @wayneedmondson1065
    @wayneedmondson1065 3 ปีที่แล้ว

    Hi Sumit. Excellent custom formatting tips! Thanks for sharing :)) Thumbs up!!

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

    Oh, you're simply amazing! Before lunch I watched another of your videos and it was so great and now this one? I've been doing things like this the hard way forever! You're a terrific instructor; thanks!

    • @keithau8159
      @keithau8159 3 ปีที่แล้ว

      Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot @t wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at @t ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

  • @FsoOmar
    @FsoOmar 3 ปีที่แล้ว

    Thank you for this awesomely usueful vid.
    Please make more vids of custom formatting tricks.

  • @keishrich
    @keishrich 3 ปีที่แล้ว

    Helpful video. Thank you.

  • @jiajiaphotography
    @jiajiaphotography 3 ปีที่แล้ว

    Very clearly explained and easy to apply to daily work

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Glad you found the video useful!

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

    Amazing video sir,bt i have a question when we use square brackets in custom formatting?

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

    thank you so much for this tricks !!! it's really awesome !!! however i am seeking some more custom format ( need accounting format but except not make all the number double digit if not available . ex. if number are like this
    100 - make 100
    1000- make 1,000
    10.50 make 10.50
    0 make -

  • @vijaykishan8649
    @vijaykishan8649 3 ปีที่แล้ว

    Good Explanation. I really appreciate all your videos Sumit. Keep up the good work for us. Thank You.

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for commenting Vijay... Glad you found the video useful!

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

    So glad for this. I had problem with "Show numbers in Millions or Billions" did not work...

  • @JUNAIDKHAN-m6z
    @JUNAIDKHAN-m6z 9 หลายเดือนก่อน +1

    Great way to present. Thanks a lot. You're deserve to subscribe. I subscribed.

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

      Thanks for the sub! Glad you found the video helpful 🙂

  • @rabdu2002
    @rabdu2002 3 ปีที่แล้ว

    Hi Mr. Sumit many thanks for the wonderful video tutorial, please from where you get the check mark & how you replaced in format cell. please reply

  • @rashiedasuliman4138
    @rashiedasuliman4138 3 ปีที่แล้ว

    Thank you for tutorial, it is very helpful. Always appreciate your tutorials.

  • @mdks1012
    @mdks1012 3 ปีที่แล้ว

    Awesome!
    Very informative. Learnt a lot. Thanks so much.

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Glad you found the video useful!

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

    WoW new trick...
    Thank You
    🙏🏽

  • @trendingpublic1069
    @trendingpublic1069 3 ปีที่แล้ว

    Thanks for the information sir ❤️

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

    Damn, Scott's score is perfect

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

    Wow! That's a lots of unknown tricks and techniques. Thanks for sharing @TrumpExcel

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

    thanks for clear explaination

    • @trumpexcel
      @trumpexcel  8 หลายเดือนก่อน +1

      Glad you found the video helpful 🙂

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

    So useful, thank u so much!

  • @tlim1945
    @tlim1945 3 ปีที่แล้ว

    Very good tips. Delivered clearly and concisely. Easy to follow. Very few videos are like that. Your videos are one of the best.

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

    Hi, Great Video.
    My use-case is changing currency. Is there a way to add name manager in the custom format ? or link it to a specific cell ? Thanks

  • @sravankumar1767
    @sravankumar1767 3 ปีที่แล้ว

    Nice Explanation. Bro

  • @saifdogar8376
    @saifdogar8376 3 ปีที่แล้ว

    Good one. I even i knew m9st of them but new learning by very easy and descriptive methods

  • @دراساتاجتماعية-ز9ل
    @دراساتاجتماعية-ز9ل 3 ปีที่แล้ว

    Always with you new and useful

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Glad you found the video useful!

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

    Great, very educational

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

    Some powerful stuff. Thank you very much!

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Glad you found the video useful!

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

    Can you please how to code general formatting. This vedio is helpful but the basics of how to code the same would be great.

  • @monirhossain9850
    @monirhossain9850 3 ปีที่แล้ว

    Thank you for sharing amazing tips in Excel.

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Glad you found the video useful!

  • @rajivjain8560
    @rajivjain8560 3 ปีที่แล้ว

    great video, learned a lot, 2 Queries a) if i h=want to show number in thousand & lacs instead of millions n billions how should i do, because for milli u used 2 commas Query 2: is there anything by whcih u can check mark in few cells as n when i complet, because eveerytime changing of format is not possibile

  • @jeaniminerales5578
    @jeaniminerales5578 3 ปีที่แล้ว

    VERY USEFUL SIR

  • @IvanCortinas_ES
    @IvanCortinas_ES 3 ปีที่แล้ว

    Excellent explanation. The magic is back. Thank you very much for these tutorials Sumit!

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for commenting Iván... Glad you found the video useful :)

  • @teoxengineer
    @teoxengineer 3 ปีที่แล้ว

    Good information. Thank you, Sumit.
    I also want to see about wildcard's techniques. Can you prepare it?

    • @teoxengineer
      @teoxengineer 3 ปีที่แล้ว

      @@keithau8159 I’m from Turkey! 😄

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      I created a video about it. Here is the link - th-cam.com/video/cUGOSBm-Xks/w-d-xo.html

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

    Amazing work!

  • @broto8
    @broto8 3 ปีที่แล้ว

    Wow I am quite impressed ... this will be such a valuable info for me in the future!

    • @trumpexcel
      @trumpexcel  3 ปีที่แล้ว

      Thanks for commenting Subroto... Glad you found the video useful!

  • @subhashthangadipally4974
    @subhashthangadipally4974 3 ปีที่แล้ว

    After Rakesh Yadav bhayya videos... really helpful inputs thanks I am new subscriber

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

      Thanks for commenting Subhash... Glad you found the video useful!

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

    This is Gold.

  • @techgalaxy100
    @techgalaxy100 3 หลายเดือนก่อน

    Excellent!! Thank you so much. I would like to know what is "#" symbol used for ? Also, if I want to add a string at the end of a number, how do I do that ? I have done @" text" This works but gives me error which I have to ignore. Thanks

  • @vikaasb2016
    @vikaasb2016 3 ปีที่แล้ว

    Simply sublime !!

  • @ahmedabdelrahman829
    @ahmedabdelrahman829 3 ปีที่แล้ว

    Keep going, it's helpful