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

[@sameerabanu3115]

you are extremely good in excel, you have mastered the subject. The best part is, you reply all your students, thank you

[@Innozant]

Thanks Samera. keep learning ..keep exploring..👍❤️

[@Altaf_Alam]

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

[@Innozant]

Great Altaf.Again revise from scratch

[@bhuneshwarisonwani6645]

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

[@Innozant]

Thanks Bhuneshwari for such a lovely comment.Really means a lot to me dear❤️♥️👍🙏 We welcome to experience the taste of Success. Recommend you to start learning step by step from Playlist basic excel onwards.

[@kkrcreationstatus6583]

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

[@Innozant]

Thanks.Thats great..sabko motivate kariye padhne ke liye ..apne behtar kal ke liye

[@nandiniraj8052]

never seen a better teacher

[@Innozant]

Thanks Nandini,Keep Learning and Keep Growing ❤️

[@nandiniraj8052]

@@Innozant I had one doubt . If I am Nandini kishore and i want to create a code name like Nan kis then how to do it in excel

[@UdayKumar-vn8do]

Thank you so much sir Your Videos are most useful for us❤

[@Innozant]

Thanks

[@pramodbhavsar4488]

Sir aap ke custom formatting ki idea excellent hai thank you

[@Innozant]

🙏❤️😊

[@Tejashwini111]

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

[@srinivasbattula1863]

Valuable material at free of cost

[@Innozant]

Thanks..dear..Keep Exploring

[@techgalaxy100]

Bahut umdah!!

[@shahzadsiddiqui5117]

thanks for such great video

[@anilkumarchaurasiya7060]

Thank you sir 🙏🙏

[@aatifrashid5413]

Awesome Lecture!

[@pramodbhatt6906]

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

[@Innozant]

Already explained in custom formatting dear

[@rahulkumarsharma9533]

Super function. Again remember..

[@durveshkumar4201]

Good sir

[@kirankiran-sq7uz]

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

[@kirankiran-sq7uz]

Delimate krke ?

[@Sridhar6770]

Thank "u" sir, i have to learn further also

[@BrajeshKumar-op2po]

Super sir

[@ManjeetSingh-th4fu]

Really, it's amazing session.

[@Innozant]

Thanks Manjeet Ji

[@hemantsharma4896]

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

[@rajadey1552]

Sir custom me if condition nhi laga skte hai?

[@karankapoor200]

sir custom formating formating ma to color to hum koi bhi da sakta h na chai wo black ho ya koi or color [red][>=100]#;[black][

[@dubeypushpendra4558]

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 ?

[@Innozant]

It's more than sufficient to even crack experienced based mis or data analytics job

[@dubeypushpendra4558]

@@Innozant Thanks for you resources sir. Hoping to work as a Data Analyst soon by switching my current job profile after completing your all video lectures and study material

[@bharattejpal2777]

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

[@linux313]

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

[@rohitpatil2307]

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.

[@sahilprashar6465]

How would I fix the percentage number format 200% to 2.00% in Excel? can you tell me sie how can i solve this question?

[@bharattejpal2777]

Good Noon Sir, I used the code [Blue][>=100]#;[Red][

[@nitinbajaj9436]

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

[@Innozant]

Thanks Nitin Jim.Yes we are running Training Institution Innozant Delhi .

[@nitinbajaj9436]

@@Innozant Thank you so much for your reply Sir😊I want to be your student, hope will meet soon..

[@staterolife1651]

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

[@AbhishekKumar-nb4et]

Very interesting video

[@sheebakhan1487]

sir ye approach mai case sansitive matter krta hai kia plz is query ko solve kryega case sansitive wali

[@Innozant]

Kis scenario me

[@sheebakhan1487]

Sir in Custom Formatting @@Innozant

[@akansharathore7346]

Thank you Sir for Very useful video, I have a question that when i put this formula which is [Red][>=100]#;[Green][

[@Innozant]

Ok..let me check... Check for single word still issue?let me confirm

[@Gagansingh-ct4jt]

Sir I have one question please explain this when we use hide options why hide that data we puting by custom formatting like u add mr and and other words

[@Innozant]

Didn,t get you Gagan ji,hide what text or all ;; -number , ;;; all.Data hiding gou mY Applg fir worksheet na.

