Excel Custom Formatting Part1 | Smart ways to use custom formatting in excel
Вставка
- Опубліковано 6 вер 2024
- 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.
Basic Excel Playlist Link - • Basic Excel-The Learni...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#customformatting #exceltutorial #excelcustomlformatting #msexcel #innozant
you are extremely good in excel, you have mastered the subject.
The best part is, you reply all your students, thank you
Thanks Samera.
keep learning ..keep exploring..👍❤️
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 😍🙏
Great Altaf.Again revise from scratch
never seen a better teacher
Thanks Nandini,Keep Learning and Keep Growing ❤️
@@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
To get the random numbers in the list I used the RANDBETWEEN formula. Numbers ranging between 85,150
Sir Kya bat hai aapka sikhane ka style to alag hi hai
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.
thank u sir bahut achhi tarah se samjaye hai sir........share it all brothers and sister
Thanks.Thats great..sabko motivate kariye padhne ke liye ..apne behtar kal ke liye
Thank you so much sir
Your Videos are most useful for us❤
Thanks
Sir aap ke custom formatting ki idea excellent hai thank you
🙏❤️😊
Thank you so much sir, but i want to know after adding prefix how to remove it in one go
Delimate krke ?
Sir it's a more useful function in office line..
Super function.
Again remember..
Good sir
Super sir
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..
Already explained in custom formatting dear
Thank "u" sir, i have to learn further also
Valuable material at free of cost
Thanks..dear..Keep Exploring
Thank you sir 🙏🙏
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
Thanks for the informative session. Can we give any colors as Orange or Red, Green & Blue
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 .🙏🙏
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
Thanks
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 ?
It's more than sufficient to even crack experienced based mis or data analytics job
@@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
Sir custom me if condition nhi laga skte hai?
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?
Bahut umdah!!
thanks for such great video
Good Noon Sir, I used the code [Blue][>=100]#;[Red][
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.
Thank you Sir for Very useful video, I have a question that when i put this formula which is [Red][>=100]#;[Green][
Ok..let me check...
Check for single word still issue?let me confirm
🙏🙏🙏🙏🙏Sir 💞💞💞💞💞
Jo apne
Name ke peeche Kumar add kiya hai usme se
Mr. hat gya hai
Hataya hai dear ..hata nhi h 😊❤️
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][
Really, it's amazing session.
Thanks Manjeet Ji
Awesome Lecture!
Very interesting video
Hello Sir, hope you are doing well, Thanks for sharing your videos on UA-cam, Your videos are really Impressive and useful, have one question do you have coaching center too?
Thanks Nitin Jim.Yes we are running Training Institution Innozant Delhi .
@@Innozant Thank you so much for your reply Sir😊I want to be your student, hope will meet soon..
Last example me saare values hide tho ho gaye then phir wapas kaise laaye Bina cntl z kiye
Custom formatting me jahan ;;; lagaye the bus use remove kar diya
@@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 UA-cam
Sir only text ko hide karna ho to pls batana
Sir when it comes to changing color as per > and < than, typing (red)(>=100)#;(green)(
Which version of Excel you are using now
@@Innozant 2007
You are using wrong brackets
How can we take admission in offline mode
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
Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen
Intresting
sir number gayab nhi ho raha hai formula bar me dikh raha h iska kya karan hai
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
Just type "PRAN000"# in custom formatting
sir ye approach mai case sansitive matter krta hai kia plz is query ko solve kryega case sansitive wali
Kis scenario me
Sir in Custom Formatting @@Innozant
Thnq sir
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
Didn,t get you Gagan ji,hide what text or all ;; -number , ;;; all.Data hiding gou mY Applg fir worksheet na.
@@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
If you hide only numbers using ;or ;; there is no reason to hide all.
You musy check once itz workinv fine
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
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
Sir, je Hide kite hoye numbers.ja text nu unhide karna howe frr ki kriye ??
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.😁🙏♥️
@@Innozant sir,video ke last me apne numbers or Text ko Hide kiya tha na, agr usko Unhide karna ho to kase kare?
Ctrl+1 -custom formatting -;;; ydi hide krna ho all aur remove or dijiye ydi unhide krna ho👍
💯💯👍👍
Sir playlist me jo 73 video ka jo list hai wahin se start karna hai na excel ki class.
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)
Ok sir thanks a lot 🙏🙏🙏.
Sir if we want to add title to the name For example "Pandey" then how can we do it with custom formatting
Already explained..kindly watch custom formatting Video
@@Innozant Sir kr raha hu but wo Pandey Rajesh a raha hai but mujhe Rajesh Pandey krna haui to?
@pehle lgaiye phir Rajesh likhen
@@Innozant k sir! thank you got it.
How Can i join your class
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
Sir when I am using colour formatting for text I have a error "excel can't use the number formats." Please help me
Share your question.will help you out
When I am used @ for text in custom formatting I saw error excel can't use the number formats
Why error..it is use for text data and #for numbers
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
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
Sir aap "Enter only positive value" ke baad @ kiu nhi lagae?
Wo text nhi h na...@text ke liye lgayenge na..ye to bus likhke aayega
@@Innozant K sir!
Bhut chhota dikh rha sir
Laptop pe kairiye practice
Aur dusra sawal ye hai k custom formatting man (semi colan ;) ka kya roll hai?
Already explain Kiya hai dear. Aage ke videos me
@@Innozant Ok Sir thank you very much.
@@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.
@@Innozant Ap k her video man gazab ka method hai ab samajhnay walay k uper hai.
Sir i can't see your formula because text is small.. Please try to help me
Kindly download the example worksheet dear...and then watch video and do Practice..Please find example worksheet from Video Description -Link given there
@@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
@@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
Harek video ke description me already Diya Gaya hai video in sequence list.
@@Innozant Thank you so much Sir thik hai i will practice nd learn it.
Lekin sir ap nay hide to ker diya wapis kaise leker ayenge?
Wahin custom ke Jake again remove kar dein
@@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,
@@Innozant Means apko kuch chagye to mujhe zaroor yad kijye ga plz sir,
👍
👌🙏
❤🙏
Ap smjhate to ache se ho but screen clear dikhti ni h to smj ni aata
Ye pehle ke videos hain dear..laptop par dekha kijiye
Not clear
Query ?