How to Add 'Mr.' and 'Ms.' in Excel sheet 😎||Advance Excel 🔥|| #shorts #excel #exceltips #computer

How to Add "Mr." and "Ms." in Excel sheet 😎||Advance Excel 🔥|| #shorts #excel #exceltips #computer @Intellectuallearner

❤️❤️❤️If video is useful Plz liked it❤️❤️❤️
Your Quaries:-

excel formula hacks,
excel formula for job interview,
excel for fresher,
job skillshare,
job skill studio,
job skills for freshers,
job skills for students,
job skills & education,
job skills videos for special needs students, digital learning centre,
digital learning official,
digital learning course,
computer class,
computer basic knowledge in hindi class 1

#excelformulahacks #excelformulaforjobinterview #excelforfresher
#digitallearningtools
#digitallearningofficial
#digitallearningday
#computerlove
#computerclass
#computerclass1
#computernetworking
#jobskillsforstudents
#jobskillstraining
#jobskillsforfreshers
#jobskillsshare
#jobskillsvideos

_____🥰🥰 Thanks for watching 🥰🥰____

[jubayarahmed]

=IF(Gender="male", "Mr"&Name, "Female", "Ms"&Name) Enter

[rohit__g]

Sabse easy hai ki ek naam ekdum sahi tarah likh lo like " Mr. Akash" enter karo
Next cell mei ctrl+e kr doh sabka naam mei mr ke sath likh kar aa jayeg. Ab ctrl+ Shift+ l ko filter lagakr jo femake hai unka name select aa jayega koi bhi name mei mrs. Lagakr likh doh aur phir se dusre cell meo ctrl+e kr doh filtter ko remove Karo ho gya

[saptarshimozumdar]

good idea. I was thinking of adding filters and doing CONCATENATE, but this is better.

[TusharKantiDutta]

Mr. Ke baad ek space de dena

Baaki video bohot informative hai 😊

[Lifeevival]

Iss formulla ko yad rakhne ki trick be bata ab 😂

[enigmacore]

Can You Please Share How to Auto Complete Formula Name when Typing??? because I try all way but we must need to type it complusory, its only may be for SHOW

[luvsharma]

Make drop down menu with data validation option in data

[lovekibaat]

Bhai tera dost humesha galt fomula lgta aur tumhe hi challenge dera😮😂

[cutebaby-mkfx]

Bhai itna head kahe use kar rahe ho Flash fill seekh lo

[zmhussain]

Bhai if q lgaya switch lagta or asan tha

[punitsingla]

भाई क्या आप ispe एक वीडियो बना सकते हो ❓❓👇👇

मै excel मे gst return file बनाता हूं जिसमें पार्टी का नाम, gst nmbr, bill nmbr, total amt और cgst, sgst igst के अलग अलग colum बनाता हूं

तो मैं चाहता हूं कि मैं जब भी amount डालूँ तो GST नंबर (state wise) के hisaab से अपने आप CGST, SGST, या IGST calculate हो जाए

[TRGaming]

What if no gender column in input. There may be case when gender is not in input

[alokkumardas]

Han tah har Farmale thodi "Ms" hoti hai agar kuch Female me "Mrs" bhi hoti tah keise tum formula use karte ? 😂😅

[farhaparbin]

Mera toh kuch kaam nehi aaya... answer nehi aaya. Sab Miss hi aa gaya

[Hdearning]

Flash fill kro formula ki jarurat nhi padegi