How to do Data Entry work in Excel | एक्सेल में डाटा एंट्री करना सीखे | Data entry kaise kare

is video me humne bataya hai ki Data Entry ka kam hum excel me kaise kar sakte hai ..agar aap data entry job karne ki soc rahe hot to aapko ye pata hona chahiye | How to do data entry work in excel, aur ye aapko practically is video me sikhane milega...data entry excel me fast kaise karte hai ye bhi detail me explain kiya hai
Timestamps
00:00 Introduction
04:20 How To Start Excel
04:54 Excel Welcome Screen
05:25 What is Row, Column, Cells, Menu, Ribbon & Sheet
12:25 Lets Start Data Entry in Excel
16:28 Fill Hander in Excel
23:12 Freeze Panel in Excel
27:08 Data Validation in Excel
31:40 Add New Column in Excel
32:26 Create List in Data Validation in Excel
38:30 Create Form for Data Entry
42:00 Change Vertical Data to Horizontal in Excel
45:27 Number Formats in Excel
51:45 Basic Formulas in Excel
53:20 Data Formatting in Excel
1:07:50 Create Custom List in Excel
1:11:01 Sort and Filter in Excel
1:16:48 Conditional Formatting in Excel
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Courses Website :bit.ly/skill_course
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : skillcourse.in/
My Blogging Website: learnmoreindia.in/
Facebook Page Link: / learnmoreeasily
Telegram Channel Link: t.me/learnmoreindia
My Other Hindi Channels:
Real Tutorial : ✅
/ @realtutorial550
Tally Tutorial :✅
/ @tallytutorial
Complete Technology :✅
/ @completetechnology
Curiosity : ✅
/ @curiosity9432
My Marathi Channel
Satish Tech ;✅
/ @satish_tech
मायलेकी किचन ;✅
/ मायलेकीकिचन
My KZbin Gears :
Best Mic for Recording (Condenser Mic): amzn.to/2UUMDnH
Best Mic for Recording (Dynamic Mic ): amzn.to/3pQgyvD
My DSLR Camera Canon 200D: amzn.to/39ciw3E
My Laptop (Video Editing): amzn.to/2UXQj8h
Laptop (Office Use/ Home use / Budget Laptop) : amzn.to/3l0pniw
Antivirus: amzn.to/3l3TIgi
Screen Recording Software: bit.ly/2J39n2j
Video Editing Software: bit.ly/3nOPlri
Green screen with Stand: amzn.to/2KAl1Cu

[@Learn_More_Pro]

Learn Satish Sir courses with Certificate Download Course App : bit.ly/3BWfQVa Courses Website :bit.ly/skill_course Course Features : ✅ सभी Videos सरल हिंदी भाषा में ⬇ Download Video in APP ✅ Basic to Advance Courses ✅ Practice Files (Yes) ✅ PDF Shortcuts ✅ Course Completion Certificate ✅ Instant Access ✅ Watch on Desktop : skillcourse.in/

[@mangilalchavanmangilalchav6518]

This video very useful thanks sir

[@Nutty_Vlogs]

Column wise freeze same way karte hai? Bahot Column Hota hai to bhi problem Hota hai. And number pehle code mai zero Hota Hai to wo zero nahi dikhata hai. Use kaiser format kare? Example 0000235678

[@kiranverma6338]

Very nice

[@RahmatAli-wv8pn]

hii

[@PUJAKUMARI-em3ze]

@@kiranverma6338 😊 ni ki 😭😭😭😭😭

[@theindianyoutuber8712]

Cahlo koi to hai KZbin mwi jo such mai kuch dhang ki chiz sikha rha hai nhi to yha to bas 1 din krodepati bnate hai sab. Dhanyawad bhai very nice video. 👌👌👌❤️

[@EmitraServices1175]

Right

[@zoyashaikh2392]

right

[@Harshitasinghrawat]

Bhut koi hai achha se dekhiye

[@Harshitasinghrawat]

