![Abhijeetji Technical 4M](/img/default-banner.jpg)
- 762
- 17 452 220
Abhijeetji Technical 4M
India
Registrace 15. 11. 2020
Join our community of Excel enthusiasts as we explore the endless possibilities of this powerful tool. Whether you're crunching numbers for business analysis, organizing data for project management, or streamlining workflows for increased productivity, Excel Mastery equips you with the skills you need to excel in any task.
Stay updated with the latest features and updates from Microsoft Excel, and unlock hidden gems that will revolutionize the way you work with spreadsheets. Whether you're a student, professional, or entrepreneur, Excel Mastery empowers you to take your spreadsheet skills to new heights.
Subscribe now and embark on a journey to Excel Mastery. Unleash your spreadsheet superpowers and revolutionize the way you work with Excel!
For Business Enquiry
abhijeetpathakall23@gmail.com
Stay updated with the latest features and updates from Microsoft Excel, and unlock hidden gems that will revolutionize the way you work with spreadsheets. Whether you're a student, professional, or entrepreneur, Excel Mastery empowers you to take your spreadsheet skills to new heights.
Subscribe now and embark on a journey to Excel Mastery. Unleash your spreadsheet superpowers and revolutionize the way you work with Excel!
For Business Enquiry
abhijeetpathakall23@gmail.com
Match 2 Sheets/Workbook Data in Just 2 Minutes | Advanced Method to Match Data with Automation
Match 2 Sheets/Workbook Data in Just 2 Minutes | Advanced Method to Match Data with Automation
About Video
Namaskar Dosto aaj aap is video mein sikhne jara rahe agar aapke pas two excel sheets hai but data match nahi kar rahe hain to aap kaise two excel sheets ke data ko match karayenge or two alag alag workbooks ke data ko kaise match kareyenge is video mein aapko kaafi details se samjhaya gaya hai
aur aapko match data in excel ye wali video kaafi pasend aane wali hai
Practice File
docs.google.com/spreadsheets/d/10Y3uVlHeakpIu_zOMi1VxoJMJqFxIbTs/edit?usp=sharing&ouid=107193174439435123378&rtpof=true&sd=true
Join Our Course
👇
App Link For Android
👇
play.google.com/store/apps/details?id=co.rios.lmech
App Link for IOS
👇
apps.apple.com/in/app/classplus/id1324522260
(USE ORG CODE-LMECH)
Question & Queries
Match Data
match Data in excel
Match data in two excel sheets
match data in two column excel
Match data from one spreadsheet to another excel
match data in excel using vlookup
match data using vlookup
match data in excel using vlookup
match data using vlookup
match data in 2 columns
match data sets in excel
match data from 2 spreadsheets
match data from two excel spreadsheets
Follow me
👇
Instagram id:- abhijeetjitechnical4m
Telegram:-t.me/abhijeetjitechnical4m
Advance Excel Formulas
👇
Vlookup Formula Part 1
czcams.com/video/7zucIvvFNiM/video.html
Vlookup formula part 2
czcams.com/video/E5bdlAOljxk/video.html
Subtotal Formula
czcams.com/video/Q8EAfg-J6ec/video.html
Countifs Formula
czcams.com/video/h4ViPiRuIBw/video.html
Aggregate Formula
czcams.com/video/IUbrtW5lubk/video.html
Sumproduct Formula
czcams.com/video/c0XLufPQ58w/video.html
Sumifs Formula
czcams.com/video/ek9LU4FGN6s/video.html
Pivot Table Basic To Advance
👇
czcams.com/play/PL2b31Ng8I_l8YMFWVRaaS0Pj55GziFqup.html
All the images & back ground music use in this video only for education purpose and all credit goes to owner
Disclaimer:--
Note: 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 scholar ship 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....
Aasha karta hoon dosto aapko humare video pasend aaya hoga agar video aachha laga ho to humare channel ko subscribe karke bell icon ko press kar lijiyega kyonki hum apne channle per is type ki video lekar aate rahte hai
#matchtwoworkbooksinexcel
#matchdatainexcel
#abhijeetjitechnical4m
About Video
Namaskar Dosto aaj aap is video mein sikhne jara rahe agar aapke pas two excel sheets hai but data match nahi kar rahe hain to aap kaise two excel sheets ke data ko match karayenge or two alag alag workbooks ke data ko kaise match kareyenge is video mein aapko kaafi details se samjhaya gaya hai
aur aapko match data in excel ye wali video kaafi pasend aane wali hai
Practice File
docs.google.com/spreadsheets/d/10Y3uVlHeakpIu_zOMi1VxoJMJqFxIbTs/edit?usp=sharing&ouid=107193174439435123378&rtpof=true&sd=true
Join Our Course
👇
App Link For Android
👇
play.google.com/store/apps/details?id=co.rios.lmech
App Link for IOS
👇
apps.apple.com/in/app/classplus/id1324522260
(USE ORG CODE-LMECH)
Question & Queries
Match Data
match Data in excel
Match data in two excel sheets
match data in two column excel
Match data from one spreadsheet to another excel
match data in excel using vlookup
match data using vlookup
match data in excel using vlookup
match data using vlookup
match data in 2 columns
match data sets in excel
match data from 2 spreadsheets
match data from two excel spreadsheets
Follow me
👇
Instagram id:- abhijeetjitechnical4m
Telegram:-t.me/abhijeetjitechnical4m
Advance Excel Formulas
👇
Vlookup Formula Part 1
czcams.com/video/7zucIvvFNiM/video.html
Vlookup formula part 2
czcams.com/video/E5bdlAOljxk/video.html
Subtotal Formula
czcams.com/video/Q8EAfg-J6ec/video.html
Countifs Formula
czcams.com/video/h4ViPiRuIBw/video.html
Aggregate Formula
czcams.com/video/IUbrtW5lubk/video.html
Sumproduct Formula
czcams.com/video/c0XLufPQ58w/video.html
Sumifs Formula
czcams.com/video/ek9LU4FGN6s/video.html
Pivot Table Basic To Advance
👇
czcams.com/play/PL2b31Ng8I_l8YMFWVRaaS0Pj55GziFqup.html
All the images & back ground music use in this video only for education purpose and all credit goes to owner
Disclaimer:--
Note: 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 scholar ship 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....
Aasha karta hoon dosto aapko humare video pasend aaya hoga agar video aachha laga ho to humare channel ko subscribe karke bell icon ko press kar lijiyega kyonki hum apne channle per is type ki video lekar aate rahte hai
#matchtwoworkbooksinexcel
#matchdatainexcel
#abhijeetjitechnical4m
zhlédnutí: 665
Video
How to Insert Sheets in Bulk in Excel | VBA Tips & Tricks | Advanced Excel Tips and Tricks
zhlédnutí 302Před 9 hodinami
How to Insert Sheets in Bulk in Excel | VBA Tips & Tricks | Advanced Excel Tips and Tricks Download Practice Sheet 👇 drive.google.com/file/d/19w9_zW1vX6ZZsWVCZ5n7xRTF4CeJsuj_/view?usp=sharing Course Link 👇 App Link For Android lmech.courses.store/download-app?source=tutor_website App Link for IOS 👇 apps.apple.com/in/app/classplus/id1324522260 (USE ORG CODE-LMECH) Questions & Queries 👇 how to in...
Top 3 Excel Hacks | Never Seen Before | Advanced Excel Filter Hacks
zhlédnutí 623Před 14 hodinami
Top 3 Excel Hacks | Never Seen Before | Advanced Excel Filter Hacks Download Practice Sheet 👇 docs.google.com/spreadsheets/d/1r_wlnkQgC8uAJ5DtDU5_zmuG_hFR7DbL/edit?usp=sharing&ouid=107193174439435123378&rtpof=true&sd=true Course Link 👇 App Link For Android lmech.courses.store/download-app?source=tutor_website App Link for IOS 👇 apps.apple.com/in/app/classplus/id1324522260 (USE ORG CODE-LMECH) Q...
Data Analysis Interview Quesitons & Answers | MIS Executive | Dependent Dynamic Drop Down List
zhlédnutí 647Před dnem
Data Analysis Interview Quesitons & Answers | MIS Executive | Dependent Dynamic Drop Down List Download Practice Sheet 👇 docs.google.com/spreadsheets/d/1kgKzxa7pgVPoV9Ak1OK2lySVKqjVy_UU/edit?usp=sharing&ouid=107193174439435123378&rtpof=true&sd=true Course Link 👇 App Link For Android lmech.courses.store/download-app?source=tutor_website App Link for IOS 👇 apps.apple.com/in/app/classplus/id132452...
Automation in Pivot Table | Pivot Table Hacks | Advaned Excel Tips & Tricks | Pivot Table Tips
zhlédnutí 1,6KPřed 14 dny
Automation in Pivot Table | Pivot Table Hacks | Advaned Excel Tips & Tricks | Pivot Table Tips Download Practice Sheet 👇 docs.google.com/spreadsheets/d/19PtJiiDCT6Ah0HNrRPPo_L4bquUqAVbU/edit?usp=sharing&ouid=107193174439435123378&rtpof=true&sd=true Course Link 👇 App Link For Android lmech.courses.store/download-app?source=tutor_website App Link for IOS 👇 apps.apple.com/in/app/classplus/id132452...
Complex Formulas for MIS Executive | How to Automate Your Work without VBA in Excel | Excel TIps
zhlédnutí 716Před 14 dny
Complex Formulas for MIS Executive | How to Automate Your Work without VBA in Excel | Excel TIps Course Link 👇 App Link For Android lmech.courses.store/download-app?source=tutor_website App Link for IOS 👇 apps.apple.com/in/app/classplus/id1324522260 (USE ORG CODE-LMECH) Questions & Queries 👇 excel interview questions for mis executive excel importatn questions for interview mis analysis intervi...
TOP 12 MIS Executive Quesitons and Answers | Advaned Excel interview Questions and Answers
zhlédnutí 1KPřed 21 dnem
TOP 12 MIS Executive Quesitons and Answers | Advaned Excel interview Questions and Answers
Infographic Bar Chart in Excel | Advanced Excel Chart Tips & Tricks | Attractive Infographic Chart
zhlédnutí 233Před 21 dnem
Infographic Bar Chart in Excel | Advanced Excel Chart Tips & Tricks | Attractive Infographic Chart
Unique Mehtod to Create Sarchable Filter without VBA | Formula Goruping in Excel | Advaned Excel
zhlédnutí 676Před 21 dnem
Unique Mehtod to Create Sarchable Filter without VBA | Formula Goruping in Excel | Advaned Excel
Pivot Table Amazing Two Tips | Save 3 Hours Daily | Row Difference Inside the Pivot Table
zhlédnutí 1,2KPřed 21 dnem
Pivot Table Amazing Two Tips | Save 3 Hours Daily | Row Difference Inside the Pivot Table
MIS Executive & Data Analysis Interview Questions & Answer | MIS Executive Cracker | Excel Intervie
zhlédnutí 826Před 28 dny
MIS Executive & Data Analysis Interview Questions & Answer | MIS Executive Cracker | Excel Intervie
Index Formula with Match,Choose & Large | How to Grouping Formula in Excel | Advanced Excel Formulas
zhlédnutí 2,3KPřed měsícem
Index Formula with Match,Choose & Large | How to Grouping Formula in Excel | Advanced Excel Formulas
Vlookup Formula with Offset & Indirect | Without VBA Automate your Daily Routine Work on Excel
zhlédnutí 1,2KPřed měsícem
Vlookup Formula with Offset & Indirect | Without VBA Automate your Daily Routine Work on Excel
Office 365 Formula in OLD Excel Version | How to Create Office 365 Formula in OLD Excel
zhlédnutí 588Před měsícem
Office 365 Formula in OLD Excel Version | How to Create Office 365 Formula in OLD Excel
Amazing Hacks to Apply Vlookup With Table Formatting| Only 1% Excel User Know This Secret
zhlédnutí 1,5KPřed měsícem
Amazing Hacks to Apply Vlookup With Table Formatting| Only 1% Excel User Know This Secret
MIS Executive TOP 3 Questions & Answers | Secret Tricks to Crack MIS Executive Interview | Excel
zhlédnutí 764Před měsícem
MIS Executive TOP 3 Questions & Answers | Secret Tricks to Crack MIS Executive Interview | Excel
Create Smartly Formula to Make Selection out of 100 People For MIS Executive Interview | MIS Ext
zhlédnutí 1KPřed měsícem
Create Smartly Formula to Make Selection out of 100 People For MIS Executive Interview | MIS Ext
Create Automation in old Verion of Excel with VBA Code | Filter Data with Check Box | Advanced Excel
zhlédnutí 897Před 2 měsíci
Create Automation in old Verion of Excel with VBA Code | Filter Data with Check Box | Advanced Excel
How to Save 10 Hours Daily in Excel | कैसा भी MACRO हो बाप हो जाओगे | Excel Macro
zhlédnutí 1,3KPřed 2 měsíci
How to Save 10 Hours Daily in Excel | कैसा भी MACRO हो बाप हो जाओगे | Excel Macro
TOP 7 MIS Executive Quesitons and Answers | इस वीडियो को देखने के बाद ९०% इंटरव्यू आप क्लियर कर लोगे
zhlédnutí 947Před 2 měsíci
TOP 7 MIS Executive Quesitons and Answers | इस वीडियो को देखने के बाद ९०% इंटरव्यू आप क्लियर कर लोगे
Bookkeeping Excel Software | Daily Transaction Excel Software| Bookkeeping Template
zhlédnutí 544Před 2 měsíci
Bookkeeping Excel Software | Daily Transaction Excel Software| Bookkeeping Template
How to Share Specific Data to Slected User in Google Sheet | Google Sheet Tips & Tricks
zhlédnutí 726Před 2 měsíci
How to Share Specific Data to Slected User in Google Sheet | Google Sheet Tips & Tricks
Match Two Excel Workbook | Match Data in Two Excel Sheets | Match Data in Excel
zhlédnutí 4,8KPřed 2 měsíci
Match Two Excel Workbook | Match Data in Two Excel Sheets | Match Data in Excel
MIS Eexcutive Tricky Questions & Answers | इस वीडियो को देखने के बाद ९०% इंटरव्यू आप क्लियर कर लोगे
zhlédnutí 667Před 2 měsíci
MIS Eexcutive Tricky Questions & Answers | इस वीडियो को देखने के बाद ९०% इंटरव्यू आप क्लियर कर लोगे
TOP 5 MIS Executive Common Questions & Answers Asked by Interviewer | MIS Executive Cracker
zhlédnutí 781Před 2 měsíci
TOP 5 MIS Executive Common Questions & Answers Asked by Interviewer | MIS Executive Cracker
Free Hotel Booking Software | Excel Hotel Booking Software | Hotel Inventory Software
zhlédnutí 1,3KPřed 3 měsíci
Free Hotel Booking Software | Excel Hotel Booking Software | Hotel Inventory Software
MIS Executive Work Details | Data Transfrom in Excel | Advanced Excel Tips & Tricks
zhlédnutí 1,2KPřed 3 měsíci
MIS Executive Work Details | Data Transfrom in Excel | Advanced Excel Tips & Tricks
Top 5 MIS Executive Important Questions & Answers | Excel Importatn Questions For Interview
zhlédnutí 1,1KPřed 3 měsíci
Top 5 MIS Executive Important Questions & Answers | Excel Importatn Questions For Interview
Match Critical Two Sheets Data within Minutes | Fuzzy Lookup | Power Query Tips & Tricks
zhlédnutí 923Před 3 měsíci
Match Critical Two Sheets Data within Minutes | Fuzzy Lookup | Power Query Tips & Tricks
Excel Interview Question For MIS Executive Based on Vlookup | MS Excel Interview Questions & Answers
zhlédnutí 993Před 4 měsíci
Excel Interview Question For MIS Executive Based on Vlookup | MS Excel Interview Questions & Answers
Ye analyze data ka button ms excel 2019 me to nahi dikhta to aapne kisme kiya?
Office 365
Nice video
Full explanation, Nice video
Thankyou sir for this great video but I think in last pivot table question you have made a mistake while calculating grand total.
Will check
Great vedio sir
value ko absolute ksy kia wo tu btya nh
F4 press karke
Bro i didn't understand Hindi, pl tell in eng
Use flash fill easy and fast
ms office ke kis version me hai ye
which excel version you are using
Aur product par percentage kaise laga kar nikale
=product*percentage/100
Expiry date kaise nikale
Use edate function
Happy Teachers' day sir for being wonderful teacher.
Kuch samaj nahi aya itana fast kuch palle nahi pada aram se batao thora detail me
Hello sir Mere pass ek ICICI bank ka statement hai us me se sare number or name alag karne hai to help me 😢
Download our app from play store and msg there App name - abhijeetji technical 4m
Sir kindly please
Plz guide me to use rank formula with #
#office365 mein work karta hai #represnt karta hai last range Tak ki value
Rank ke formula me # nai lg raha plz help me
Power point ka ribbon display nahi ho raha excel 365 mein wih kaise aayega
CTRL+F1 press
Vba laughing in corner
Also use conditional formatting then unique or duplicate value, apko pata lag jayega itna zada krne ki zarurat nai hogi
Conditional formatting condition ke base per formatting karta hai Aur lookup formula dusre sheet or workbook se value ko fetch karta hain And formula always will be automation whenever new data come it will work Conditional formatting Aur lookup formula mein Jamin aasman ka fark hai
Bro, how to get add ins, in my pc add in is not showing in' insert ' totally add in option is not showing. How to get add ins in my pc. I am using windows 2013 pls reply
great 👍👏
🙏
Great tricks 🎉
Awesome
Bhai kon se office mai aapko aisa kaam de rha 😂
Use formula: =sum(C2:C18)
Bhai kaun sa software use krte ho video banane ke liye
Kinemaster
U r genious
Poore youtube me ye content nahi milne wala,, or me youtube me hi isse dekh raha hu 😂 , chhpari yt
This options not show in latest version open file?
Which excel version you are using
❤
AISA KOI FORMULA HI NAHI H
this formula available in office 365
24 likhna jaruri hai?
Nahi koi jaroori nahi
App ki vide baar baar doubling hoo ri hay means phir repeat hoo ri hay Jo student ko bohat parayshan ker ri hay. Kindly ais ko settle karayn
I think you have to learn in proper way you are the one person Jise samjhne mein problem aa Rahi so focus on learning
App sub sub ka mix ker daytay hain aur student confuse hoo jata hay. Aur phir hum kia practice karayn
I think you have to learn in proper way you are the one person Jise samjhne mein problem aa Rahi so focus on learning
Thank you so much please key board ki shortcut keys btayo for select all without mouse use kiye
Ctrl+ shift+down arrow the ctrl+shift+right arrow
Thank you
how to change range data model?
Don’t need to change automatic it will update whenever new data coms
Awesome sirji ❤❤
THODA DHEME BATIYE GURU JI TO MUHE BHI A JAYEGA
❤
kam nehi karta be pagal
Yesterday I made this sheet but today I opened the sheet but an error showing macro is disabled
Doing some mistake watch carefully and try again Dashboard mein macro ka use nahi kiya Gaya hai create a woorkbook and and try there
Isse acha last m sub total laga do bhai pure ka Phr filter use krke udhr yellow select kr do to yellow wale ka total dikha dega 😂
Filter se bhi hota
Sir vstack formula sirf 2021+ ke version ke baad use hota he...usse pehele nahi...to vstack ke bina sare branch name kaise populate kare?
You have to use array concept for this
Hi, your efforts are excellent 👌 but you go too fast difficult to understand for beginners for ex.when you create table 1 is not seen in this video & most important if possible pls go slow
Sir your course is really amazing