7 Clever Excel Custom Formatting Tricks (Advanced)

Sdílet
Vložit
  • čas přidán 6. 09. 2024

Komentáře • 311

  • @sansnomnull2799
    @sansnomnull2799 Před 3 lety +50

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

    • @trumpexcel
      @trumpexcel  Před 3 lety +3

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

    • @keithau8159
      @keithau8159 Před 3 lety

      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 Před 3 lety

      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 Před 11 měsíci +1

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

  • @supplychainsys
    @supplychainsys Před rokem +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

  • @quduslawal2591
    @quduslawal2591 Před 3 lety +4

    Sumit Bansal is an Excel Sage. Hats off

    • @sanjaybetme
      @sanjaybetme Před 3 lety

      Yes indeed 👍🏻👍🏻👍🏻🔥🔥🔥

  • @ravindrakunwar4847
    @ravindrakunwar4847 Před 3 lety +1

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

  • @muhammada.muhammad6287
    @muhammada.muhammad6287 Před 19 dny +1

    extremely great, finally I understood it clearly

  • @ianodonoghue7299
    @ianodonoghue7299 Před 10 měsíci

    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

  • @billminckler6550
    @billminckler6550 Před 3 měsíci

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

  • @jdsingh8189
    @jdsingh8189 Před 3 lety +1

    beautifully explained

  • @sanjaysrivastava9671
    @sanjaysrivastava9671 Před 3 lety +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  Před 3 lety

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

  • @h33t18
    @h33t18 Před 2 lety

    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 - ??

  • @phey6304
    @phey6304 Před 3 lety +1

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

    • @trumpexcel
      @trumpexcel  Před 3 lety

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

    • @keithau8159
      @keithau8159 Před 3 lety

      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@@@@@

  • @ramamohanpathapati7694

    Thank you for clear explanation

  • @GosCee
    @GosCee Před rokem

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

  • @Jack-er2uj
    @Jack-er2uj Před 2 lety

    Thank you very much for sharing your knowledge.

  • @motalibcomputer6278
    @motalibcomputer6278 Před 2 lety +1

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

  • @HarpreetSingh1991
    @HarpreetSingh1991 Před 2 lety

    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.

  • @thiyakup7333
    @thiyakup7333 Před 3 lety

    Very Nice teaching, it's very useful

  • @luistavvares
    @luistavvares Před 3 lety +2

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

  • @Lalit_4166
    @Lalit_4166 Před 3 lety

    Wonderfully explained

  • @kprakashsha
    @kprakashsha Před 3 lety

    Its explained very very very excellent

  • @dontown1531
    @dontown1531 Před 3 lety +1

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

    • @trumpexcel
      @trumpexcel  Před 3 lety +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 Před 3 lety

      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

    excellently explained, thank you

  • @deepaky129
    @deepaky129 Před rokem

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

  • @smitapatwardhan975
    @smitapatwardhan975 Před 3 lety

    Your videos are very interesting and to the point

  • @excelworx8712
    @excelworx8712 Před 3 lety

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

    • @trumpexcel
      @trumpexcel  Před 3 lety

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

  • @user-hy7vu6gc5n
    @user-hy7vu6gc5n Před 5 měsíci +1

    Best explanation on this subject

    • @trumpexcel
      @trumpexcel  Před 5 měsíci

      Thanks 😊 Glad you found the video helpful!

  • @xyclos
    @xyclos Před rokem

    Very well explained. Thanks a lot!!

  • @jbcosta51
    @jbcosta51 Před 3 lety

    Very good explanation.

  • @adnanali3971
    @adnanali3971 Před 2 lety

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

  • @srmchinni3
    @srmchinni3 Před 2 lety

    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.

  • @pathakprathamesh
    @pathakprathamesh Před 3 lety

    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.

  • @SndfOmar
    @SndfOmar Před 3 lety

    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! 🙏

  • @askulasaatwik8thc644
    @askulasaatwik8thc644 Před 3 lety

    Thank you Awesome Excel tricks!

  • @vijaykishan8649
    @vijaykishan8649 Před 3 lety

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

  • @ethiohelptube794
    @ethiohelptube794 Před 3 lety +1

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

  • @mayur7673
    @mayur7673 Před rokem +1

    thanks buddy .. last one was really good

  • @shibilsnoopy3973
    @shibilsnoopy3973 Před 3 lety +2

    Finally i found the excel king

  • @jawaidiqbal945
    @jawaidiqbal945 Před 2 lety

    Nice way to make understand
    Well done

  • @ramk1969
    @ramk1969 Před 3 lety

    excellent tips sir...Thanks....

  • @jarna555
    @jarna555 Před 2 lety

    very nicely explained,Good job

  • @musajuma7374
    @musajuma7374 Před 3 lety

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

  • @jennydrumm7223
    @jennydrumm7223 Před 3 lety +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 Před 3 lety

      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@@@@@

  • @gvinodnair
    @gvinodnair Před 3 lety +1

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

  • @jamesthomas8249
    @jamesthomas8249 Před 3 lety +1

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

    • @keithau8159
      @keithau8159 Před 3 lety

      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."

  • @BijendraSah4u
    @BijendraSah4u Před rokem

    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 -

  • @jagadevipatil7717
    @jagadevipatil7717 Před 3 lety +1

    For custom formatting I wanted to use conditional formatting icons.i.e Inside a circle tick mark,cross,and exclamation.

  • @zohurulislam7628
    @zohurulislam7628 Před 3 lety

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

    • @trumpexcel
      @trumpexcel  Před 3 lety

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

  • @jeffreydohl6036
    @jeffreydohl6036 Před 3 lety

    I find myself trying to learn excel. But, I'm having a hard time figuring out how to do a line chart graph for working up loads for my rifles.
    It would have Feet Per Second on left side and powder weight in grains on the bottom.
    FPS whatever number you give them.
    3020
    2950
    2900
    2850
    2800 and so on.
    Powder weight. 76.0, 75.8, 75.6, 75.4 and so on.
    Then it would plot a graph whatever the speed is to the grains would be a dot. Then a line starting at lowest FPS mark to each dot across the powder charge.
    Thanks for your help.
    Jeffrey O. Dohl

  • @techgalaxy100
    @techgalaxy100 Před 12 dny

    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

  • @mohanv3614
    @mohanv3614 Před 3 lety

    Very well explained with reasons

    • @trumpexcel
      @trumpexcel  Před 3 lety

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

  • @debopomsaha8694
    @debopomsaha8694 Před 6 měsíci

    thanks for clear explaination

    • @trumpexcel
      @trumpexcel  Před 5 měsíci +1

      Glad you found the video helpful 🙂

  • @ashokkhegde
    @ashokkhegde Před 3 lety

    Unbelievable Sir. Awesome

    • @trumpexcel
      @trumpexcel  Před 3 lety

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

  • @raziajeena9861
    @raziajeena9861 Před 3 lety

    been using excel for a while and learned lots. thanks

  • @rashidfaridkhan2664
    @rashidfaridkhan2664 Před 2 lety

    Simple & Excellent way..Thanks Sumit

  • @venkatraj5491
    @venkatraj5491 Před rokem +1

    good video with best knowledge

  • @rajivjain8560
    @rajivjain8560 Před 3 lety

    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 Před 3 lety

    VERY USEFUL SIR

  • @atulbharti7880
    @atulbharti7880 Před 2 lety

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

  • @kamalpreetsingh7781
    @kamalpreetsingh7781 Před rokem

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

  • @pratikbante2711
    @pratikbante2711 Před 2 lety

    Thank you Sirji 🙏😊

  • @keishrich
    @keishrich Před 3 lety

    Helpful video. Thank you.

  • @mail2vj574
    @mail2vj574 Před 3 lety +1

    This is Gold.

  • @uolaod
    @uolaod Před 3 lety

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

  • @trendingpublic1069
    @trendingpublic1069 Před 2 lety

    Thanks for the information sir ❤️

  • @w.a.schull1357
    @w.a.schull1357 Před 3 lety

    Excellent explanations of these very useful techniques.

  • @stanlomas
    @stanlomas Před 3 lety

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

  • @Froilan355
    @Froilan355 Před rokem

    Great, very educational

  • @bluesage1528
    @bluesage1528 Před 3 lety

    Very helpful, thank you

  • @AlejandroMora29
    @AlejandroMora29 Před 3 lety

    Sumit, you are a wizard!

  • @tlim1945
    @tlim1945 Před 3 lety

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

  • @MostofaKamal-ll5dx
    @MostofaKamal-ll5dx Před 3 lety

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

  • @vivekmusafir4492
    @vivekmusafir4492 Před 3 lety +1

    Thank you...I want to show figures in Crores....what I mean is...If value is 2,00,00,000..excel should show 2 CR. Can you please help...

  • @swathic1621
    @swathic1621 Před 3 lety

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

  • @brianb4642
    @brianb4642 Před měsícem

    This was great, and very useful. However, I'm trying to show a value in a header row of (for example) L20 to indicate the Last 20 periods. I want to be able to enter 20 into the cell and I want excel to use that number ot calculate. I want to see "L20" in that cell, but I want excel to see 20. You showed me how to get text in front of text, but not how to get it ahead of a numeric value. Wondering if you could tell me how to do that?

  • @user-kd4rq4mr7u
    @user-kd4rq4mr7u Před 6 měsíci +1

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

    • @trumpexcel
      @trumpexcel  Před 6 měsíci

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

  • @alfredoas9635
    @alfredoas9635 Před 2 lety

    WoW new trick...
    Thank You
    🙏🏽

  • @sravankumar1767
    @sravankumar1767 Před 3 lety

    Nice Explanation. Bro

  • @rabdu2002
    @rabdu2002 Před 3 lety

    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

  • @marynelrocero8092
    @marynelrocero8092 Před rokem

    So useful, thank u so much!

  • @salmaalaa6158
    @salmaalaa6158 Před 3 lety

    hello Mr. trump in my little opinin .if you focus in English beside excel .your excellent video will be number 1 .thank you my deer
    teacher

  • @vinaykhadilkar
    @vinaykhadilkar Před 3 lety

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

  • @israelaguilera9613
    @israelaguilera9613 Před 2 lety

    Amazing work!

  • @rashiedasuliman4138
    @rashiedasuliman4138 Před 3 lety

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

  • @SndfOmar
    @SndfOmar Před 3 lety

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

  • @vijaykishan8649
    @vijaykishan8649 Před 3 lety

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

    • @trumpexcel
      @trumpexcel  Před 3 lety

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

  • @venkatcool5873
    @venkatcool5873 Před 3 lety

    Useful thanks a lot 🙏🙏🙏🙏🙏🙏🙏

  • @saifdogar8376
    @saifdogar8376 Před 3 lety

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

  • @hubertg7100
    @hubertg7100 Před 2 lety

    Great Tutorial!

  • @trumpexcel
    @trumpexcel  Před 3 lety +7

    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 Před 3 lety +2

      You have been an amazing trainer❤️🙏 #respect

    • @sushilnoatia6076
      @sushilnoatia6076 Před 3 lety

      @@rachitthakur3779 v

    • @karthikiyer9502
      @karthikiyer9502 Před 3 lety

      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.

  • @SunilKumar-pj5gz
    @SunilKumar-pj5gz Před 2 lety

    Great Sir 👌

  • @ashishpalsingh
    @ashishpalsingh Před 3 lety

    Very powerful 👍

  • @shahzadsami5613
    @shahzadsami5613 Před 3 lety

    100% having a worth to watch, High Quality Information

  • @wayneedmondson1065
    @wayneedmondson1065 Před 3 lety

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

  • @dhapumdhap
    @dhapumdhap Před 3 lety

    Simply Too Good and Simple! 👌👏👏👏

  • @Adi-jk2ef
    @Adi-jk2ef Před 3 lety

    Amazing tricks 👍

  • @nitinparmar5117
    @nitinparmar5117 Před 3 lety

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

    • @trumpexcel
      @trumpexcel  Před 3 lety

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

  • @10_endy6
    @10_endy6 Před 2 lety +1

    Woww, its so useful. Thanks for sharing. Already subscribe + like

  • @shahulhameed-dc2fz
    @shahulhameed-dc2fz Před 3 lety

    Excellent

  • @ahmedabdelrahman829
    @ahmedabdelrahman829 Před 3 lety

    Keep going, it's helpful