Pushkar Raj thakur, sonu sharma , harshwardhan Jain , Sandeep Maheshwari, Arvind Arora , vivek bindra, Dhruv Rathee , Khan sir , Vikas Divyakirti , Dr ujjawal pathani , Nitish Rajput, mohak Mangal etc

[@hariompal0306]

Sach bola mere bhai

[@nameartstatus896]

topic you want 👇 00:00 Introduction 04:20 How To Start Excel 04:54 Excel Welcome Screen 05:25 What is Row, Column, Cells, Menu, Ribbon & Sheet 12:25 Lets Start Data Entry in Excel 16:28 Fill Hander in Excel 23:12 Freeze Panel in Excel 27:08 Data Validation in Excel 31:40 Add New Column in Excel 32:26 Create List in Data Validation in Excel 38:30 Create Form for Data Entry 42:00 Change Vertical Data to Horizontal in Excel 45:27 Number Formats in Excel 51:45 Basic Formulas in Excel 53:20 Data Formatting in Excel 1:07:50 Create Custom List in Excel 1:11:01 Sort and Filter in Excel 1:16:48 Conditional Formatting in Excel

[@amitkushwahavlogs3615]

How make this

[@virendrakumar137]

L

[@virendrakumar137]

L

[@BachpanKiDuniya22]

Thank you so much it's so helpful

[@sonalimore467]

Thank you dear

[@AnjitaKumari2.0]

Kaun khaun ye video 2024 me dekh rha hai..😂😂😂

[@user-kn7cc6qj5c]

😂😂😂 main dekh raha hon

[@alishayousaf203]

me

[@lalitasingh5811]

Me

[@Mr_Sonu_Edits]

Aur me bhi😅

[@AousaDiwan]

Mein or sir to racist nikle 😂😂kale ko gore bana rahe hai

[@Tech_gaming231]

सर जी काबिले तारीफ सिखाया आपने एक एक एंट्री इतनी अच्छी कलियर की गई है कि मुझे ऐसा कोई दूसरा वीडियो मिल ही नहीं आपका बहुत बहुत आभार

[@queen_eshu_0072]

Superb esa lagra hai kisi professional se bhi jyada ache se sikha re ho vo bhi free me... Thank you sir..😍👍

[@sunilpatil9293]

Hi

[@ehsanraza4404]

U right 🍁sister

[@GurpreetSingh-vq9by]

Helo

[@manojkumar-vk4kl]

Very nice vedio sir

[@SarveshSingh-kx9iw]

Hi

[@akramazmi90]

पढ़ाई में भी तभी मन लगता है जब टीचर हंसाने वाला हो Great sir ❤️

[@suraiyabano9316]

Sahi bole ap

[@kiranbisht.64]

Haan

[@KHAN_TECH_07]

Padhai me tabhi man krta hai Jab Jimmedariyan badi ho ✅

[@raviverma1314]

Super🎉

[@nehaneha9861]

Dil ki baat kah di aap ne ☺️

[@ajyadavjee6169]

अगर टीचर खुद को टीचर समझने लगे तो बो कभी अच्छा नहीं पड़ा सकता ,, अगर टीचर 1 स्टूडेंट बनके पढ़ाय तो वह टीचर् नहीं भगबान होता है ।। धन्यबाद गुरूजी ।।😊😊❤️❤️

[@patti_x22]

YOU ARE GREAT SIR YOUR EXPLAINING IS WONDERFUL , AND IAM LEARNING MORE FROM YOU, KEEP IT CONTINUE, THANKYOU VERY MUCH .

[@wordofgodjesus865]

शानदार । बहुत ही सुन्दर। कोई भी नया व्यक्ति जिसको डाटा एंट्री का ABCD भी नही मालूम वो इस वीडियो को देख कर आसानी से सिख सकता है। आपकी मेहनत को सैल्यूट है। धन्यवाद ।

[@jubedajamadar3214]

Aapka comment bahut important raha..thank you👍

[@Hanus_bigworld]

Sir mujhe data entry bilkul nhi aati apki video kafi helpful h mere liye..

[@aaliyabegum1468]