[@Gagansingh-ct4jt]

@@Innozant sir yes I do that i m asking you if I m put some text by why they hide when we hide only numbers

[@Innozant]

If you hide only numbers using ;or ;; there is no reason to hide all. You musy check once itz workinv fine

[@Gagansingh-ct4jt]

Sir mai number hide kar rha hu tab jo text maine name ke aange ya piche custom formatting se dale he wo bhi hide ho jate he

[@Innozant]

Ok..Kal mrng yaad dilana ..main apko worksheeg lar krke record krke whatsapp kr dunga explain krke .ydi ap try kren aur na ho paye to batana kal

[@tjr1421]

Sir when it comes to changing color as per > and < than, typing (red)(>=100)#;(green)(

[@Innozant]

Which version of Excel you are using now

[@tjr1421]

@@Innozant 2007

[@pancux670]

You are using wrong brackets

[@paramjeet975singh3]

Sir only text ko hide karna ho to pls batana

[@anooparora2515]

Thanks

[@indianlifeinsaudiarabia]

Last example me saare values hide tho ho gaye then phir wapas kaise laaye Bina cntl z kiye

[@Innozant]

Custom formatting me jahan ;;; lagaye the bus use remove kar diya

[@indianlifeinsaudiarabia]

@@Innozant ok... thanks for the reply..... I will try and practice this.... I decided to brush up myself by watching and practicing all your 75 videos under this playlist... Abhi 12th one chal raha hai.... Thanks for uploading videos on KZbin

[@dicaprioleo8261]

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

[@laxmanbhardwaj2554]

how to write/convert much more data of date format 05-05-2023 into "0523 " Please and 05-01-2000 into "0100" in Number Format

[@pawankumardk9399]

🙏🙏🙏🙏🙏Sir 💞💞💞💞💞 Jo apne Name ke peeche Kumar add kiya hai usme se Mr. hat gya hai

[@Innozant]

Hataya hai dear ..hata nhi h 😊❤️

[@pramodsingh4236]

If I entered 1 in a cell, I want to show the value like PRA0001 in same cell HOW CAN I USE CUSTOM FORMAT FOR THE SAME PLEASE GUIDE ME

[@pancux670]

Just type "PRAN000"# in custom formatting

[@puneetapaswan7561]

How can we take admission in offline mode

[@Innozant]

Kindly call/whatsapp us for more info about offline course (contact no available in latest video intro or our website) Feel free to call/whatsapp us

[@NikhilAnandMishra]

sir number gayab nhi ho raha hai formula bar me dikh raha h iska kya karan hai

[@shivamonestop380]

Intresting

[@ramanmangat3320]

Sir, je Hide kite hoye numbers.ja text nu unhide karna howe frr ki kriye ??

[@Innozant]

Raman Ji ya to English ya Hindi me query kariye dear jisse main asani se apko samjha Sakun..nhi to pehle aap mujhe Punjabi bolna seekhiye aur main MIS seekhata hu.😁🙏♥️

[@ramanmangat3320]

@@Innozant sir,video ke last me apne numbers or Text ko Hide kiya tha na, agr usko Unhide karna ho to kase kare?

[@Innozant]

Ctrl+1 -custom formatting -;;; ydi hide krna ho all aur remove or dijiye ydi unhide krna ho👍

[@mishracommercetutorial]

Sir playlist me jo 73 video ka jo list hai wahin se start karna hai na excel ki class.

[@Innozant]

Yes Mishra ji..wahin se start karna hai seekhne phor advance ke taraf move krenge(upcoming notification playlist me jaiye wahan ek video hai jisme bataya hai learning processes)

[@mishracommercetutorial]

Ok sir thanks a lot 🙏🙏🙏.

[@gauravbhatia7987]

Thnq sir

[@RahulChauhan-ll9pu]

How Can i join your class

[@Innozant]

Thanks Rahul for showing your interest in our MIS Advance Excel Training.Kindly share your contact no. or you may contact us on 7065069985 for Virtual Classroom Training

[@Gagansingh-ct4jt]

Sir when I am using colour formatting for text I have a error "excel can't use the number formats." Please help me

[@Innozant]

Share your question.will help you out

[@Gagansingh-ct4jt]

