![Abhijeetji Technical 4M](/img/default-banner.jpg)
- 753
- 17 267 862
Abhijeetji Technical 4M
India
Приєднався 15 лис 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
Automation in Pivot Table | Pivot Table Hacks | Advaned Excel Tips & Tricks | Pivot Table Tips
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/id1324522260
(USE ORG CODE-LMECH)
Questions & Queries
👇
Pivot Table Hacks
pivot table tips and tricks
pivot table automation
pivot table hacks
pivot table tutorial
pivot table secret
Follow me
👇
Facebook:- abhijeetjitechnical4m
Instagram id:- abhijeetjitechnical4m
Telegram:-t.me/abhijeetjitechnical4m
Advance Excel Formulas
👇
Vlookup Formula Part 1
ua-cam.com/video/7zucIvvFNiM/v-deo.html
Vlookup formula part 2
ua-cam.com/video/E5bdlAOljxk/v-deo.html
Subtotal Formula
ua-cam.com/video/Q8EAfg-J6ec/v-deo.html
Countifs Formula
ua-cam.com/video/h4ViPiRuIBw/v-deo.html
Aggregate Formula
ua-cam.com/video/IUbrtW5lubk/v-deo.html
Sumproduct Formula
ua-cam.com/video/c0XLufPQ58w/v-deo.html
Sumifs Formula
ua-cam.com/video/ek9LU4FGN6s/v-deo.html
Choose Formula
ua-cam.com/video/DYtKRGOKaJI/v-deo.html
Pivot Table Basic To Advance
👇
ua-cam.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
#pivottabletips
#pivottable
#abhijeetjitechnical4m
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/id1324522260
(USE ORG CODE-LMECH)
Questions & Queries
👇
Pivot Table Hacks
pivot table tips and tricks
pivot table automation
pivot table hacks
pivot table tutorial
pivot table secret
Follow me
👇
Facebook:- abhijeetjitechnical4m
Instagram id:- abhijeetjitechnical4m
Telegram:-t.me/abhijeetjitechnical4m
Advance Excel Formulas
👇
Vlookup Formula Part 1
ua-cam.com/video/7zucIvvFNiM/v-deo.html
Vlookup formula part 2
ua-cam.com/video/E5bdlAOljxk/v-deo.html
Subtotal Formula
ua-cam.com/video/Q8EAfg-J6ec/v-deo.html
Countifs Formula
ua-cam.com/video/h4ViPiRuIBw/v-deo.html
Aggregate Formula
ua-cam.com/video/IUbrtW5lubk/v-deo.html
Sumproduct Formula
ua-cam.com/video/c0XLufPQ58w/v-deo.html
Sumifs Formula
ua-cam.com/video/ek9LU4FGN6s/v-deo.html
Choose Formula
ua-cam.com/video/DYtKRGOKaJI/v-deo.html
Pivot Table Basic To Advance
👇
ua-cam.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
#pivottabletips
#pivottable
#abhijeetjitechnical4m
Переглядів: 972
Відео
Complex Formulas for MIS Executive | How to Automate Your Work without VBA in Excel | Excel TIps
Переглядів 5084 години тому
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
Переглядів 78219 годин тому
TOP 12 MIS Executive Quesitons and Answers | Advaned Excel interview Questions and Answers Download Practice File 👇 docs.google.com/spreadsheets/d/1x2y5PVovnYS-ANe-i8_tmSDA0rY4NVq6/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 ...
Infographic Bar Chart in Excel | Advanced Excel Chart Tips & Tricks | Attractive Infographic Chart
Переглядів 213День тому
Infographic Bar Chart in Excel | Advanced Excel Chart Tips & Tricks | Attractive Infographic Chart About Video 👇 Namaskar Dosto aaj hum is video mein sikhenge ki aap excel mein attractive bar chart kaise banayenge umeed hai ye excel bar chart aapko pasend aayega Download Practice Sheet 👇 docs.google.com/spreadsheets/d/1LOaMw1_4dZ5R_CiAZZIbFZ5k89AP7iqU/edit?usp=sharing&ouid=107193174439435123378...
Unique Mehtod to Create Sarchable Filter without VBA | Formula Goruping in Excel | Advaned Excel
Переглядів 630День тому
Unique Mehtod to Create Sarchable Filter without VBA | Formula Goruping in Excel | Advaned Excel About Video 👇 Namaskar Dosto aaj hum advanced filter create karne wale hai array concept ke base per aur aap is method ka use karke kisi ko bhi office mein impress kar sakte hain Download Practice Sheet 👇 drive.google.com/file/d/1hDHeFubgB6u31zaZo9JK_UVyyEIHpfTp/view?usp=sharing JOIN OUR COURSE 👇 👉 ...
Pivot Table Amazing Two Tips | Save 3 Hours Daily | Row Difference Inside the Pivot Table
Переглядів 1,1 тис.14 днів тому
Pivot Table Amazing Two Tips | Save 3 Hours Daily | Row Difference Inside the Pivot Table About Video 👇 Namaskar Dosto aaj hum is video mein mis executive and data analysis ka important questions dekhne ja rahe hain jo ki array concept ke base per hai aur aap ko is mis executive se kafi kuch sikhne ko milne wala hai so lets enjoy mis excutive and data analysis cracker video Download Practice Sh...
MIS Executive & Data Analysis Interview Questions & Answer | MIS Executive Cracker | Excel Intervie
Переглядів 79214 днів тому
MIS Executive & Data Analysis Interview Questions & Answer | MIS Executive Cracker | Excel Intervie About Video 👇 Namaskar Dosto aaj hum is video mein mis executive and data analysis ka important questions dekhne ja rahe hain jo ki array concept ke base per hai aur aap ko is mis executive se kafi kuch sikhne ko milne wala hai so lets enjoy mis excutive and data analysis cracker video Download P...
Index Formula with Match,Choose & Large | How to Grouping Formula in Excel | Advanced Excel Formulas
Переглядів 2 тис.14 днів тому
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
Переглядів 1,2 тис.21 день тому
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
Переглядів 57228 днів тому
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
Переглядів 1,5 тис.Місяць тому
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
Переглядів 736Місяць тому
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
Переглядів 991Місяць тому
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
Переглядів 883Місяць тому
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
Переглядів 1,3 тис.Місяць тому
How to Save 10 Hours Daily in Excel | कैसा भी MACRO हो बाप हो जाओगे | Excel Macro
TOP 7 MIS Executive Quesitons and Answers | इस वीडियो को देखने के बाद ९०% इंटरव्यू आप क्लियर कर लोगे
Переглядів 876Місяць тому
TOP 7 MIS Executive Quesitons and Answers | इस वीडियो को देखने के बाद ९०% इंटरव्यू आप क्लियर कर लोगे
Bookkeeping Excel Software | Daily Transaction Excel Software| Bookkeeping Template
Переглядів 529Місяць тому
Bookkeeping Excel Software | Daily Transaction Excel Software| Bookkeeping Template
How to Share Specific Data to Slected User in Google Sheet | Google Sheet Tips & Tricks
Переглядів 6662 місяці тому
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
Переглядів 4,5 тис.2 місяці тому
Match Two Excel Workbook | Match Data in Two Excel Sheets | Match Data in Excel
MIS Eexcutive Tricky Questions & Answers | इस वीडियो को देखने के बाद ९०% इंटरव्यू आप क्लियर कर लोगे
Переглядів 6562 місяці тому
MIS Eexcutive Tricky Questions & Answers | इस वीडियो को देखने के बाद ९०% इंटरव्यू आप क्लियर कर लोगे
TOP 5 MIS Executive Common Questions & Answers Asked by Interviewer | MIS Executive Cracker
Переглядів 7662 місяці тому
TOP 5 MIS Executive Common Questions & Answers Asked by Interviewer | MIS Executive Cracker
Free Hotel Booking Software | Excel Hotel Booking Software | Hotel Inventory Software
Переглядів 1,1 тис.2 місяці тому
Free Hotel Booking Software | Excel Hotel Booking Software | Hotel Inventory Software
MIS Executive Work Details | Data Transfrom in Excel | Advanced Excel Tips & Tricks
Переглядів 1,1 тис.2 місяці тому
MIS Executive Work Details | Data Transfrom in Excel | Advanced Excel Tips & Tricks
Top 5 MIS Executive Important Questions & Answers | Excel Importatn Questions For Interview
Переглядів 1,1 тис.3 місяці тому
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
Переглядів 9173 місяці тому
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
Переглядів 9813 місяці тому
Excel Interview Question For MIS Executive Based on Vlookup | MS Excel Interview Questions & Answers
Data Analysis Interview Questions | Progress Infographic Chart | Advance Excel Chart
Переглядів 6003 місяці тому
Data Analysis Interview Questions | Progress Infographic Chart | Advance Excel Chart
MIS Executive,Data Analysis,Business Analysis Interview Questions & Answers | Advacned Excel
Переглядів 2,3 тис.3 місяці тому
MIS Executive,Data Analysis,Business Analysis Interview Questions & Answers | Advacned Excel
MIS Executive Tricky Question | फेल होने का कारन जान लो | Advanced Excel Interview Question
Переглядів 1,6 тис.4 місяці тому
MIS Executive Tricky Question | फेल होने का कारन जान लो | Advanced Excel Interview Question
Dark Secrets of Date Formatting in Excel | Only 1% Excel User Know | Advanced Excel Tips & Tricks
Переглядів 7294 місяці тому
Dark Secrets of Date Formatting in Excel | Only 1% Excel User Know | Advanced Excel Tips & Tricks
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?
Sir your course is really amazing
Last vale mein answer different aarha hn
HELLO !! Sir month wise amt h rows me hme result me month pr validation lgai Hui h ab jis bhi month ko select krenge us month tk ka total sum dikhana h January se hr bar.. please help
First create drop-down list of month in new sheet then use Sumifs formula If u want to personal support for this download our app and join course App name - abhijeetji technical 4m
@@AbhijeetjiTechnical4M sir already drop down list created but result nhi aya jo chahiye
Command nahi दिख रहा choosecols पर
Which excel version you are using I think your excel is not office 365 isliye nahi dikh raha You can practice on google sheet there choosecols formula is available
thanks for learning sir😊
How i get this application
Download our app from play store and purchase hotel software App name - abhijeetji technical 4m
Excellent working brother ❤
Sir big fan of you please gift me a course, Love you from Pakistan
Sir big fan of you please gift me a course, Love you from Pakistan
Thanks sir.its very helpful
Sir name ke band ek tap space Dene ke Kiya kya karna hai
Manual ek space de do uske bad custom formatting apply karo
@@AbhijeetjiTechnical4M Thank u sir, fir se teek se samjjayee sir..
Sir thanks your support
It's really helpful video sir thank you 😊
Sir application bataye koi
Excellent
Paid hai yeh toh
Like it ❤
Isase better mere pass hai.... without any problem
its not free
Thank you soooooooooooooooooooo much sir
Very informative thank you
Very good 👍
Without sequence formula ke kese hoga 2007 me nhi hai
Inserted of sequence use row function with indirect to generate sequence You need to learn array mastery which is most important of excel and no one teaching in his course, if u want to learn download our app from play store and join App name - abhijeetji technical 4m After learn array you can fix your query itself
Sir first of all thanks this video. Lakin waqi samaj nae ayi this chart for what purpose. Because hum normal chat banatey sales ka tuo number sab show hoty. Kiya ap again video bana sakty different example ky saat use this visuals
This is just beyond excellent 👍👌
Your course is such a amazing
in Q3--@9:10 , how to get unique data in dropdown list using data validation. I had tried unique but its not working
Which excel version you are using
@@AbhijeetjiTechnical4M excel 2021
This formula is not appearing in my excel
Available in office 365 version
Thank you so much...,.. kuch samaz nahi aaya
Need to learn
Sir, double click kiya to bs ek ka dikh rha h lekin back k liye kya filter hatana padega?
Bac ke liye drill up karo
❤❤❤❤
Same sheet per filter karna ho to same style
Use same formula in same sheet
How to add AI tools in Excel
Date waise kyu aai, exactly copy kyu nhi hui?
You are doing mistake watch carefully
Jai hind
Nic sir
sir mera 2021 version hai but mere isme ye formula nhi aa rha hai ab kya karu
Office 365 mein hai ye formula but you can practice on google sheet which is totally free
Tqqqqqqq so much 👍👍
Formula work nhi kr rha hai sir
Watch carefully and try
Very interesting sir ji
Thank you for your knowledgeable information it's really saved my day ❤
Aap online classes bhi dete ho
Yes You can download our app from play store and and discuss with me about our courses through chat option in app App name - abhijeetji technical 4m
Your course is amazing
Mein name Manager me time waste karne ki jagah, sum mein range (forstrow:lastrow) type kardoon
Excel has multiple tricks to get output it’s totally depend on your situation
Sir plzz link not open how to create this plzz share with me vedio plzz
Visit our channel and go to dashboard playlist
=Let(x,Mid(Text,sequence(Len(text)),1),concat(if(iserr(--x),'''',x))))) Text = cell that contain the value
Excel has lots of tricks to get output it’s totally depend on your situation If u add let function in any function then your formula will be smallest that’s beauty of let formula Thanks
@@AbhijeetjiTechnical4M I just know formula but not the meaning of this formual 😂😂 Just ratta maara hai...
Thanks very valuable and informative