Super se upper phli bar itta detail se excel smjh aya thnq so much sir🎉

[@youngleaders4622]

Awesome video for beginners Really helpful

[@Ranjan_121]

Maza aa gaya Excel padh ke... Thank you so much sir ❤🎉

[@user-uq6tx2oi1m]

Sahi mein bhai

[@user-uq6tx2oi1m]

Aap kaha se ho

[@SanjaySharmaMahi]

बहुत ही रोचक एवं सरल तरीके से excell समझाया गया है👈 आपका बहुत-बहुत धन्यवाद🙏💕

[@sandipabudhathoki3449]

Ase Gazab k teachers aaj tak nahi dekha amazing your comic timing & teaching style just wow 👏🙏❤️😊

[@PrashantShehrayoga]

Love you baby

[@arshadkhan-pu3rj]

​@@PrashantShehrayogakafi achche pariwar se ap belong karte ho brother konsi maa ne apko janam diya mujhe unka nam janna hai

[@VikasYadav-ir9tf]

Bahut achha sikhaya hai aapne sir 😊

[@biruchauhan165]

मा कसम आज तक से ऐसा वीडियो नहीं देखा हु जिसमे भाईया सभी doubt को आसानी से बता दिया है...। ओर हसी तो इतनी आ रही है ...जिसमे सिखने मे बहुत मजा आ रहा है...धन्यवाद भाईया जी...।🙏

[@user-uq6tx2oi1m]

Sahi mein

[@user-uq6tx2oi1m]

Aap kaha se ho

[@varshabanjare9421]

Data entry mujhe pahli baar samjh aaya vo bhi itne interesting tarike se .... thanks 🥰😍👌🏻👌🏻good job sir 🥰

[@sarojmandal5549]

ଧନ୍ୟବାଦ ଗୁରୁଜୀ, ମୋ ପାଇଁ ବିଶେଷ ସାହାଯ୍ୟକାରୀ ହେଇଛି ଏହି ଭିଡ଼ିଓ.... ଆପଣ ବହୁତ ସୁନ୍ଦର, ବୋଧଗମ୍ୟ ଭାବରେ ପଡ଼ଉଛନ୍ତି l

[@matiullahansariansari2531]

Sir you are so great 👍 I understand data entry

[@freesoul1234]

No other youtuber can explain like you.. you provides us every small to big details...I am your biggest fan

[@vijaykumardhruw8802]

Sir ji, Aapke video dekhkar bahut kuch sikhne ko milta hai. The way of teaching is Exellent👏👏👏. Video me bich bich me aapki comedy se maja aa jaata hai jo bor hone nahi deta. Thanks a lot sir ji🙏🙏🙏🙏🙏

[@user-ws7np6bs7r]

Very helpful video ❤I truly appreciate your effort👍

[@bhumikasoni3440]

Sir Aapne video ke bich me kaha ki ham baki chij ke liye time nikal lete hai but padhai ko time nahi dete to mai ye kehna chahti hu ki Agar aap jaisa teacher ho to mai hamesa padhai ko time du❤❤thanku so much bahut helpful video hai mere liye😊😍

[@nayeemansari1144]

very well explained. great video covered almost all important topic very useful to everyone who wants to learn about excel. your teaching method is very excellent. Thanks a lot sir you are doing great noble job.

[@hirdeshprajapati311]

the thing is he is even explaining the exceptions for the learners who started it ,it is commendable and remarkable i would se sir nailed it 💯

[@SachinKumar-yq9ni]

Excellent sir so very best explain

[@nabeelnuman]

sir ap ki bhot bhri qurbani ha k ap ny 1 hour 23 min tk contineously video bnai mn to ye 1 video 3 hours mn mukammal ki ha.But I am really thanks for thiis video k ap ny hmaare liye itna time diya or wo b fee off cost thanks enjoy happy life

[@santlal55361]

Very impressive. Bahut hi majedar tarike se explain our sikhate hn.. Amazing Thank you sir.🙏🙏🙏

[@prafollajha4365]

