Abhijeetji Technical 4M
Abhijeetji Technical 4M
  • 753
  • 17 267 862
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
Переглядів: 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

КОМЕНТАРІ

  • @nirmalkashyap3897
    @nirmalkashyap3897 7 годин тому

    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 😂

  • @ishahab1000
    @ishahab1000 9 годин тому

    Filter se bhi hota

  • @Narendra_Singh_Modi
    @Narendra_Singh_Modi 9 годин тому

    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?

  • @Bligle
    @Bligle 15 годин тому

    Sir your course is really amazing

  • @yatinyadav2283
    @yatinyadav2283 16 годин тому

    Last vale mein answer different aarha hn

  • @tanzeem7477
    @tanzeem7477 День тому

    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

    • @AbhijeetjiTechnical4M
      @AbhijeetjiTechnical4M 23 години тому

      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

    • @tanzeem7477
      @tanzeem7477 18 годин тому

      @@AbhijeetjiTechnical4M sir already drop down list created but result nhi aya jo chahiye

  • @kishorichaudhary-k8m
    @kishorichaudhary-k8m День тому

    Command nahi दिख रहा choosecols पर

    • @AbhijeetjiTechnical4M
      @AbhijeetjiTechnical4M День тому

      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

  • @lookingfacts6879
    @lookingfacts6879 День тому

    thanks for learning sir😊

  • @apstha
    @apstha День тому

    How i get this application

    • @AbhijeetjiTechnical4M
      @AbhijeetjiTechnical4M День тому

      Download our app from play store and purchase hotel software App name - abhijeetji technical 4m

  • @ShahidIqbal-zu7mt
    @ShahidIqbal-zu7mt 3 дні тому

    Excellent working brother ❤

  • @aliimran5696
    @aliimran5696 3 дні тому

    Sir big fan of you please gift me a course, Love you from Pakistan

  • @aliimran5696
    @aliimran5696 3 дні тому

    Sir big fan of you please gift me a course, Love you from Pakistan

  • @tanzeem7477
    @tanzeem7477 3 дні тому

    Thanks sir.its very helpful

  • @maheshwaranc2791
    @maheshwaranc2791 3 дні тому

    Sir name ke band ek tap space Dene ke Kiya kya karna hai

    • @AbhijeetjiTechnical4M
      @AbhijeetjiTechnical4M 2 дні тому

      Manual ek space de do uske bad custom formatting apply karo

    • @maheshwaranc2791
      @maheshwaranc2791 2 дні тому

      @@AbhijeetjiTechnical4M Thank u sir, fir se teek se samjjayee sir..

  • @janmejaymahapatra369
    @janmejaymahapatra369 4 дні тому

    Sir thanks your support

  • @nashrakhan1925
    @nashrakhan1925 4 дні тому

    It's really helpful video sir thank you 😊

  • @abidgani304
    @abidgani304 4 дні тому

    Sir application bataye koi

  • @shaharyarahmed6124
    @shaharyarahmed6124 5 днів тому

    Excellent

  • @ajaytk
    @ajaytk 5 днів тому

    Paid hai yeh toh

  • @DeepakSingh-l4r
    @DeepakSingh-l4r 6 днів тому

    Like it ❤

  • @manojk2890
    @manojk2890 6 днів тому

    Isase better mere pass hai.... without any problem

  • @xsinghanurag
    @xsinghanurag 6 днів тому

    its not free

  • @cameldangal2
    @cameldangal2 6 днів тому

    Thank you soooooooooooooooooooo much sir

  • @nisikantbehera5002
    @nisikantbehera5002 6 днів тому

    Very informative thank you

  • @arpitnigam7309
    @arpitnigam7309 6 днів тому

    Very good 👍

  • @theupup4940
    @theupup4940 6 днів тому

    Without sequence formula ke kese hoga 2007 me nhi hai

    • @AbhijeetjiTechnical4M
      @AbhijeetjiTechnical4M 6 днів тому

      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

  • @salmanbutt2224
    @salmanbutt2224 8 днів тому

    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

  • @souvikdas9110
    @souvikdas9110 8 днів тому

    This is just beyond excellent 👍👌

  • @Bligle
    @Bligle 8 днів тому

    Your course is such a amazing

  • @sanketv1
    @sanketv1 8 днів тому

    in Q3--@9:10 , how to get unique data in dropdown list using data validation. I had tried unique but its not working

  • @Pkkepahadi
    @Pkkepahadi 8 днів тому

    This formula is not appearing in my excel

  • @manojk2890
    @manojk2890 9 днів тому

    Thank you so much...,.. kuch samaz nahi aaya

  • @Funnfactorydotcalm
    @Funnfactorydotcalm 9 днів тому

    Sir, double click kiya to bs ek ka dikh rha h lekin back k liye kya filter hatana padega?

  • @jeraldthalaiva85
    @jeraldthalaiva85 9 днів тому

    ❤❤❤❤

  • @ivikashranjan
    @ivikashranjan 11 днів тому

    Same sheet per filter karna ho to same style

  • @04akankshasharma_a23
    @04akankshasharma_a23 11 днів тому

    How to add AI tools in Excel

  • @KV_55555
    @KV_55555 12 днів тому

    Date waise kyu aai, exactly copy kyu nhi hui?

  • @ranjeetkumar-xw1un
    @ranjeetkumar-xw1un 12 днів тому

    Jai hind

  • @khushdilinsaan3605
    @khushdilinsaan3605 12 днів тому

    Nic sir

  • @jaypal8465
    @jaypal8465 12 днів тому

    sir mera 2021 version hai but mere isme ye formula nhi aa rha hai ab kya karu

    • @AbhijeetjiTechnical4M
      @AbhijeetjiTechnical4M 12 днів тому

      Office 365 mein hai ye formula but you can practice on google sheet which is totally free

  • @manjulapatro2183
    @manjulapatro2183 12 днів тому

    Tqqqqqqq so much 👍👍

  • @NandkishorSahu-r5q
    @NandkishorSahu-r5q 13 днів тому

    Formula work nhi kr rha hai sir

  • @vimaldewangan9309
    @vimaldewangan9309 13 днів тому

    Very interesting sir ji

  • @RushiMan
    @RushiMan 13 днів тому

    Thank you for your knowledgeable information it's really saved my day ❤

  • @raveenaveer4892
    @raveenaveer4892 13 днів тому

    Aap online classes bhi dete ho

    • @AbhijeetjiTechnical4M
      @AbhijeetjiTechnical4M 13 днів тому

      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

  • @Bligle
    @Bligle 14 днів тому

    Your course is amazing

  • @joesmith7760
    @joesmith7760 14 днів тому

    Mein name Manager me time waste karne ki jagah, sum mein range (forstrow:lastrow) type kardoon

    • @AbhijeetjiTechnical4M
      @AbhijeetjiTechnical4M 14 днів тому

      Excel has multiple tricks to get output it’s totally depend on your situation

  • @Suma7777-qh4nn
    @Suma7777-qh4nn 14 днів тому

    Sir plzz link not open how to create this plzz share with me vedio plzz

  • @joait1815
    @joait1815 14 днів тому

    =Let(x,Mid(Text,sequence(Len(text)),1),concat(if(iserr(--x),'''',x))))) Text = cell that contain the value

    • @AbhijeetjiTechnical4M
      @AbhijeetjiTechnical4M 14 днів тому

      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

    • @joait1815
      @joait1815 14 днів тому

      @@AbhijeetjiTechnical4M I just know formula but not the meaning of this formual 😂😂 Just ratta maara hai...

  • @KAILASHBHATIA-kf4mu
    @KAILASHBHATIA-kf4mu 15 днів тому

    Thanks very valuable and informative