excel interview questions and answers || excel formula hacks
Вставка
- Опубліковано 22 сер 2024
- excel interview questions and answers || excel formula hacks #shorts #youtubeshorts #viral
#shorts
#excelhacks
#exceltips
#excelmagictrick
#excelinterviewquestions
#ytshorts
#youtubeshorts
#dktech
#viralvideo
#iq
wwe
ashish chanchlani
punjabi songs
dynamo gaming
carryminati
pewdiepie
bb ki vines
t series
pubg
tom and jerry
emiway bantai
study iq
5 minute crafts
amit bhadana
stand up comedy
mumbiker nikhil
bts
tik tok
free fire
baby shark
Bhai sahab wages ke column pe bhi formula use kar sakte the, =if(B2='Sunday',"500","450"). Yeh aur easy ho jata plus formulated bhi rehta instead of manual.
Great 👍
Me yahi likhne wala tha but apne already likh diya 😅
😊
B2 nhi C5
@@MHanda0601 Buddy, formula enter toh c5 pe hi hoga but kis cell pe if wala formula wo maine likha hai. Yeh toh bacche ko bhi pata hota hai.
amazing example sir
This video can more then easy
Esme day name sunday ke samne 500 ne bijama 450 type karva ni su jarur hati...
D5 cell ma if formula lagadi devay...
=if(C5="Sunday", 500,450)
was a great but it can be more easy if we use IF formula
Yes every work has a multiple way to complete.
Thanks for your valuable feedback 🙂
=if(DAY="SUNDAY",500,450)
BHAI YE WAGES KA FORMULA HAI
👍
😊
Ek batt sach hai bhai agar appko private company me job chahye to appke pass computer skill honi chahaye aur appki kam karneka tarika kesa hai wo bhi matter karta agar app short cut key use karke achha kam karogai to company ka boss impress ho jayega 👍👍👍👍
Right 👍
Thanks Sir
🤗
thanks you sir
We
Its working 🤗
Thanks
Amazing trick👍
Thanks 😊
Use if formula in wages 😊
sir if function lga kr wages bhi kr skte the jada easy hota
Yes, ek Kam ko hum alg-alg trike se kr skte h
Amazing trick of excel
Sir your videos very useful..🥰🙏
Thanks 😊
If ka formula sy aagy value b dal skta hy
Speed thoda kam hai. Increase your speed.sothst every body can understand. Palthu
amazing
Thanks 😊
Super
Thanks
आप थोड़ा और सीखो , प्रत्येक संडे में 500 लिखने की जरूरत नहीं है
Example- = If(c5="Sunday",500,400)
Okay 👍
Bhai wages me if function bhi to lga sakte hai
Yes 👍
If function be like to me job chorh du 😂
Super tricks 🤣
Ye thida long time hogaya
500 wages likhna
Kya hai ye bhai 😂😂😂 long data hoga fir to if use krna padega 😮
Yes, is video me normally day name count Krna btaya h 😊
Sir salary sheet aur employee attendance per ek video bnaye
ua-cam.com/video/5x3mWiQKctc/v-deo.html
Pl watch
Kya isme hum esa kar skte hai
F1 press karke custom me jakar general ko hata kar dddd type kare to kya same result a jayega ya ni
Nhi
Bhai sikha to accha rahe ho
But 1 question ka interview kon leta he
Bhai questions to bhot sare hote h but, short video me (59 second) me ek question hi solve ho pata h
Baki or jyada information ke liye aap long videos dekhe
bhut bdya
Thxs
Mera nahi aa raha hai
Aap Jese video me h vese shi se try kriye honjayega
use if formula instead
Super tricks
Bhai isme type karna jaruri tha kya usme if formula nahi lga sakte the kya
Iske liye aap filter option use kre use apko kewal ek bar type krna pdega
Simple you can use nested if
If there lots of data
Without manually 👍
@@excelmaster1328 Great
Sir wages apne aap se sunday ko 500 ho jaye to kya kre agar bht bda data hoga to
Iske liye app ye trick use kre same :
ua-cam.com/users/shorts9no1Ty7aRik?feature=share
Or bhi informative trick ke liye hmare channel ke long videos watch kre or share kre
mene seekhna h mjhe complete kam sikhaa dein .. r yh btaa dein k yh seekh k mein ghr beth k fone sy yaha kam kr skti hu ? reply me must .. I m new here
Aap is channel par complete excel(basic to advance level) free me sikh skte h jo ki sabhi office me use hone wali ek common skill h.
Offline aap apne nearest hospital, school, companies me bhi job krenge to apko excel aana bhot jruri h. 😊
@@DKTECH thnxx
Welcome 😊
sir hum chahte to filter lagar k Monday select karke sab Monday par ek sath amount likh sakte h
Ha , smart trick 🤓
If we have 365 days then is there any formula to seperate the amount of 500 and 450
It can be done through condition formatting
Mene Jo date ka formula lagaya usme same date me Sunday aa rha or apke date me alag day aa rha
day to same hi aana chahiye
Aap kis date ki bat kr rhe h
What is that meaning "dddd" four times you have given (why exactly 4)
dddd is a format which represents date/day name
I have a 3 image can you say please how can i convat image to excel plz🙏🙏🙏
Yes we can easily convert any image to excel.
Simply search ,jpg to excel on Google and use any website then upload your image and click on convert
The excel file will be downloaded
online2pdf.com
online2pdf.com › ...
Convert JPG to EXCEL online & free
How to add 0 in excel plzz video
Pls explore your query..
@@DKTECH sir excel Mai 0 add nahi Hota remove hojata hai
Bhai ye formula kha se aaya ye batao kaha milege
Tmhare nanihal me ye formula milega😅😂😂😂😂😂😂
@@aaryamariya9676 backwash km ker or shi bata
Pls don't use this type joke
Button dabate hue keyboard bhi sath mein dikhave
Accha g
@@DKTECH or virtual keyboard ki png add karskte ho aap👍
Or ye png automatically screen pe aajayegi ek software aata hai use kar sakte ho
Thanks
sir agar data long hota to wo to likhta hi reh jata sir...
Uske liye aap day column me filter option use kre or pehle Sunday ko show krke 500 likh kr Ctrl+enter use kre
Or fir other days ka
Isse hajaro entry ka data 1 minute se km me type ho jayega
Dates toh dekho 😂😂
Date me kya hua
yeh 4 bar d kiyn type kia?
Ye formula h isliye isme change nhi kr skte ho format h vhi use Krna pdta h
sir advanced Excel ki salary kya e
Average 15 to 20 k
Sir date idhar udhar aya
Shi aya hoga bs date me mahina ya date aage piche ho gai hogi jese
DD/mm/yy ya mm/DD/yy
Huh?
Sir main urban development vibhag me kam karta accountant ki post pe mujhe safai karmachariyon ka salry bana hota hai jisme 03 excel sheet hai aur mi chata hu jo data main sheet 1 pe type karu wo automatically sheet 3 pe update ho jaye kaisey kru help
Sir thanks for contacting with us and very unique question.
iske liye aapko sheet 1 ke data ko other sheet me formula "=" use krke create Krna pdega uske bad AP agr sheet 1 me value change krnge to usse automatic sheet 2'3 me value change ho jayega
ua-cam.com/video/3dxUCpVk7Wk/v-deo.html
Ye video se shyad apka issue solve ho jayega agr fir bhi koi query hoto comment kre
@@DKTECH sir sheet 1 ka data = krke sheet 3 pe krte h to 0 aata h
Sir reply please
Pls share your excel file and screenshot on email for better understanding 'kumardineshnp@gmail.com
Worng ha
How ?