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.

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

#Excel #ExcelTips #ExcelTutorial

[sansnomnull]

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

[Itsmuhdd]

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

Thank you sir!

[ravindrakunwar]

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

[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

[quduslawal]

Sumit Bansal is an Excel Sage. Hats off

[muhammada.muhammad]

extremely great, finally I understood it clearly

[ianodonoghue]

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

[billminckler]

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

[motalibcomputer]

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

[trumpexcel]

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:

[dontown]

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

[sanjaysrivastava]

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

[phey]

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

[Jack-eruj]

Thank you very much for sharing your knowledge.

[GosCee]

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

[HarpreetSingh]

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.

[jennydrumm]

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!

[jamesthomas]

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

[SndfOmar]

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

[excelworx]

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