Practical use of Excel Formulas on company Data
ฝัง
- เผยแพร่เมื่อ 22 ต.ค. 2024
- Practical use of Excel Formulas on company Data in this video you will Excel Vlookup and choose formula combination.
Learn Satish Sir courses with Certificate
Download Course App : bit.ly/3BWfQVa
Course Website :bit.ly/skill_c...
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/
------------------------------------------------------------------------------------------------------------------------------
Check our latest blogs: learnmoreindia...
------------------------------------------------------------------------------------------------------------------------------
Social media Pages:
Facebook Page Link: bit.ly/3CvGlBT
Instagram Page Link: bit.ly/3f9R37u
Telegram channel: telegram.me/le...
------------------------------------------------------------------------------------------------------------------------------
My Other Channels:
Real Tutorial: ✅
/ @realtutorial550
Complete Technology:✅
/ @completetechnology
Learn more shorts:✅
/ @learnmoreshorts
Satish Tech (Marathi):✅
/ @satish_tech
Tally Tutorial:✅
/ @tallytutorial
Excel Tutorial:✅
/ @excel_tutorial
Learn More:✅
/ @learn_more
Curiosity: ✅
/ @curiosity9432
------------------------------------------------------------------------------------------------------------------------------
My TH-cam Gears :
Best Mic for Recording (Condensor 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
Course 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/
Bhau satish me ky mhtla , excel cha channel ahe tithech excel che videos taka na , daha wela satara wela ekdlya tikde an tikdlya ekde karawe lgte.
Sir ham pay order kar diye hai but kuch pata nahi chal raha hai
Maine apka excel aur ms word ka video dekha sir aur bahut kuchh sikhne ko mila mera name Varun hai aur mai UP se hu apka hi video dekh ke sikha aur aaj mai South Africa me job kar rha hu as office Assistant post thank you so much and please mentioned this story in your videos so other people must watch your video and learn
Tk sir you're doing good 😊 make a vidio on top 50or 100 useful and important excel powerful formula. like top 31 powerful formula once gain thanks 👍
you are awesome teacher i always find your videos when i want to learn excel
Your teaching style never bore us. Thanks for this
Very nice Dear brother. I have been learning from you a lot. May God bless you.
God has sent you to teach the people and you are doing your duty.
Thanks a lot brother! Thanks a lot.
Sir, Kamal ka lecture. Thanks
Satish Bhai aap accha samjate ho formulas, appreciated
Thank you sirji!! I love you Teaching style. Very easily able to understand the concept.
Thank u so much sir.. Aap bahut achche se or pyar se samjhate hai jisse jaldi samajh me aa jata hai..
Or baaki sab lutth leke bethe hai😂😂😂
Aap ka samjhane ka tarika bahut jada high hai
Thank you ❤
In this scenario, we can also use index,indirect functions etc .😊
Dear sir
Mai aapke video dekh karr "MIS " executive interview pass kar liya hai and now working me hu thank you so much
Great 😊
Sir aap bahut mehnat karte ho समझाने ke liye thanks
Sir, aapka videos bhahut use full hai lekin yen vinthi hai aapse ki aap 1) Audit
2) Account pe yek videos banado
Thank you sir for choose formula
Great sir 👌
Sabse best channel innozant for learn to excel in hindi
Sir koi online earnings par video banaen ap ki boht achi samj ATI ha hum ny ap sy boht Sikha ha you are best teacher
Fantastic teaching sir, also help as unable to download the practice file
Great Sir..
Thanks sir video ke liye🎉
very good sir
Thanks Sir🎉
Sir I like the way u teach
Thank you sir
Knowledge able video 👍💝💕❤️💗
Thank you bhai for this valuable information.. 👍👍👍
We can use xloop insted of vlookup
Thankyou sir🙏👍
Thanks
Namaste sirji...... 🙏
like it. Can we do it in power query also?
Gajab Sajid Bhai
Sir date and emp name combine karke vlookup se hi Sakta hai 👍
No need to use choose formula
Hello Satish sir please BIOS installation per bhi ek video banaaiye please sir
Nice
Cant we use Index match instead ??
yahi INDEX and MATCH se bhi kiya ja sakta hain....
=INDEX(attendance_status,MATCH($B4&C$3,CHOOSE({1},Emp_name&Attendance_date),0))
I also have one query related to pivot table on company data
Ye formula kya google sheet mai bhi aply hoga sir plz reply me
Brilliant sir
Sir kal mera MIS ka interview tha
Mujhse same yhi query puchi gai thi
Sir aap Microsoft power bi pr video bano
First of all thank you sir for this video but I have a little query agar mujhe kisi particular date me kitne logo ne payment ki vo count karna ho to konse formula ka use Kia ja sakta hai plz reply
i think y to count formula se ho skta h shayad.
Awesome
Thanks you Bhai
Pls provide the practice sheet in description
Sir please Ek web design basic to advance course ka video banaye
Sir ap please top 10 websites per videos banaye
Nice trick
Sir please reply mujhe cool kam krna hai computer operator ka kya kaam krna hoga vaha. Please
Sir Tally Prime ka pura basic se advanced level Tak please provide kijiye
Sir data analysis ka kab video ayega
Sir ADCA course karne par mahine ka kitana salary mil sakte hai
Very easy tricks
Hello sir, Hello sir,
Sir mujhe stock ki master list banani hai Excel me. Hamare yahan Welding electrodes aati hai, 2MM, 3MM, 4MM & 5MM ki. Ye electrodes dusre department se issue hoke hamare pass harr hafte aati hai. Hum candidates ko harr MM ki electrodes issue karke dete hai welding ke liye daily bases pe. Mujhe sheet banani hai Kitni hum other department se electrodes issue kar rahe hai aur hum kitni candidates ko de rahe hai. Kitne received ki hai aur kitni department se le rahe hai. Kitni hamne candidates ko issue Kari aur kitni kharch ki. daily basses pe aur kitni balance total reh gayi. Master balance list kaise banaun with formulas. Sir mujhe sheet kaise banani hai with formula aur kaunsa formula use hoga. Plz help me.
Nice video Sathish bhai 👍
Superb...
I M WORKING IN A TO H COLLUM ONLY......THAN HOW CAN I GO TO NEXT ROW , USING TAB BUTTON DIRECTLY
Where is the practice file sir...u said it is in description
Hello I also face a big problem plz help me this I don't no which formula can help me with this
My problem: I have date, name, job post, c.v, status total 5 colum data and i want to make mis report on them do u know how to calculate repet name(c.v) in particular date plz help me this and one last I have 4 deferent job post I want to see which post give me best results and I want to apply filter on this colum as well as so which formula can help me on this situation thank u for Reading this comment sir
This datasheet query can easily solved by Google sheets and Excel pivot table. No need to make long solutions.
For short tricks follow my youtube Channel - Chalega nahi Daudega
Concatenate
👌👌👌
Good luck 😸
How can I pay from US.
Sir Gr M Numbericl Me 20000000 Likhu R Wo 2cr ho jye iske liye kons formul use hoga
Sir g ab ek video print pa be bano.. Data enter sub tk ho jata ha bs print ma problem ati hai pura complete data print ma ek page pa ni ata. Plz help
Hello sir, i am in trouble can u help me , actually i am unable to unhide coumn A1 in my file, i m using A1 in name box and then in format menu unhide column , but it is not working , do you know another way, please help me sir
Sir I want to buy excel course
Which website would be preferable
Course pe or Skill ?
Skill
www.youtube.com/@user-io3rz7by2g
Sir is their any way to contact u??
Sir please Power bi ka totorial start karo
🙂 very 🙂 nice 🙂 video
🙂 very 🙂 nice 🙂 information 🙂 ℹ️ℹ️
👍
i am not able to use this file, please attach this practice file here only as before files 31 formulas and 15 vlookup formulas.
Advance excel ka fees kya h
Sir fab ke month mai 31 days nhi hote
Not able to find excel practice file. Pls help me to download
Sir pdf file se pivot table kaise banaye
ye file to mobile me download ho payi hai mobile me practice krna mushkil h, laptop me kaise download kare ye file please attach directly as earlier files.
sir whre is the practice file
Sir main ne aap download Kiya Hai aap aap ka but muje dout hai
Sir aap ki aawaz thode daa rahi hai , Mike thoda upar set kare 🙏🙏🇮🇳
Sir please practice file
1 formula ki kaunsa use krna baki sare formula's pe bhi banaye fir chahe 15hr kyun na video ho jaye sab formula pr aise video banaye ki Data dekh kr kaunsa formula apply krna hai.
Jai shree ram.... Jai shree hanuman baba... 🚩🚩🚩🚩🚩🌸🌸🌸🌸🌸🍎🍎🍎🍎🍎
Sir mujhe duplicate entry me result kaise laye
Aap log sir video kaise banate h
Plz I want to talk to you about course
www.youtube.com/@user-io3rz7by2g
Sur file nhi hai description me ye wali
Maine ADCA k liye bola tha sir aap logo se mujhe emi par available karwaa dijiye sir garib ka madad ho jayega lekin aap log nahi kiye. Sir 😔😔😔😔
Practice file download nhi ho rhi h aap se
excel cell a2
where is practice file
I am from Pakistan
Sir, pata ni ku ni lag raha mera formula
I can share you a practical problem.
app se accha website upload karo
mera q ans. (NA) q aa raha hai first attempt m he
This formula is not working on desktop
Sir yeah formula pura Kam Nahin kar raha hai kuch Jagah per #N/A Dikhai de raha hai😞