Great and organize course he prepare . If you give your time especially watching full videos with full focus no one can stop you to be hero from zero. Thankyou so much sir jee. ♥️♥️♥️

[@sagnikkarmakar8429]

All of us should learn from you how to teach beginners. Excellent explanation with demo. Thanks in advance for making next videos.

[@MaryamBibi-fs3uf]

Sir ap boht acha sikhaty hain

[@naeemcheema7453]

Sir, Satish - Great man great knowledge. Serving Humanity and community with wonderful teaching style. God bless you

[@bhaimohsin]

Best Useful shortcuts in excel 1: F2 (Edits Cell data instead of overwriting) 2: alt+H+O+I (Autofits columns to widths) 3: ctrl+Shift+minus (Deletes the selected rows and colums)

[@meghakumari7241]

Ye kya hai koi samjha sakta h..... Avi mai new new learn kr rhi hu

[@kkunplugged2024]

@@meghakumari7241 shortcut keys

[@mostofaakash6898]

You are right.

[@tapaskumardas4518]

Ui iki

[@tapaskumardas4518]

9

[@roohitaj7610]

Hello sir,m a home maker..watched ur video its really very very helpful trying to Join a company for a data entry post..i learnt soo much from dis video n also gained confidence to apply for d job...thank u so much... Great work 👍👍👍👍

[@unknown-wy8ht]

hey! you got the job ? please reply.....

[@Mr.x0015]

सीधी बात नो बकवास 🙏👍👍👍 Great video sir 👍

[@user-fs7ns1ji7r]

Sir bahut achaa bata rahe h meri job me mujhe ak sal se computer ka work kara rahe h or Jitna jaruri h otna hi bataya gaya h or me 58 ki hu aapka video mere liye beneficial h thanks

[@mikhaellakra4651]

Your teaching style is really very nice sir I liked it.thanks a lot. Continue to provide your intelligence among us.

[@KhushbooKumari-zp8yf]

I was afraid to learn MS Excel but after watching this video today, I have learned a lot in a single day. Thank you so much sir g 🙏🙏

[@mohdaminbhat9031]

honestly same here , i learnt a lot from this video

[@zafarmalla1581]

Hloo

[@jaishrigo4333]

Hello sir Maine aapka video pahli baar dekha hai aur itna dhang se batane wala teacher pahli baar dekha hai,Jo students ko chahiye HR chiz bataya h aur batate h , aise hi teacher ko asli guru kha jata hai , aur aapki baaton se hi lagta hai ki aap bhot acche insaan h 🙏🙏🙏🙏

[@nknikhilkokate]

Learning with comedy 😂 very good sir thanks for videos, comedy ke wajah se bore nahi hota😃😜

[@jarbanvlogs8387]

Sir आपके जैसा गुरु मिलना मुश्किल है क्योंकि आपके पढ़ाने का अंदाज़ बहुत अलग हैं आपके 1 घंटे का वीडियो को जब देखते हैं तो पता हीं नहीं चलता है की समय कब निकल गया Thank you so much sir

[@Noor-ol4ql]

Actual mein hum sabko aise GYAN waale vdos chahiye. Itna detail nd it's full of education for a 'poor knowledge ' person like me lol. It's a classroom for learners. I feel like I m actually in college nd things r going smoothly in my mind. Thanku sir for making this vdo effort (which we respect nd appreciate) for us to gain knowledge.

[@GyanhiGangahai]

बहुत अच्छा Explain tarika excellent

[@deepakjangir4743]

Amazing ☀️☀️ Don't explain by words Thank u sir for this information

[@afzalwalitaj2339]

Satish Sir Zindabad !!!!!!!! All rounder sir.....Stay always blessed.... teaching styles,tactics all are okey.

[@hamzakhan8782]

Nice Sir G Main Pakistan Say Hun Nice Bhout Faida Ho rha Hay

[@KanakShukla-hc4gi]

Very Thank you😊 sir..🤗🤗

[@Hamzaali-zi8ce]

I love y aap mara teacher ho Main na ms office ki videos deakh ka hi seakha tha

[@DarkHeaven99]

