7 Clever Excel Custom Formatting Tricks (Advanced)

In this video, I cover some amazing Excel Custom Formatting tricks that you can use in your day to day work.
Custom formatting allows you to show the cell content in a specific way, while at the same time, it doesn't change the value in the cell. It only changes the way a value is being displayed in the cell.
** Download file: bit.ly/38RuHC9
-------------------------------------------------------------------------------------------------------------------------------------------------
00:00 Intro
00:12 Excel Custom Formatting Overview
01:06 Hide Cell Values in Excel
03:38 Hide Zeros (or replace 0's with text)
05:50 Conditional Custom Formatting (Show Text Based on Cell Value)
07:55 Showing Dates in different formats (Month name or Day name)
10:53 Show Negative Numbers in Red
13:19 Show numbers in Millions or Billions
15:59 Automatically Add Checkmark or Bullets before Text
-------------------------------------------------------------------------------------------------------------------------------------------------
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzread.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 308

  • @sansnomnull2799
    @sansnomnull27993 жыл бұрын

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

  • @trumpexcel

    @trumpexcel

    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
    @Itsmuhdd9 ай бұрын

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

  • @ravindrakunwar4847
    @ravindrakunwar48473 жыл бұрын

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

  • @supplychainsys
    @supplychainsys Жыл бұрын

    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
    @quduslawal25913 жыл бұрын

    Sumit Bansal is an Excel Sage. Hats off

  • @sanjaybetme

    @sanjaybetme

    3 жыл бұрын

    Yes indeed 👍🏻👍🏻👍🏻🔥🔥🔥

  • @billminckler6550
    @billminckler6550Ай бұрын

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

  • @ianodonoghue7299
    @ianodonoghue72999 ай бұрын

    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

  • @jdsingh8189
    @jdsingh81893 жыл бұрын

    beautifully explained

  • @trumpexcel
    @trumpexcel3 жыл бұрын

    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 жыл бұрын

    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.

  • @venkatraj5491
    @venkatraj5491 Жыл бұрын

    good video with best knowledge

  • @jennydrumm7223
    @jennydrumm72233 жыл бұрын

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

  • @sanjaysrivastava9671
    @sanjaysrivastava96713 жыл бұрын

    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!

  • @ethiohelptube794
    @ethiohelptube7943 жыл бұрын

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

  • @Jack-er2uj
    @Jack-er2uj2 жыл бұрын

    Thank you very much for sharing your knowledge.

  • @jamesthomas8249
    @jamesthomas82493 жыл бұрын

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

  • @motalibcomputer6278
    @motalibcomputer62782 жыл бұрын

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

  • @ramamohanpathapati7694
    @ramamohanpathapati76943 жыл бұрын

    Thank you for clear explanation

  • @Lalit_4166
    @Lalit_41662 жыл бұрын

    Wonderfully explained

  • @IvanCortinas_ES
    @IvanCortinas_ES3 жыл бұрын

    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 :)

  • @drjaganmohanraomeda615
    @drjaganmohanraomeda6152 жыл бұрын

    excellently explained, thank you

  • @xyclos
    @xyclos Жыл бұрын

    Very well explained. Thanks a lot!!

  • @shahzadsami5613
    @shahzadsami56133 жыл бұрын

    100% having a worth to watch, High Quality Information

  • @SndfOmar
    @SndfOmar3 жыл бұрын

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

  • @thiyakup7333
    @thiyakup73333 жыл бұрын

    Very Nice teaching, it's very useful

  • @smitapatwardhan975
    @smitapatwardhan9753 жыл бұрын

    Your videos are very interesting and to the point

  • @GosCee
    @GosCee Жыл бұрын

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

  • @vijayarjunwadkar
    @vijayarjunwadkar3 жыл бұрын

    Great video with really smart tips for custom formatting! Thanks a lot for sharing! 😊👍

  • @tlim1945
    @tlim19453 жыл бұрын

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

  • @deepaky129
    @deepaky12911 ай бұрын

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

  • @gvinodnair
    @gvinodnair3 жыл бұрын

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

  • @rashiedasuliman4138
    @rashiedasuliman41383 жыл бұрын

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

  • @askulasaatwik8thc644
    @askulasaatwik8thc6443 жыл бұрын

    Thank you Awesome Excel tricks!

  • @kprakashsha
    @kprakashsha3 жыл бұрын

    Its explained very very very excellent

  • @user-kd4rq4mr7u
    @user-kd4rq4mr7u5 ай бұрын

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

  • @trumpexcel

    @trumpexcel

    5 ай бұрын

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

  • @jbcosta51
    @jbcosta513 жыл бұрын

    Very good explanation.

  • @pchatterjee4150
    @pchatterjee41502 жыл бұрын

    Very well explained! Thank you so much.

  • @HarpreetSingh1991
    @HarpreetSingh19912 жыл бұрын

    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.

  • @srmchinni3
    @srmchinni32 жыл бұрын

    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.

  • @stanlomas
    @stanlomas3 жыл бұрын

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

  • @jawaidiqbal945
    @jawaidiqbal9452 жыл бұрын

    Nice way to make understand Well done

  • @vijaykishan8649
    @vijaykishan86493 жыл бұрын

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

  • @Littleboy_Bill
    @Littleboy_Bill3 жыл бұрын

    Amazing! Thank you for sharing this!

  • @jarna555
    @jarna5552 жыл бұрын

    very nicely explained,Good job

  • @dhapumdhap
    @dhapumdhap3 жыл бұрын

    Simply Too Good and Simple! 👌👏👏👏

  • @adnanali3971
    @adnanali39712 жыл бұрын

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

  • @vikaasb2016
    @vikaasb20163 жыл бұрын

    Simply sublime !!

  • @mrmusicloverable
    @mrmusicloverable3 жыл бұрын

    Some powerful stuff. Thank you very much!

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you found the video useful!

  • @MostofaKamal-ll5dx
    @MostofaKamal-ll5dx2 жыл бұрын

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

  • @pathakprathamesh
    @pathakprathamesh3 жыл бұрын

    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.

  • @phey6304
    @phey63043 жыл бұрын

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

  • @rashidfaridkhan2664
    @rashidfaridkhan26642 жыл бұрын

    Simple & Excellent way..Thanks Sumit

  • @wayneedmondson1065
    @wayneedmondson10653 жыл бұрын

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

  • @zohurulislam7628
    @zohurulislam76283 жыл бұрын

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

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

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

  • @mayur7673
    @mayur7673 Жыл бұрын

    thanks buddy .. last one was really good

  • @musajuma7374
    @musajuma73743 жыл бұрын

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

  • @monirhossain9850
    @monirhossain98503 жыл бұрын

    Thank you for sharing amazing tips in Excel.

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you found the video useful!

  • @user-hy7vu6gc5n
    @user-hy7vu6gc5n4 ай бұрын

    Best explanation on this subject

  • @trumpexcel

    @trumpexcel

    4 ай бұрын

    Thanks 😊 Glad you found the video helpful!

  • @keishrich
    @keishrich3 жыл бұрын

    Helpful video. Thank you.

  • @ramk1969
    @ramk19693 жыл бұрын

    excellent tips sir...Thanks....

  • @AlejandroMora29
    @AlejandroMora293 жыл бұрын

    Sumit, you are a wizard!

  • @kendrewt
    @kendrewt3 жыл бұрын

    Appreciated! I learned a lot from you!

  • @excelworx8712
    @excelworx87123 жыл бұрын

    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!

  • @debopomsaha8694
    @debopomsaha86944 ай бұрын

    thanks for clear explaination

  • @trumpexcel

    @trumpexcel

    4 ай бұрын

    Glad you found the video helpful 🙂

  • @israelaguilera9613
    @israelaguilera96132 жыл бұрын

    Amazing work!

  • @swathic1621
    @swathic16213 жыл бұрын

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

  • @jeaniminerales5578
    @jeaniminerales55783 жыл бұрын

    VERY USEFUL SIR

  • @marynelrocero8092
    @marynelrocero8092 Жыл бұрын

    So useful, thank u so much!

  • @vinaykhadilkar
    @vinaykhadilkar3 жыл бұрын

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

  • @shibilsnoopy3973
    @shibilsnoopy39733 жыл бұрын

    Finally i found the excel king

  • @bluesage1528
    @bluesage15283 жыл бұрын

    Very helpful, thank you

  • @pratikbante2711
    @pratikbante27112 жыл бұрын

    Thank you Sirji 🙏😊

  • @mdks1012
    @mdks10123 жыл бұрын

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

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you found the video useful!

  • @ashokkhegde
    @ashokkhegde3 жыл бұрын

    Unbelievable Sir. Awesome

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

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

  • @richardcharles9270
    @richardcharles92703 жыл бұрын

    Thanks Great tips, looking forward to use them...

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

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

  • @w.a.schull1357
    @w.a.schull13573 жыл бұрын

    Excellent explanations of these very useful techniques.

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you found the video useful!

  • @Froilan355
    @Froilan355 Жыл бұрын

    Great, very educational

  • @trendingpublic1069
    @trendingpublic10692 жыл бұрын

    Thanks for the information sir ❤️

  • @mohanv3614
    @mohanv36143 жыл бұрын

    Very well explained with reasons

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

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

  • @alfredoas9635
    @alfredoas96352 жыл бұрын

    WoW new trick... Thank You 🙏🏽

  • @Mao-ze-dong
    @Mao-ze-dong Жыл бұрын

    thanks man much needed

  • @dontown1531
    @dontown15313 жыл бұрын

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

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

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

  • @mariabc9815
    @mariabc98153 жыл бұрын

    Thank you. Love your videos.

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

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

  • @raziajeena9861
    @raziajeena98613 жыл бұрын

    been using excel for a while and learned lots. thanks

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you found the video useful!

  • @sravankumar1767
    @sravankumar17673 жыл бұрын

    Nice Explanation. Bro

  • @SndfOmar
    @SndfOmar3 жыл бұрын

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

  • @jiajiaphotography
    @jiajiaphotography3 жыл бұрын

    Very clearly explained and easy to apply to daily work

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you found the video useful!

  • @10_endy6
    @10_endy62 жыл бұрын

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

  • @Adi-jk2ef
    @Adi-jk2ef3 жыл бұрын

    Amazing tricks 👍

  • @gregorytaylor2749
    @gregorytaylor27493 жыл бұрын

    Fantastic tips! Thanks!

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

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

  • @mail2vj574
    @mail2vj5743 жыл бұрын

    This is Gold.

  • @Jobin.Thomas
    @Jobin.Thomas3 жыл бұрын

    Nice topics and presentation. Subscribed

  • @PankajKumar-tr7bg
    @PankajKumar-tr7bg Жыл бұрын

    Amazing Video

  • @SunilKumar-pj5gz
    @SunilKumar-pj5gz2 жыл бұрын

    Great Sir 👌

  • @vijaykishan8649
    @vijaykishan86493 жыл бұрын

    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!

  • @user-tl5lw7rc3m
    @user-tl5lw7rc3m3 жыл бұрын

    Always with you new and useful

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Glad you found the video useful!

  • @nitinparmar5117
    @nitinparmar51173 жыл бұрын

    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!

  • @broto8
    @broto83 жыл бұрын

    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!

  • @dipankarbiswas033
    @dipankarbiswas0333 жыл бұрын

    Awesome 👍

  • @saifdogar8376
    @saifdogar83763 жыл бұрын

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

  • @hubertg7100
    @hubertg71002 жыл бұрын

    Great Tutorial!