How to do Data Entry work in Excel | एक्सेल में डाटा एंट्री करना सीखे | Data entry kaise kare
Vložit
- čas přidán 31. 05. 2024
- 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 CZcams 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 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/
This video very useful thanks sir
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
Very nice
hii
@@kiranverma6338
😊 ni ki
😭😭😭😭😭
Kaun khaun ye video 2024 me dekh rha hai..😂😂😂
😂😂😂 main dekh raha hon
me
Me
Aur me bhi😅
Mein or sir to racist nikle 😂😂kale ko gore bana rahe hai
Cahlo koi to hai CZcams 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. 👌👌👌❤️
Right
right
Bhut koi hai achha se dekhiye
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
Sach bola mere bhai
सर जी काबिले तारीफ सिखाया आपने
एक एक एंट्री इतनी अच्छी कलियर की गई है कि मुझे ऐसा कोई दूसरा वीडियो मिल ही नहीं
आपका बहुत बहुत आभार
How to do Data Entry work in Excel | एक्सेल में डाटा एंट्री करना सीखे | Data entry kaise kare
Superb esa lagra hai kisi professional se bhi jyada ache se sikha re ho vo bhi free me... Thank you sir..😍👍
Hi
U right 🍁sister
Helo
Very nice vedio sir
Hi
पढ़ाई में भी तभी मन लगता है जब टीचर हंसाने वाला हो
Great sir ❤️
Sahi bole ap
Haan
Padhai me tabhi man krta hai Jab Jimmedariyan badi ho ✅
Super🎉
Dil ki baat kah di aap ne ☺️
अगर टीचर खुद को टीचर समझने लगे तो बो कभी अच्छा नहीं पड़ा सकता ,,
अगर टीचर 1 स्टूडेंट बनके पढ़ाय तो वह टीचर् नहीं भगबान होता है ।।
धन्यबाद गुरूजी ।।😊😊❤️❤️
Ase Gazab k teachers aaj tak nahi dekha amazing your comic timing & teaching style just wow 👏🙏❤️😊
Love you baby
शानदार । बहुत ही सुन्दर। कोई भी नया व्यक्ति जिसको डाटा एंट्री का ABCD भी नही मालूम वो इस वीडियो को देख कर आसानी से सिख सकता है।
आपकी मेहनत को सैल्यूट है।
धन्यवाद ।
Aapka comment bahut important raha..thank you👍
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
How make this
L
L
Thank you so much it's so helpful
Thank you dear
Sir i am watching your video from Bangladesh and I like your video very much. 🥰🥰🥰🥰🥰🥰
ଧନ୍ୟବାଦ ଗୁରୁଜୀ, ମୋ ପାଇଁ ବିଶେଷ ସାହାଯ୍ୟକାରୀ ହେଇଛି ଏହି ଭିଡ଼ିଓ....
ଆପଣ ବହୁତ ସୁନ୍ଦର, ବୋଧଗମ୍ୟ ଭାବରେ ପଡ଼ଉଛନ୍ତି l
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🙏🙏🙏🙏🙏
Super se upper phli bar itta detail se excel smjh aya thnq so much sir🎉
Bahut achha sikhaya hai aapne sir
😊
बहुत अच्छा Explain tarika excellent
Data entry mujhe pahli baar samjh aaya vo bhi itne interesting tarike se .... thanks 🥰😍👌🏻👌🏻good job sir 🥰
मा कसम आज तक से ऐसा वीडियो नहीं देखा हु जिसमे भाईया सभी doubt को आसानी से बता दिया है...। ओर हसी तो इतनी आ रही है ...जिसमे सिखने मे बहुत मजा आ रहा है...धन्यवाद भाईया जी...।🙏
Sahi mein
Aap kaha se ho
Bhut hi achchi vidio sir main yesi vidio bhut din se dhud rhi thi thanks sir
Superb teaching sir i have gain lot of knowledge for ky future thanks a lot hats off💓
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.
I love y aap mara teacher ho Main na ms office ki videos deakh ka hi seakha tha
Maine bhi sir se sikha hai
@@DarkHeaven99 very good Bro
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
Amazing teaching and hat's off you sir 🎉🎉🎉🎉🎉
Very impressive.
Bahut hi majedar tarike se explain our sikhate hn..
Amazing
Thank you sir.🙏🙏🙏
Fan ❤️ ho gya 👍👍👍
Full course h ky bhai ye ???? ❤️
Learn with 😊 fun excellent 👍
बहुत ही रोचक एवं सरल तरीके से excell समझाया गया है👈
आपका बहुत-बहुत धन्यवाद🙏💕
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
Jigneshji, very nice tutorial
No other youtuber can explain like you.. you provides us every small to big details...I am your biggest fan
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. ♥️♥️♥️
Wow sir aap bahut achhe se samjhate hai aap ka teching mujhe bahut badhiya laga.nice🙋🙋
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😊😍
All of us should learn from you how to teach beginners. Excellent explanation with demo.
Thanks in advance for making next videos.
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 💯
Excellent sir so very best explain
Thank you Sir For teaching Data Entry in easy Word 😇🙏
Thanks you so much dear Sir,,,,,, have learnt a little from you ❤️❤️.
Your teaching style is really very nice sir I liked it.thanks a lot. Continue to provide your intelligence among us.
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)
Ye kya hai koi samjha sakta h..... Avi mai new new learn kr rhi hu
@@meghakumari7241 shortcut keys
You are right.
Ui iki
9
Maza aa gaya Excel padh ke...
Thank you so much sir ❤🎉
Sahi mein bhai
Aap kaha se ho
सीधी बात नो बकवास 🙏👍👍👍
Great video sir
👍
Sir your teaching style is amazing
I like it 😊
Hello
@@raushan121kumar5 hye
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.
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 😅😅
Thank you sir you are great for teaching us online 😊❤😍😍😘
Amazing ☀️☀️
Don't explain by words
Thank u sir for this information
Learning with comedy 😂 very good sir thanks for videos, comedy ke wajah se bore nahi hota😃😜
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.
Sir bhut helpful video hia thank you so much sir ❤ji
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 🙏🙏
honestly same here , i learnt a lot from this video
Hloo
I am your paid courses subscriber.
I am glad to watch this video .
Thank you........ So much for making this video.
God bless you sir ....
You are amazing teacher in the world this is my thoughts about you.
Thanks you...
Regards,
Rohit Jha.
Excell Training, Use vide numbers in any form and invoives.
czcams.com/video/nUp5nYHnSUY/video.html
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
Sir your teaching style is very fantastic ❤❤
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.
Ur desire and dedication to learn the people is really appreciable, 👌, awesome....u explain al the smallest things...that is really helpful for us...
Sir apke Shri charno me koti koti parnaam
Tq sir mujhe aapka section bahut achcha Laga bahut kuchh sikhane ke liye Mila
very interesting and helpful style of teaching, very easy to pick. In this field you are always a winner.
No one can be as much good teacher as he is mind-blowing
Thank you sir ap ne bhout ache se smjaya 🙏😍😍
Sir, Satish - Great man great knowledge. Serving Humanity and community with wonderful teaching style. God bless you
I am your first viewer.
Inam chahiye kya
You deserve lots of compliments for providing such a nice information in a very simple way. your teaching style requires a special compliments
अच्छा 🙄
bahut achhe se aapne har point btaya smjhaya 👌👌👍👍😊😊😊💪💪🇮🇳🇮🇳🇮🇳
जय सरस्वती माँ 🙏❤
Jai shree Ram ❤️❤
Sir आपके जैसा गुरु मिलना मुश्किल है क्योंकि आपके पढ़ाने का अंदाज़ बहुत अलग हैं
आपके 1 घंटे का वीडियो को जब देखते हैं तो पता हीं नहीं चलता है की समय कब निकल गया
Thank you so much sir
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 👍👍👍👍
hey! you got the job ? please reply.....
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❤❤❤❤
Loved the way you explained, thank you
With regards, I can only say that you are an unique teacher. Hats off to you.
Bohut kuch sikhane ko Mila sir is vido se
Thank you soo much sir
Vry informative 👍👍
Most welcome
Elaborated explanation is given to follow even by uneducated people in Excel..
2saal pehle ka video 2024 me dekh rahe😂
To kya hua Bhai 😅
Bhaut khub sir
ग़ज़ब है आपका पढ़ाने का तरीका... मज़ा आ रहा है सर.... Salute आपको
wooww!!! it's soo interesting and I'm loving it....
Thankyou sir... apka Video bahut hi helpful hai...
🙏🙏
Thank you so much sir it's video 😊❤
This mam deserves many more likes and subscribers... Everybody please❤
Thank you sir aap bahut acche se samajhte hai 🙏🙏🙏🙏🙏
Very informative session nice
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
Sir very interesting video salute sir ji 🙋♂️
Hame Inka video se bahut kuchh Sikh. Chuka hu ye bahut bariki se samjhate h or samajh me bhi aata h bahut bahut dhanyavad sir ❤
Wooooo.. thank you so much sir for this knowledgeble video
Good information & brilliant explaining style💞🇵🇰
BHUT ACHE SE AAPNE EXCEL SMJHAYA HAI, THANK YOU SO MUCH SIR.
Sir aap bahot achhe se samjha ke bhi hssa lete hai jisse hsi or yzan dono ka anand utha lete hai hm thank you sir ❤
MashaAllah Sir I learn much more in a short period of time from your vedio.
Thanks
Same here Nani jaan
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..❤️😊
Hiiiiii
Tq so much sir
Ravi yadav
Super video hai I'm so happy ❤ se thank you sir
Sir dil se sikhate hai...mja aata h
Satish Sir Zindabad !!!!!!!! All rounder sir.....Stay always blessed.... teaching styles,tactics all are okey.
App ka video dekh ke bahut accha laga sir me aesa video kabhi nahi dhekha thank sir
Thankyou so much sir 🙏❤app bhut ache ho👍🏻
Bas yahi job pkadni hai ab. Sab seekh liya mene 😁 thank you ,you rock 😄😃😃😁😁
Hii urmi number dena apna
@@Dakshchauhan-zk3md 😂😂
Mai v bs 1 hr ki class me sikh li 😅😂
Maine toh seekh liya h bas typing speed increase karni h jisse interview crack ho jaye..
@@saritasaru9136 hi
I AM SO IMPRESSED FROM YOUR TEACHING
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.....♥️
Your teaching procedure is very fair &good. Thanks
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
Dost being an Engineer, i just randomly started your video, got good tips and you are superb tutor.