Maine bhi sir se sikha hai

[@Hamzaali-zi8ce]

@@DarkHeaven99 very good Bro

[@sketchinghands4554]

16:00 pe mera coulmn auto fit nahe hora can u please help Wo saare column m bda ya fir saare m chota ho jaa rha h

[@nanijaan3627]

MashaAllah Sir I learn much more in a short period of time from your vedio. Thanks

[@shairi3844]

Same here Nani jaan

[@user-ku2fc9pu8o]

Thank you so much for this informative video. After watching this video I realize that it is really easy to work on MS Excel and slowly and gradually I'm becoming confident running this software. Thanks alot!

[@shivisharma5228]

Computer ka education ki hu but knowledg nhi thaa। But butt। Thank youu jo ki appki jaise teachers haii jinse। Hum appni tayari kar sakte haii 🥰🥰

[@hiteshmishra471]

No one can be as much good teacher as he is mind-blowing

[@archanasonawane7478]

Ur desire and dedication to learn the people is really appreciable, 👌, awesome....u explain al the smallest things...that is really helpful for us...

[@naeemcheema7453]

Well said about digital marketing sellers. You are certainly unique personality having depth knowledge delivering free to learners. Regards, Naeem

[@chinmayaadhikari4097]

Wooooo.. thank you so much sir for this knowledgeble video

[@sureshchandrajena9134]

Satish Bhai, Good morning. Really your style of teaching is very unique. You are a great master of computer applications. You are also a great comedy master of computer. God bless you. You are a most experienced teacher throughout India as you tuber. All the best.

[@sujalgawai5258]

Thank you Sir For teaching Data Entry in easy Word 😇🙏

[@PritamSingh-gn8xs]

Bahut bahut sukriya sir aapke vajah se mai ye data entry sikha hu. I am so happy sir.. 🙏🙏🙏 aapke her ek video se mai sikh raha hu sir or tally bhi sikha hai maine thanku so much sir.

[@AKreativeshorts]

Loved the way you explained, thank you

[@lalitapunia7014]

You deserve lots of compliments for providing such a nice information in a very simple way. your teaching style requires a special compliments

[@RPunia-cr7eu]

अच्छा 🙄

[@tanmoyofficial2283]

Thank you sir you are great for teaching us online 😊❤😍😍😘

[@raginisrivastava7916]

Bhut hi achchi vidio sir main yesi vidio bhut din se dhud rhi thi thanks sir

[@mayankkataria7829]

Dost being an Engineer, i just randomly started your video, got good tips and you are superb tutor.

[@tahirmalik5084]

Good information & brilliant explaining style💞🇵🇰

[@KasrulChoudhury-dw7dw]

Mashallah bahut acha laga hai aapka tich ❤ Love you so much sir

[@Barkha-yz9xl]

Thank you sir ap ne bhout ache se smjaya 🙏😍😍

[@mlalakela426]

With regards, I can only say that you are an unique teacher. Hats off to you.

[@vyasrasu]

You deserve lots of compliments for providing such a nice information in a very simple way. Your teaching style requires a special compliments Keep up.

[@archanapatil8785]

Sir kharch khup chhan aahe video...khup shiknyasarkh aahe...thank you so much...

[@pk-iq1ym]

Very very useful thanks a lot☺🤗

[@umendrakumar6517]

ग़ज़ब है आपका पढ़ाने का तरीका... मज़ा आ रहा है सर.... Salute आपको

[@ergastic_saga]

Sir i want to tell you one thing that your teaching style is amazing...even a dumb student can also learn from your videos...thank you so much..❤️😊

[@manishchoudhary3085]

Hiiiiii

[@rahulnayak5097]

Tq so much sir

[@ravishankarkumar8120]

Ravi yadav

[@DiptiPatra123]

Tq sir mujhe aapka section bahut achcha Laga bahut kuchh sikhane ke liye Mila

[@CharanjeetKaur-ps4bh]

Very good sar think you ji....🎉.. waheguru ji apka bhala kary ji

[@AshishThakur-vd2pu]

