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

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

Рет қаралды 10,546,076

Күн бұрын

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

Пікірлер: 6 200

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

@AnjitaKumari2.0 3 ай бұрын

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

@user-kn7cc6qj5c 2 ай бұрын

😂😂😂 main dekh raha hon

@alishayousaf203 2 ай бұрын

@lalitasingh5811 2 ай бұрын

@Mr_Sonu_Edits 2 ай бұрын

Aur me bhi😅

@AousaDiwan 2 ай бұрын

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

@theindianyoutuber8712 Жыл бұрын

Cahlo koi to hai KZfaq 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. 👌👌👌❤️

@youtubecreater1175 Жыл бұрын

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

@Tech_gaming231 4 ай бұрын

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

@sandipabudhathoki3449 4 ай бұрын

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

@wordofgodjesus865 Жыл бұрын

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

@jubedajamadar3214 Жыл бұрын

Aapka comment bahut important raha..thank you👍

@akramazmi90 Жыл бұрын

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

@suraiyabano9316 Жыл бұрын

Sahi bole ap

@kiranbisht.64 Жыл бұрын

Haan

@KHAN_TECH_07 9 ай бұрын

Padhai me tabhi man krta hai Jab Jimmedariyan badi ho ✅

@raviverma1314 9 ай бұрын

Super🎉

@nehaneha9861 3 ай бұрын

Dil ki baat kah di aap ne ☺️

@ajyadavjee6169 3 ай бұрын

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

@GyanhiGangahai 19 күн бұрын

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

@queen_eshu_0072 2 жыл бұрын

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

@sunilpatil9293 2 жыл бұрын

@ehsanraza4404 2 жыл бұрын

U right 🍁sister

@GurpreetSingh-vq9by 2 жыл бұрын

Helo

@manojkumar-vk4kl 2 жыл бұрын

Very nice vedio sir

@SarveshSingh-kx9iw 2 жыл бұрын

@aaliyabegum1468 10 ай бұрын

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

@VikasYadav-ir9tf 5 ай бұрын

Bahut achha sikhaya hai aapne sir 😊

@sarojmandal5549 7 ай бұрын

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

@biruchauhan165 Жыл бұрын

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

@user-uq6tx2oi1m 3 ай бұрын

Sahi mein

@user-uq6tx2oi1m 3 ай бұрын

Aap kaha se ho

@SanjaySharmaMahi 2 жыл бұрын

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

@raginisrivastava7916 Ай бұрын

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

@Ranjan_121 4 ай бұрын

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

@user-uq6tx2oi1m 3 ай бұрын

Sahi mein bhai

@user-uq6tx2oi1m 3 ай бұрын

Aap kaha se ho

@varshabanjare9421 Жыл бұрын

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

@vijaykumardhruw8802 2 жыл бұрын

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

@Mr.x0015 8 ай бұрын

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

@nabeelnuman 3 ай бұрын

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

@freesoul1234 Жыл бұрын

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

@mahaulcity 2 жыл бұрын

Fan ❤️ ho gya 👍👍👍

@tejju871 Жыл бұрын

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

@ritikaagarwal6543 Жыл бұрын

Learn with 😊 fun excellent 👍

@bhumikasoni3440 2 ай бұрын

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

@pramodbaisane6285 9 сағат бұрын

Jigneshji, very nice tutorial

@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 Жыл бұрын

@BachpanKiDuniya22 Жыл бұрын

Thank you so much it's so helpful

@sonalimore467 Жыл бұрын

Thank you dear

@nknikhilkokate Жыл бұрын

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

@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

@santlal55361 5 ай бұрын

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

@Hamzaali-zi8ce 2 жыл бұрын

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

@DarkHeaven99 2 жыл бұрын

Maine bhi sir se sikha hai

@Hamzaali-zi8ce 2 жыл бұрын

@@DarkHeaven99 very good Bro

@sketchinghands4554 2 жыл бұрын

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

