Excel Custom Formatting Part1 | Smart ways to use custom formatting in excel

Custom Number Formatting
This video show you how to add leading zeros, insert your area code automatically when you enter mobile or telephone number. You can enter name with Prefix "Mr." or color the number based on constraint provided.
Applying custom numbers/texts format on cells or range, you can create your own number format.

Download the Assignment Master Practice Folder here (All Playlist Example at one place)

===========VIDEO COURSE============================
✅ Mastering Excel Video Course
✅ Mastering Power BI Video Course
✅ Mastering VBA Video Course
✅ Mastering SQL Video Course
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
====================================================
Videos in a Sequence -Basic to Advanced EXCEL

Value add-ons Playlist

Let's Connect:

#customformatting #exceltutorial #excelcustomlformatting #msexcel #innozant

[sameerabanu]

you are extremely good in excel, you have mastered the subject.

The best part is, you reply all your students, thank you

[Altaf_Alam]

Sir i had almost watched your advance series of excel and mis approximately from 1 month i didn't watch any video of But now i want to improve my basics of excel that's why i watch your these videos from today 😍🙏

[bhuneshwarisonwani]

Sir Kya bat hai aapka sikhane ka style to alag hi hai

[kkrcreationstatus]

thank u sir bahut achhi tarah se samjaye hai it all brothers and sister

[Tejashwini]

Thanks for the informative session. Can we give any colors as Orange or Red, Green & Blue

[pramodbhavsar]

Sir aap ke custom formatting ki idea excellent hai thank you

[linextomsiono]

Hello sir, sir me basic excel seekh raha hu, aur sir me aapki sari vedios dekh kar hi seekh raha hu,
bahar se kahi se bhi mene nhi seekha

[staterolife]

Sir it's a more useful function in office line..

[pramodbhatt]

Hello Sir, Thanks for the videos it's very helpful to grow our data analysis skills I have a question here how to unhide the text and numbers after hiding the same Waiting for your reply sir..

[bharattejpal]

To get the random numbers in the list I used the RANDBETWEEN formula. Numbers ranging between 85, 150

[nitinbajaj]

Hello Sir, hope you are doing well, Thanks for sharing your videos on YouTube, Your videos are really Impressive and useful, have one question do you have coaching center too?

[dubeypushpendra]

Hi Sir,
Your videos are awesome.
Are these videos and practice files sufficient to crack MIS job or do we need to do extra apart from these ?

[kirankiran-squz]

Thank you so much sir, but i want to know after adding prefix how to remove it in one go

[rohitpatil]

Hello Sir, I have some doubt sir please solve it your last step is single or double semicolon symbol then numbers are hidden but. Why the word Kumar was hidden from Rajesh Kumar.

[rajadey]

Sir custom me if condition nhi laga skte hai?

[hemantsharma]

Namsate sir 🙏🙏 sir mujhe Interview call per EXCEl ke sath pucha ki aapko SAP aata hai kye.
Sir SAP and Power BI which is best after Excel .🙏🙏

[akansharathore]

Thank you Sir for Very useful video, I have a question that when i put this formula which is on the text like Ramesh Kumar. it will remove the surname or second name. Only Ramesh will be in blue color and kumar will deleted. But why ?

[paramjeetsingh]

Sir only text ko hide karna ho to pls batana

[dicaprioleo]

Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen

[karankapoor]

sir custom formating formating ma to color to hum koi bhi da sakta h na
chai wo black ho ya koi or color