VERY HELPFUL VIDEO SIR....THANKU SO MUCH

[@parthsolanki1166]

Really sir u nailed it becoz earlier excel was tuff for me but after watching your videos u have taught frm scratch to advanced, Superb really like your video 👏👏👏

[@rohanRajput0707]

Sir ek ap ho pure youtub me Jo such me bilkul sahi se samjhaya h wrna or hote h bs aghe aghe bhagte h ap to do do bar bata rahe ho ek chej ko Sir thanks I will watch all your videos your videos are very good and I can understand them too.....♥️

[@neeljhum3747]

Your teaching procedure is very fair &good. Thanks

[@interestingmoments6564]

Thanks for this video it's very helpful to learn excel....and how beautifully you teach... (Tareef k qabil😊)!!!

[@hiralalkumar5883]

Thank you so much sir! 👌🏻👌🏻👌🏻👍🏻 🙏🏻🙏🏻 Greatest knowledge for us!!

[@sawaminarayn]

Thank you so much sir ❤❤❤ Aapke liye jitna bolu utna km hai Maine aaj tak sheet nhi dekhi Lekin Aaj to pura Excel sheet bnana sekh gya hu Dubara se Thank you so much sir ❤

[@kajalgarg6528]

Bhut hi bhut hi gajab ka shikya apne maine pura ek din me shik liya kitna achaa shikhaya koi word ni h kane ko sir vakye kabil trif h 🎉🎉🎉🎉🎉🎉 pahli bar u tube pe lga ki h kuch ha ❤❤❤ thnku so much sir

[@mahaulcity]

Fan ❤️ ho gya 👍👍👍

[@tejju871]

Full course h ky bhai ye ???? ❤️

[@ritikaagarwal6543]

Learn with 😊 fun excellent 👍

[@contentcreator2440]

Fully understand and thank you for ths video :)

[@RishabhKumar-xs9ny]

Thankyou so much sir 🙏❤app bhut ache ho👍🏻

[@szeverything9483]

I AM SO IMPRESSED FROM YOUR TEACHING

[@MathematicsTutoriall]

SIR It were great learning about the data entry in excel and You teaches us very good and you have teach all the basic function and all the things which were covered in this lecture and thank for teaching us and give all the information related to data entry

[@user-earth9842]

I just love you sir, you are amazing 🎉

[@ejazhanif4403]

shukria sir bundle of thanks from pakistan may god bless you sir

[@abdulkhaliq8007]

very interesting and helpful style of teaching, very easy to pick. In this field you are always a winner.

[@jayagopalajuluru3644]

Elaborated explanation is given to follow even by uneducated people in Excel..

[@manishsaini01852]

Sir tq , mujhe smjh nhi aa rh thy ki Krna kya mhuje but now aapka video dekhne ke bad mhuje smjha aaya ki mhuje yeh Krna hai

[@jasminkhatoon467]

Sir, i have't word for telling a thank's ! Supper sir very good knowledge spreed by you and your team. Thank you so much ! 😍

[@asimroy3221]

You are such a good teacher

[@rajasen6278]

Sir inni sari vidios dekhi but jo maza apke sath aya wo abitak kahi nai mila Kuch sikhna b mila or hasna b mila jai ho gurudev apki

[@lasbaraprehs5818]

❤you are My best excel teacher what i need sab Apne bataiya. ❤ thank you Guru. Late huwa apke video Dekhna

[@kamleshnargawe1]

1:20:35 Very Very Motivational Line Bole hai. 🙏🙏🙏🙏🙏 Thank You So Much And Aage Bhi Aise Videos ka Wait Rahega. Again Thank You Sir

[@desivolgsbyamit4747]

Hi I see your videos it is very knowledgeful video 1 request by me is that please make a invoice bill in excel and that should be auto print and auto save and all the features Please make a video on that topic

[@kkpanda651]

The best lessons delivery ever noticed.Thanks .

[@sanjaypandey-jq3yh]

Very nice A big thank you and big salute to you It's a good platform where anyone can learn anything in a very simplest way