@umendrakumar6517 2 жыл бұрын

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

@abhishekkumarsinha3379 9 ай бұрын

Very Very helpful sir 👏 Aise hi video khoj rahe the baki sab to fake hi rahta hai do video dekhne ke baad ye mila Jo Jo iss baat se sahmat hai to like kare❤❤❤❤

@monu247 4 ай бұрын

Bohut kuch sikhane ko Mila sir is vido se

@KhushbooKumari-zp8yf 2 жыл бұрын

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 10 ай бұрын

Hloo

@roohitaj7610 2 жыл бұрын

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 3 ай бұрын

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

@KanhaiyaChaudhary05 9 ай бұрын

Wow sir aap bahut achhe se samjhate hai aap ka teching mujhe bahut badhiya laga.nice🙋🙋

@shamimshaikh683 4 күн бұрын

Amazing teaching and hat's off you sir 🎉🎉🎉🎉🎉

@ahmedrafiyastatus 2 жыл бұрын

Sir your teaching style is amazing I like it 😊

@raushan121kumar5 2 жыл бұрын

Hello

@ahmedrafiyastatus 2 жыл бұрын

@@raushan121kumar5 hye

@tahirmalik5084 2 жыл бұрын

Good information & brilliant explaining style💞🇵🇰

@user-qr2mo2vl4s 5 ай бұрын

Sir apke Shri charno me koti koti parnaam

@arundas1032 3 ай бұрын

Bahut achha laga Excel ka video

@jarbanvlogs8387 Жыл бұрын

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

@prabhatbhoi 2 жыл бұрын

Very useful video sir 🙏 thanks. It helps a lot ❤️

@UniqueProcessBhaiya 2 жыл бұрын

Done

@Barkha-yz9xl 3 ай бұрын

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

@jsscn 2 жыл бұрын

I am your first viewer.

@CASP846 4 ай бұрын

Inam chahiye kya

@hirdeshprajapati311 2 жыл бұрын

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

@polashhasan9336 6 күн бұрын

Sir i am watching your video from Bangladesh and I like your video very much. 🥰🥰🥰🥰🥰🥰

@CharanjeetKaur-ps4bh Ай бұрын

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

@hiteshmishra471 Жыл бұрын

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

@radhajayswal1374 2 жыл бұрын

Thank you sir aap bahut acche se samajhte hai 🙏🙏🙏🙏🙏

@shubhangidhepe1864 2 жыл бұрын

Very informative session nice

@Shamshulgamerz Күн бұрын

Sir fan ho gya me to apka kya sikhaya hai apne ek dm bs maza hi aa gya lekin sir meri ye poori vdo ko 6-7 din ho gye 1 23 min ko practice kr kr k seekha h 😅😅

@Shekhar_karn_ 4 ай бұрын

Sir dil se sikhate hai...mja aata h

@sagnikkarmakar8429 Жыл бұрын

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

@nayeemansari1144 2 жыл бұрын

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.

@DiptiPatra123 3 ай бұрын

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

@sipubehera3435 3 ай бұрын

Sir your teaching style is very fantastic ❤❤

@quranportal258 2 жыл бұрын

Thank you soo much sir Vry informative 👍👍

@Learn_More_Pro 2 жыл бұрын

Most welcome

@nanijaan3627 2 жыл бұрын

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

@shairi3844 2 жыл бұрын

Same here Nani jaan

@user-un2sy4xv4d 6 ай бұрын

Super video hai I'm so happy ❤ se thank you sir

@PritamSingh-gn8xs 8 күн бұрын

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.

@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 Жыл бұрын

अच्छा 🙄

@AshishThakur-vd2pu Жыл бұрын

VERY HELPFUL VIDEO SIR....THANKU SO MUCH

@Sabana_Khatun_786 9 ай бұрын

bahut achhe se aapne har point btaya smjhaya 👌👌👍👍😊😊😊💪💪🇮🇳🇮🇳🇮🇳

