- 193
- 80 564
Excel Mentor
India
เข้าร่วมเมื่อ 14 มี.ค. 2022
Hi i am mo shazad founder of exel mentor excel learning channel. this chnnel provide you microsoft excel related learning video for beginners and advanced level. this chhannel create for advance excel project with vba. i will start vba form basic level to advance level with advance projects. if you are interested in excel and vba and you want to learn advance vba for advance project so watch all video of this channel " Excel Mentor". this channel created date is 15 March 2022. i requested to all our viewers please support us with like video and susbscribe the channel. if you have any question so please comment i will study your comment question and share that solution in upcoming video. Thank you and Love you to all Excel Mentor Viewers ( family member)
Advance use of filter function for filter department wise data from raw data dont miss #exceladvance
Hello Friends!
aap sabhi ka aapke apne youtube channel excel mentor par most welcome.
is video me main aapko step by step in detail bataunga ki aap kaise excel ke filter formula ka advance use kar ke ghanto ka kaam minutes me kar sakte hai.
is example me mere paas multiple employee hai jo alag alag departments se hai and mera task hai ki mujhe 1 minute me sabhi employees ko alag alag department ke column me lekar aana hai to kaise karenge ye task jaan lete hai so lets start right now.
Download Practice File
---------------------------------------
drive.usercontent.google.com/u/0/uc?id=1-0yVFGK8aELBWaGauwKOdD1Hu-TTmeTn&export=download
FAQ...?
----------------
Advance use of filter function,
how to use filter function in excel,
excel me advance function kaise use karte hai,
advance filter in excel,
filter formula kaise use karte hai,
use of filter function in excel,
use of filter function in excel,
filter function ka use kaise karte hai excel me,
filter function use in excel,
advance use of filter function in excel,
advance excel in hindi,
excel advance in hindi,
excel tutorial in hindi,
excel tutorial for beginners,
beginners excel tutorial in hindi,
excel filter function,
excel filter formula in hindi
#advanceexcel #exceladvance #excel #filterinexcel
#filterformulainexcel #excel_filter_formula #excel_filter_function
#function_filter_excel #exceltutorial #excelmentor
----------------------------------------------------------------------------
For Business Cont :- help.excelmentor @gmail.com
----------------------------------------------------------------------------
Follow on:
-----------------------------------------------------------------------------
☑ Instagram : instagram.com/
☑ Telegram : t.me/
☑ Twitter :
☑ Like FB page :
☑ Join FB Group : groups/
-----------------------------------------------------------------------------
🙏Disclaimer- Some contents are used for educational purposes under fair use. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational, or personal use tips the balance in favor of fair use. All credit for copyright materiel used in video goes to a respected owner. 🎓
----------------------------------------------------------------------------
aap sabhi ka aapke apne youtube channel excel mentor par most welcome.
is video me main aapko step by step in detail bataunga ki aap kaise excel ke filter formula ka advance use kar ke ghanto ka kaam minutes me kar sakte hai.
is example me mere paas multiple employee hai jo alag alag departments se hai and mera task hai ki mujhe 1 minute me sabhi employees ko alag alag department ke column me lekar aana hai to kaise karenge ye task jaan lete hai so lets start right now.
Download Practice File
---------------------------------------
drive.usercontent.google.com/u/0/uc?id=1-0yVFGK8aELBWaGauwKOdD1Hu-TTmeTn&export=download
FAQ...?
----------------
Advance use of filter function,
how to use filter function in excel,
excel me advance function kaise use karte hai,
advance filter in excel,
filter formula kaise use karte hai,
use of filter function in excel,
use of filter function in excel,
filter function ka use kaise karte hai excel me,
filter function use in excel,
advance use of filter function in excel,
advance excel in hindi,
excel advance in hindi,
excel tutorial in hindi,
excel tutorial for beginners,
beginners excel tutorial in hindi,
excel filter function,
excel filter formula in hindi
#advanceexcel #exceladvance #excel #filterinexcel
#filterformulainexcel #excel_filter_formula #excel_filter_function
#function_filter_excel #exceltutorial #excelmentor
----------------------------------------------------------------------------
For Business Cont :- help.excelmentor @gmail.com
----------------------------------------------------------------------------
Follow on:
-----------------------------------------------------------------------------
☑ Instagram : instagram.com/
☑ Telegram : t.me/
☑ Twitter :
☑ Like FB page :
☑ Join FB Group : groups/
-----------------------------------------------------------------------------
🙏Disclaimer- Some contents are used for educational purposes under fair use. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational, or personal use tips the balance in favor of fair use. All credit for copyright materiel used in video goes to a respected owner. 🎓
----------------------------------------------------------------------------
มุมมอง: 12
วีดีโอ
#Advanceexcel How to get number of days in month using month name only #excelTricks
มุมมอง 3019 ชั่วโมงที่ผ่านมา
Hello Friends, aap sabhi ka aapke apne youtube channel excel mentor par most welcome. aaj ke is video me main aapko step by step in detail bataunga ki aap kaise month ke naam like january or jan ka use ke us month me total kitne din hote hai ye pata kar sakte hai. is method me hum 2 formulas ka use karnege 01. day, 02. eomonth, in dono formulas ki help se hum only month ke naam se us month me t...
How to fix #value error in excel top 2 methods #advanceexcel
มุมมอง 132 ชั่วโมงที่ผ่านมา
Hello Friends! aaj ke is video me main aapko step by step detail me bataunga ki aap kaise excel me #value error ko fix kar sakte hai. yah error tab aata hai jab hum aisi values me mathematical calculations karte hai jinme se koi ya sabhi values numeric nahi hoti hai. agar aap ke saamne bhi aisi condition hai ki jab aap kuch values ke beech calculation karte hai jinki vajah se #value error aa ra...
How to create a single table by using multiple table in excel #advanceexcel
มุมมอง 792 ชั่วโมงที่ผ่านมา
Hello Guys! aaj ke is video me main aapko step by step detail me batane wala hu ki aap kaise excel ki multiple tables ka use kar ke ek single table kaise create kar sakte hai. agar aapke paas same headaings or headers ki multiple tables hai and unko aap single table me convert karna chahte hai to kaise kare is video me detail me bataya gaya hai FAQ...? how to convert multiple table into one tab...
Multiplication with item quantity and amount with alphabetical units and amount #advanceexcel
มุมมอง 1744 ชั่วโมงที่ผ่านมา
aaj ke is video me main aapko ek best trick batane wala hum aaj hum is video me step by step janege ki agar hume kisi column me koi value text or uski unit ke saath show karni ho end us column ka use kar ke koi calculation bhi karni ho to wo excel me kaise possible hai. is example me ek column me qnty pcs me and amount with Rs. text jo ek unit hai ke saath diya hua hai jab hum in dono colum ki ...
How to transpose data in excel column to row and row to column data kaise karte hai ? #advanceexcel
มุมมอง 334 ชั่วโมงที่ผ่านมา
Hello Guys! aaj ke is video me main aapko step by step detail me bataunga ki aap kaise excel me data ko transpose kar sakte hai mean agar aap column ki valuse ko row me and row ki values ko column me transpose karna chahte hai to uske two methods me aapko yaha par bataunga ek normal copy paste or paste special se and doosra excel ke transpose function se to chaliye dono ko detail me samajh lete...
How to use slicer in pivot table | what is slicer in pivot table ? #advanceexcel
มุมมอง 457 ชั่วโมงที่ผ่านมา
Hello Guys! In this video, I will tell you in step by step detail how you can use Slicer in Pivot Table and also you will know what is Slicer and what is the function of Slicer in Pivot Table. Slicer works like a filter, just like we can filter data by applying multiple filters in a table, slicer also works in the same way, specifically in any table or pivot table, data can be filtered by using...
Autofit column width in pivot table | autofit column width disable in pivot table #advanceexcel
มุมมอง 1327 ชั่วโมงที่ผ่านมา
Autofit column width in pivot table | autofit column width disable in pivot table #advanceexcel
How to merge cells in pivot table | merge cells in pivot table #advanceexcel
มุมมอง 189 ชั่วโมงที่ผ่านมา
How to merge cells in pivot table | merge cells in pivot table #advanceexcel
How to create pivot table report using multiple worksheets #advanceexcel 🔥
มุมมอง 119 ชั่วโมงที่ผ่านมา
How to create pivot table report using multiple worksheets #advanceexcel 🔥
How to convert pivot table to normal table | unpivot table in excel #advanceexcel
มุมมอง 18312 ชั่วโมงที่ผ่านมา
How to convert pivot table to normal table | unpivot table in excel #advanceexcel
Age grouping in pivot table | number grouping in pivot table
มุมมอง 2812 ชั่วโมงที่ผ่านมา
Age grouping in pivot table | number grouping in pivot table
How to show or hide expand and collapse button in pivot table पाइवोट टेबल में expand collapse बटन कै
มุมมอง 2714 ชั่วโมงที่ผ่านมา
How to show or hide expand and collapse button in pivot table पाइवोट टेबल में expand collapse बटन कै
How to delete pivot table in excel pivot table कैसे डिलीट करते है
มุมมอง 1114 ชั่วโมงที่ผ่านมา
How to delete pivot table in excel pivot table कैसे डिलीट करते है
Filter types in pivot table | filter data in pivot table [2024] #advanceexcel
มุมมอง 9216 ชั่วโมงที่ผ่านมา
Filter types in pivot table | filter data in pivot table [2024] #advanceexcel
How to make group in pivot table | fields group in pivot table | items group in pivot table 🔥
มุมมอง 3716 ชั่วโมงที่ผ่านมา
How to make group in pivot table | fields group in pivot table | items group in pivot table 🔥
How to use formula in pivot table Pivot table me formula kaise use karte hai
มุมมอง 3419 ชั่วโมงที่ผ่านมา
How to use formula in pivot table Pivot table me formula kaise use karte hai
Pivot table dynamic range | Pivot table range auto Update | Dynamic pivot table🔥🤔
มุมมอง 5919 ชั่วโมงที่ผ่านมา
Pivot table dynamic range | Pivot table range auto Update | Dynamic pivot table🔥🤔
How to show grand total in pivot table | hide grand total from row and column
มุมมอง 1321 ชั่วโมงที่ผ่านมา
How to show grand total in pivot table | hide grand total from row and column
[2024] Day, Month, Quarter, Year wise grouping in pivot table in hindi 👌
มุมมอง 2721 ชั่วโมงที่ผ่านมา
[2024] Day, Month, Quarter, Year wise grouping in pivot table in hindi 👌
How to fill blank cell in pivot table | fill empty cell in pivot table - 2024 #advancepivottable
มุมมอง 64วันที่ผ่านมา
How to fill blank cell in pivot table | fill empty cell in pivot table - 2024 #advancepivottable
How to delete calculated field or itme in pivot table #advanceexcel 🔥
มุมมอง 8วันที่ผ่านมา
How to delete calculated field or itme in pivot table #advanceexcel 🔥
How to calculate percentage in pivot table in hindi | calculated field calculate percentage
มุมมอง 76วันที่ผ่านมา
How to calculate percentage in pivot table in hindi | calculated field calculate percentage
How to add row in pivot table | insert calculated item in pivot table 🔥🔥#advanceexcel
มุมมอง 35วันที่ผ่านมา
How to add row in pivot table | insert calculated item in pivot table 🔥🔥#advanceexcel
How to remove blank rows in pivot table excel | blank rows remove pivot table [2024]💞💞
มุมมอง 38วันที่ผ่านมา
How to remove blank rows in pivot table excel | blank rows remove pivot table [2024]💞💞
How to apply filter on all fields of pivot table | 95% नहीं जानते है
มุมมอง 22วันที่ผ่านมา
How to apply filter on all fields of pivot table | 95% नहीं जानते है
How to add column in pivot table in excel | can we add field in excel pivot table ? [2024 ] #excel
มุมมอง 61วันที่ผ่านมา
How to add column in pivot table in excel | can we add field in excel pivot table ? [2024 ] #excel
Generat excel practice content in just 2 minutes | Large data ready in just 2 min for practice
มุมมอง 8228 วันที่ผ่านมา
Generat excel practice content in just 2 minutes | Large data ready in just 2 min for practice
How to change selection direction when press enter key excel advance trick you should know
มุมมอง 32หลายเดือนก่อน
How to change selection direction when press enter key excel advance trick you should know
Dynamic Dashboard in Excel with Progressive chart | Advance excel prograssive chart no VBA
มุมมอง 84หลายเดือนก่อน
Dynamic Dashboard in Excel with Progressive chart | Advance excel prograssive chart no VBA
Nice tip sir
Nice
Make more videos
yes sir i will upload multiple video daily thanks
Nice
It is better given the excel file for practising
ok aage se sabhi lectures ke description me aapko practice file provide kee jaaegi thanks
Link is not allowing to download 😪
Hlookup se bhi easaly nikal sakte hai.
awesome video 👍👍
Nicely shown! Thanks
Mera Google sheet mai Protect ka option nahi a rha hai sir😢
Bhai 1 hi page me hona chahiye
Nice video❤❤❤
where is the file ????
Nice video
Thank you sir
how to download thel ink
dicription hi nahi
Not telling password protection. We need a protection from users who shares our system or shares same account like in office id. This guy wasted my time
Thanx ☺️
File hai kidhar😂
unfollow this channel, this guy misleading to others
💥 'Promosm'
File upload kar dijiye
Why i cant find Protect option on my google spreadsheet how to fix this anyone?
How to convert 1.575 KWD
Different programing for KWD
Very best teaching method..i understand properly..
Nice 👌
The way you make things understandable is incredible 😊
Nice sir
Thanks for Support
good
यदि रुपया और पैसे हो तो क्या करें?
wait sir i will upload a new video on your demand tomorrow mean 21-01-2024 wait
@@xlmentor can you suggest some good books on macros in excel.
Here How to omit the word "Rupees"
Very useful sir for me thank u
Are bhi lock 🔐 nahi karna, sidha password lagana he, hoga ki nai...?
Thank you sir
Sir , excel ki protected file watsup se bhejne pe unprotect ho jati hai, protect bnaye rkhne ki trick bataiye pls
Excellent Sir ❤
can we put password on the file itself so that no one can open the file like excel password seems.
where is the process of setting up the password ?
now to protect cell or range or sheet not working 😞
how to protect specific area in google sheet in latest version now
Sir मराठी कन्व्हर्ट कसे होईल
'promosm'
yes
😄funny video