When I am used @ for text in custom formatting I saw error excel can't use the number formats

[@Innozant]

Why error..it is use for text data and #for numbers

[@Gagansingh-ct4jt]

Sir mai number formatting me le rha he text ke liye @ use kar rha hu wo massage error a rha he single text ke liye bhi kiya wahi dikha rha he

[@Gagansingh-ct4jt]

Sir 8:33 video me dikhiye apne jo text add kiya tha Kumar jab apne number add kiya wo to wo text bhi hide ho gya

[@shwetkumar1719]

Sir if we want to add title to the name For example "Pandey" then how can we do it with custom formatting

[@Innozant]

Already explained..kindly watch custom formatting Video

[@shwetkumar1719]

@@Innozant Sir kr raha hu but wo Pandey Rajesh a raha hai but mujhe Rajesh Pandey krna haui to?

[@Innozant]

@pehle lgaiye phir Rajesh likhen

[@shwetkumar1719]

@@Innozant k sir! thank you got it.

[@nehaamourya6723]

💯💯👍👍

[@shwetkumar1719]

Sir aap "Enter only positive value" ke baad @ kiu nhi lagae?

[@Innozant]

Wo text nhi h na...@text ke liye lgayenge na..ye to bus likhke aayega

[@shwetkumar1719]

@@Innozant K sir!

[@ashrafali-ww3go]

Sir i can't see your formula because text is small.. Please try to help me

[@Innozant]

Kindly download the example worksheet dear...and then watch video and do Practice..Please find example worksheet from Video Description -Link given there

[@ashrafali-ww3go]

@@Innozant thank you Sir I'm daliy watching nd understanding because I want to do excel job.. Please send more videos of interviews nd tips which can make me to get job.. Thanks lot.. Allah apko hamesha khush rakhe Ameen.. Thnx lot.. Sir.. Ur really really smart nd great work done.. Thnku again.. I will learn nd I will go for interviews Sir

[@Innozant]

@@ashrafali-ww3go Ashraf Sahab kindly note that almots complete tutorial are there,Kindly learn step by step from playlist in sequence.Interview Cracker & Live Interview Series playlist will help you out to Crack the interview

[@Innozant]

Harek video ke description me already Diya Gaya hai video in sequence list.

[@ashrafali-ww3go]

@@Innozant Thank you so much Sir thik hai i will practice nd learn it.

[@muhammadsaqlain5162]

Aur dusra sawal ye hai k custom formatting man (semi colan ;) ka kya roll hai?

[@Innozant]

Already explain Kiya hai dear. Aage ke videos me

[@muhammadsaqlain5162]

@@Innozant Ok Sir thank you very much.

[@muhammadsaqlain5162]

@@Innozant Sir man ap ka video dekh ker bohot kuch learn ker liya hai bus learn kernay walay ko shoq ho to wo bohot gazab ka excel learn ker sakta hai.

[@muhammadsaqlain5162]

@@Innozant Ap k her video man gazab ka method hai ab samajhnay walay k uper hai.

[@muhammadsaqlain5162]

Lekin sir ap nay hide to ker diya wapis kaise leker ayenge?

[@Innozant]

Wahin custom ke Jake again remove kar dein

[@muhammadsaqlain5162]

@@Innozant Sir mene remove kiya tha but jo custom format lagaya tha jesa k ap ne bataya tha wo bhi remove ho gya is liye again lagana para, ager apko pakistan se kuch mangwana ho to plz mujhe zaroor yad kijye ga plz sir man apne apko lucky maanunga,

[@muhammadsaqlain5162]

@@Innozant Means apko kuch chagye to mujhe zaroor yad kijye ga plz sir,

[@salmanishaq8705]

👍

[@artiverma5122]

👌🙏

[@Innozant]

❤🙏

[@neetushyamkuwar8934]

Bhut chhota dikh rha sir

[@Innozant]

Laptop pe kairiye practice

[@adityachouhan8046]

Ap smjhate to ache se ho but screen clear dikhti ni h to smj ni aata

[@Innozant]

Ye pehle ke videos hain dear..laptop par dekha kijiye

[@surendrapatwa4695]

Screen ko big

[@summanbansal8439]

Not clear

[@Innozant]

Query ?