@PriyaKumari-bv6of 8 ай бұрын

BHUT ACHE SE AAPNE EXCEL SMJHAYA HAI, THANK YOU SO MUCH SIR.

@ergastic_saga 2 жыл бұрын

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 2 жыл бұрын

Hiiiiii

@rahulnayak5097 2 жыл бұрын

Tq so much sir

@ravishankarkumar8120 Жыл бұрын

Ravi yadav

@chinmayaadhikari4097 Жыл бұрын

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

@misssapna771 9 ай бұрын

Sir bhut helpful video hia thank you so much sir ❤ji

@rohanRajput0707 8 ай бұрын

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

@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. ♥️♥️♥️

@deiphishishanongkynrih6876 2 жыл бұрын

wooww!!! it's soo interesting and I'm loving it.... Thankyou sir... apka Video bahut hi helpful hai... 🙏🙏

@user-mn1ez6mo9f 2 ай бұрын

जय सरस्वती माँ 🙏❤

@navneetbajpai5792 2 ай бұрын

Jai shree Ram ❤️❤

@siyasingh878 7 ай бұрын

Sir aap ke jaisa guru mil jaye to vidhyarthi ka jiwan dhanny ho jaye

@maltipal9381 2 жыл бұрын

Very interesting teaching styles sir really helpful for learners

@s_b_narmy4249 2 жыл бұрын

Nam kia apka

@k.g.fclass854 2 жыл бұрын

Aap kaise ho

@k.g.fclass854 2 жыл бұрын

Thik ho

@jyotichouhan640 2 жыл бұрын

The way of your talking sir is excellent and so much interesting.

@Aura_aesthetic1709 Жыл бұрын

@jyotisharma-do8yz 7 ай бұрын

Bhaut khub sir

@shrutikumbhar0285 4 күн бұрын

Superb teaching sir i have gain lot of knowledge for ky future thanks a lot hats off💓

@mikhaellakra4651 2 жыл бұрын

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

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

@sujalgawai5258 8 ай бұрын

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

@rupalimali1829 9 ай бұрын

Khup Chan sir Chan mahiti दिली Thank. U

@rahulsachdeva6991 2 жыл бұрын

Nice sir, I like your Teaching style..

@bhaimohsin 2 жыл бұрын

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 2 жыл бұрын

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

@kkunplugged2024 2 жыл бұрын

@@meghakumari7241 shortcut keys

@mostofaakash6898 2 жыл бұрын

You are right.

@tapaskumardas4518 Жыл бұрын

Ui iki

@tapaskumardas4518 Жыл бұрын

@RishabhKumar-xs9ny 4 ай бұрын

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

@tanmoyofficial2283 4 ай бұрын

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

@harshbhalerao3800 2 жыл бұрын

डेटा एन्ट्री जॉब साठी लागणारे मुख्य फॉर्मुलाज वर एखादा व्हिडिओ बनवा सर प्लिज 🙏🙏🙏🙏

@pankaj0855 2 жыл бұрын

Thank you sir for giving free information, thank you once again.

@KasrulChoudhury-dw7dw 3 ай бұрын

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

@manojkumarsoni5382 3 ай бұрын

आप सटीक जानकारी अलग स्टाइल से दे रहे हो धन्यवाद

@pranavdubey8261 Жыл бұрын

Your teaching friendly. very well explained. great video covered almost all important topic very useful to everyone who wants to learn about excel. I am biggest fan of you.

@chandamehra2481 Жыл бұрын

Mee also sir i really like you .. teaching methods

@roasterjaani 7 ай бұрын

Mai jo skills seekhne aya tha sach me ia video me seekh gya bahut bhaut dhanyawad sir ji or hamare liye aapne itna time diya hai is video mai samjh sakta hu Or mai to hans hans ke seekh kuki bhai ne bahut ache se sikha diya sb log like karo bhai ke channel ko subscribe karo