Excel Interview Tips & Tricks | CountIF with Wildcard, Advanced SumProduct & LEN formulas in Tamil
HTML-код
- Опубликовано: 21 окт 2024
- Excel Interview Tips & Tricks | CountIF with Wildcard, SumProduct & Len
In most of the Excel related interviews, people struggle to face the questions the recruiter ask. Watching this video can take out the barriers in facing the Excel related interview, and you gain confidence in interviews. Do not skip this video, watch it till the end.
Topics covered:
CountIF with single Wildcard * in tamil
CountIF with double Wildcard ** in tamil
SumProduct in tamil
SumProduct with Length ( Len ) formula in tamil
Downloadable Practice Excel is available here:
drive.google.c...
#Interview_Questions
#SumProduct
#ExcelNewTips
#TamilNadu
Free downloadable practice files:
www.prabastech....
All Videos of Prabas MSOffice in Tamil - தமிழ்
• Unity of SumProduct, S...
VLOOKUP Excel Formula in Tamil - தமிழ்
• Learn VLOOKUP Excel Fu...
Excel Shortcuts in Tamil - தமிழ்
• The top Powerful and B...
Latest and Recent Features in Microsoft Office in Tamil - தமிழ்
• 3D Models with Morph T...
Functions / Formulas in Tamil - தமிழ்
• Unity of SumProduct, S...
Microsoft Excel Training in Tamil - தமிழ்
• Learn VLOOKUP Excel Fu...
SumProduct Excel Formula in Tamil - தமிழ்
• Unity of SumProduct, S...
Macro vba in Tamil - தமிழ்
• 1st GiveAway Appreciat...
Giveaway / gift to Subscribers in Tamil - தமிழ்
• 1st GiveAway Appreciat...
Power Query in Excel - Learn Power Query in Tamil - தமிழ்
• 1st GiveAway Appreciat...
Excel Hyperlink in Tamil - தமிழ்
• How to quickly copy pa...
How to use Name Manager in Excel in Tamil - தமிழ்
• The top Powerful and B...
Excel Tips in Tamil - தமிழ்
• Learn the top Excel Se...
How to Print Excel Sheets in Tamil - தமிழ்
• The top 5 Excel tips y...
"How To" in Tamil - தமிழ்
• How to Create a Clicka...
Must Learn Excel Logical Function - Latest Videos - in Tamil - தமிழ்
• Learn Logical Function...
Microsoft Word Training in Tamil - தமிழ்
• How to Create a Table ...
Error Bar in Excel Chart - தமிழ்
• Various Usages of Erro...
Excel Waterfall Chart in one Minute in Tamil - தமிழ்
• How to Create Waterfal...
Microsoft PowerPoint Training in Tamil - தமிழ்
• 3D Models with Morph T...
How to Create 3D Objects in PowerPoint in Tamil - தமிழ்
• How to Create 3D Objec...
Microsoft Office Tutorial in Tamil - தமிழ்
• Microsoft Office 2016 ...
Excel Chart in Tamil - தமிழ்
• Chart in Microsoft Off...
#MsofficeTamil
#ExcelTamil
#ExcelTipsTricks
#ExcelOnline
#ExcelTraining
#WordTraining
#PowerPointTraining
#PrabasMSOffice
#Prabastech.in
Hi praba,
Nice this video
Countif with combined sumproduct Len formula very nice I learn lot of this video
I don't know what formula use and how-to use that function how to define that formula.
Follow us for more useful videos like this.
Hi bro, in last scenario shall we get the country value only for alphabet letters only( special characters should not be included).pls advise
Possible brother.
Supeebbbbbb bro thank you very much do more videos and make it fast...
Super brother excellent
Super bro
Super explanation bro I am the new subscciber to your channel
Welcome to PrabasMsoffice. Keep following and learning.
@@Prabasmsoffice pls reply me.i have doubt in vlookup.If in case we select the table array in vlookup small table is easy select via mouse if in case there are 50 column and 35000 rows how to select the table array in vlookup.
well bro u r the world class master congratulation in excel......
Superb video prabas. Answer against questions explanation was nice....
Yes for quick understanding
I am practicing sir thank you
super good video
ama bro thanks it really helps a lot inum neraya E-xcel interview related videos podunga
Sure Madras Gamer, there are few more coming soon.
@@Prabasmsoffice oru small suggesstion mela cards ilana video kela excel interview quetions matum nenga already post pana video la irundhu filter pani link podunga na idhu varaikum unga videos 2-4 videos pathu irukan i learned a lot from those videos for my prepartion but still andha mari vera edachi potu irukengala n tu theriyala so apadi edachi already upload pani irundha link podunga my humble request
Most useful sir thank U
Please share this with your friends. Thanks.
Super Ji
Thanks Mojan Raju, for watching interview related question...
@@Prabasmsoffice *Mohan Raju😊
🙏
Very useful to count customer mail id's (domain)..Like gmail, yahoo, Hotmail, rediffmail etc.,
Pls clarify how to list it separately??
Here in this Formula, you could get one result. If you need a list of your required names, we have to do little more setps. I will take them later.
@@Prabasmsoffice Waiting for PART 2 of this video...!
Tq bro
Thanks for showing interest on watching learning videos.
In 3m 22 sec
Which Version Support Wildcards in Excel?
2003 or 2007 or 2010 or 2013 or 2016 or 2019
In 4m 23sec
"Anywhere " Spelling Mistake
I also do this kind of mistakes
How to fix that problem Can i use Automatic Spell Checking
Being a Digital Marketer I need this requirement spelling check highlighter in excel
It works almost in all versions of Excel.
It is good that you have changed your photo recently. You are so young now. Your old one was little different. Keep supporting brother.