Ajay Kumar
Ajay Kumar
  • 766
  • 1 326 378

Video

Comments

  • Zeeshan Ahmad
    Zeeshan Ahmad Minute ago

    Sir kindly tell the name of books from which you learn Power query?

  • Avinayak Choudhary
    Avinayak Choudhary 39 minutes ago

    sir next video send plz

  • RajKumar Solanki
    RajKumar Solanki 7 hours ago

    Nice sir ji

  • Mars Booker
    Mars Booker 8 hours ago

    Mr. Pamar, I watched several of your videos about exporting mail items from Outlook to Excel. I wrote my first macro and it worked for the first subfolder I want to target. In watching one of your videos about dealing with multiple outlook accounts, I created another macro using the same process to be able to call in the first macro in an attempt to nest them. While there are no syntax errors, I cannot populate emails from more than one folder into a worksheet. I think it is because the 2nd and 3rd loops are trying to write information in the cells with data already in them. Can you import more than one folder onto a single worksheet? If not, what would be the best way to program the subsequent macros to populate on different sheets then combine them?

    • Ajay Kumar
      Ajay Kumar 6 hours ago

      Change cell destination to avoid Overwriting. Better use next column or sheet..

  • Ubaid Khan
    Ubaid Khan 16 hours ago

    Hum fail ho kar pass ho gae..

  • POOJA
    POOJA 23 hours ago

    Sir apne java script per bhi video bana rakhi hai kya??

  • SATHISH BUDAM
    SATHISH BUDAM Day ago

    Thank you sir, you explained in a great way.

  • Lucky Mane
    Lucky Mane Day ago

    Sirji I have watched vdo 2nd time and I will try to install power pivot from given link

    • Ajay Kumar
      Ajay Kumar Day ago

      Link wasn't to install.. It was for information

    • Ajay Kumar
      Ajay Kumar Day ago

      If you have right version u can

  • Prashant Solanki

    Wow, I have passed on your question, sir. Thank you so much. You are best Sir.

  • Pankaj Kumar
    Pankaj Kumar Day ago

    Hello sir I just wanna know that how can I insert row after 5 rows pls answer this question

  • Ubaid Khan
    Ubaid Khan Day ago

    Hi sir. I follow all the steps but at the end didn't get the dynamic one after applying the query.

  • janardan rajput

    very well explained

  • ashish mohan
    ashish mohan 2 days ago

    hello sir. very big thanks you are the actually right youtuber. who understand our requirement time to time when ever we need any kind of increase or enhance our skill you set a series very big thanx sir πŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘ŒπŸ‘Œ

  • Santosh Kumar
    Santosh Kumar 2 days ago

    Mind blowing sir..

  • dharmendra yadav
    dharmendra yadav 2 days ago

    Awesome,

  • Shorya Arora
    Shorya Arora 2 days ago

    Superb

  • Ubaid Khan
    Ubaid Khan 2 days ago

    Eagle eyes....

  • Sanu Kumar
    Sanu Kumar 2 days ago

    mai sare vedio youtube par hi dekhata hu or like bhi karata hu

  • Ravi Parihar
    Ravi Parihar 2 days ago

    Fantastic sir

  • Sanu Kumar
    Sanu Kumar 2 days ago

    sir wfm ke bhi ek series bana do .

    • Ajay Kumar
      Ajay Kumar 2 days ago

      I do not do wfm now dear. It's not my intrest

  • Rajeev Sharma
    Rajeev Sharma 2 days ago

    great explanation, thanks

  • R Baskey
    R Baskey 2 days ago

    Thank you Sir. I am looking for this from very long time.

  • Lucky Mane
    Lucky Mane 2 days ago

    Hi sir how to install power pivot actually I have office 2016 for student in addins no power pivot not available so please suggest

    • Ajay Kumar
      Ajay Kumar 2 days ago

      @Lucky Mane lucky... Check my series 2. It has your question answer. You are not watching series in sequel and it's sad for me.

    • Lucky Mane
      Lucky Mane 2 days ago

      @Ajay Kumar I will try install power pivot available for Excel 2016 .

    • Lucky Mane
      Lucky Mane 2 days ago

      @Ajay Kumar sorry sirji for disappointed to u but I have search on Google but I have get that I have to use office 365 and power pivot avialble for 10,13 I will try to answer why I disappointed in 2-3 days

    • Ajay Kumar
      Ajay Kumar 2 days ago

      Seriously my lucky is asking me this.. It's disappointing for me.. Now why I am disappointed with you.. Tell me

  • AMRUT CHITRAGAR
    AMRUT CHITRAGAR 2 days ago

    Excellent video sir

  • Ibraheem Mohammed
    Ibraheem Mohammed 2 days ago

    Congratulations Ajay.. Expecting many more 20Ks in near future... It's time to celebrate subscribers as well

  • Vimal Tyagi
    Vimal Tyagi 3 days ago

    Sir kindly upload a video about XLookup in details. Thanks in advance

    • Ajay Kumar
      Ajay Kumar 3 days ago

      Its in beta testing and very few people have access to it right now

  • Vimal Tyagi
    Vimal Tyagi 3 days ago

    Thanks sir for start a new series

  • GAURAV KUMAR
    GAURAV KUMAR 3 days ago

    Thank you sir, waiting for next video..πŸ™

  • dharmendra yadav
    dharmendra yadav 3 days ago

    Thank you sir.

  • Uday Pandey
    Uday Pandey 3 days ago

    Thanks Sir

  • Dinesh Pandey
    Dinesh Pandey 3 days ago

    Very nice sir , fantastic series

  • farooqueasad11
    farooqueasad11 3 days ago

    This is wonderful. Is it possible to put array instead of o column range... actually i do not want criteria on worksheet

  • Shorya Arora
    Shorya Arora 3 days ago

    Every video is awesome πŸ‘πŸ»

  • Azhar Hussain
    Azhar Hussain 3 days ago

    Seems Interesting looking forward for new videos for it's usage in professional reports building.

  • Somanath Biswal
    Somanath Biswal 3 days ago

    My weekend with learning your videos SirπŸ™πŸ™πŸ™

  • Somanath Biswal
    Somanath Biswal 3 days ago

    Sir mera 3files 3 times load hoja raha

  • Lucky Mane
    Lucky Mane 3 days ago

    Once again nice video

  • Prashant Solanki
    Prashant Solanki 3 days ago

    Nice video thank you.

  • Prashant Solanki
    Prashant Solanki 3 days ago

    Very nice video

  • Jugnu Singh
    Jugnu Singh 3 days ago

    Thank you Sir

  • Somanath Biswal
    Somanath Biswal 3 days ago

    2013 mein to automatically refresh ho raha hai sir. Btw thanks a lotπŸ™πŸ’•

    • Ajay Kumar
      Ajay Kumar 3 days ago

      It keep undergoing new updates.. So you can always expect great things

  • rahul goyal
    rahul goyal 3 days ago

    Your way of teaching is very good and we are learning a lot. Thanks

  • dharmendra yadav
    dharmendra yadav 4 days ago

    Thank you sir

  • Somanath Biswal
    Somanath Biswal 4 days ago

    Thanks a lot Sir. I really like this topic

  • Lucky Mane
    Lucky Mane 4 days ago

    πŸ‘

  • Sanjiv Yadav
    Sanjiv Yadav 4 days ago

    Thanks a lot for quick response like power pivot series...

  • janardan rajput
    janardan rajput 4 days ago

    is power bi and power pivot same thing??

  • Ubaid Khan
    Ubaid Khan 4 days ago

    Hi sir.. in second example unable to get the pivot option only table and create connection option is there. Kindly suggest I am using 2013.

    • Ubaid Khan
      Ubaid Khan 4 days ago

      @Ajay Kumar thank you very much...

    • Ajay Kumar
      Ajay Kumar 4 days ago

      @Ubaid Khan in 2013 this option isn't available. I cannot promise you but you can google. Solution to 2013 users is go to excel sheet And show connection. Select the right one and right click. You shall see the option

    • Ubaid Khan
      Ubaid Khan 4 days ago

      @Ajay Kumar I am using it first time and it's not grey. I can go till (where system asking whether you want to use pivot table or table only) pop up but in pop up pivot option is not there only table convertion option is there.

    • Ajay Kumar
      Ajay Kumar 4 days ago

      If you use close and load second time for which data already uploaded in excel, you won't be able to use. This option is available for first time load. Next time it's greyed out.

    • Ubaid Khan
      Ubaid Khan 4 days ago

      @Ajay Kumar sir there are two option.second one is close & load to....to use pivot and minimize the size..but I am unable to get pivot option getting only table option

  • Bindhyesh Tripathi
    Bindhyesh Tripathi 5 days ago

    Thank you sir ..fir this series

  • Shorya Arora
    Shorya Arora 5 days ago

    Thank you ajay to clear my doubts between PQ and PP. Enjoying the series πŸ™

  • Santosh Kumar
    Santosh Kumar 5 days ago

    Awsm...

  • sunil pant
    sunil pant 5 days ago

    Hello sir..... I use Ms office standard 2016 version.... power pivot option is not inbuilt in this standard version of 2016......Sir is there any way I can work on power pivot using this standard version of 2016...

  • Sanu Kumar
    Sanu Kumar 5 days ago

    Thanks sir

  • Sanu Kumar
    Sanu Kumar 5 days ago

    Thanks sir

  • Lucky Mane
    Lucky Mane 5 days ago

    Nice video sir😍

  • sunil pant
    sunil pant 5 days ago

    Thank you sir for this new series..... Sir, I have Ms office standard 2016 version....do I have to download power query separately or is it inbuilt just like Ms office 365 2016 version....

    • sunil pant
      sunil pant 5 days ago

      @Ajay Kumar thank sir....

    • Ajay Kumar
      Ajay Kumar 5 days ago

      It is inbuilt I also use office 365

  • Bindhyesh Tripathi
    Bindhyesh Tripathi 5 days ago

    Amezing video sir ..

  • Passing CS
    Passing CS 5 days ago

    Thanks, does power query also uses same engine as powerpivot?

    • Ajay Kumar
      Ajay Kumar 5 days ago

      I don't think so. Power query used mash up language and power pivot dad language so I believe one used mash up engine and the latter has x velocity Or dax engine

  • Bindhyesh Tripathi
    Bindhyesh Tripathi 5 days ago

    Thanks sir ..yor explain very well

  • POOJA
    POOJA 5 days ago

    Sir please teach me English language or you make videos in hindi.

    • POOJA
      POOJA 5 days ago

      @Ajay Kumar yes sir, Thanks sir...

    • Ajay Kumar
      Ajay Kumar 5 days ago

      Now every video is in hindi. This video was three years back recorded

  • Vipin Goswami
    Vipin Goswami 6 days ago

    thank you sir , for this series.

  • janhvi contractor
    janhvi contractor 6 days ago

    Hi, I am a new subscriber and trying to achieve a specific task: 1. How to copy paste 6 charts on 1 slide ? 2. Copy all charts from all worksheets

  • Shorya Arora
    Shorya Arora 6 days ago

    Thank you for starting the new series. πŸ‘πŸ»

  • dharmendra yadav
    dharmendra yadav 6 days ago

    Thank you sir for new series.

  • Babar Qureshi
    Babar Qureshi 6 days ago

    Thanks sir

  • Shaikh Zahid
    Shaikh Zahid 6 days ago

    Sir, If possible please teach us R programming. Thanks

  • Somanath Biswal
    Somanath Biswal 6 days ago

    Super Sir

  • Somanath Biswal
    Somanath Biswal 6 days ago

    Dashboard par bhi vdo banayiye sirπŸ™πŸ™πŸ™

    • Ajay Kumar
      Ajay Kumar 5 days ago

      Playlist excel vba dashboard

  • Somanath Biswal
    Somanath Biswal 6 days ago

    Thanks for the series.

  • vishal makvana
    vishal makvana 6 days ago

    Sir me daily ye issues ko face kartha hu mere office me so please iska jaldi se jaldi ise series ka video uploaded kijiye

  • vishal makvana
    vishal makvana 6 days ago

    Nice video sir

  • Bindhyesh Tripathi
    Bindhyesh Tripathi 6 days ago

    Power BI per bhi series banao please

  • Bindhyesh Tripathi
    Bindhyesh Tripathi 6 days ago

    Thanks you sir for this series

  • HRISHIKESH RANE
    HRISHIKESH RANE 6 days ago

    Thank You sir.

  • Lucky Mane
    Lucky Mane 6 days ago

    Thanks for uplaod new series for power pivot please start series on Dax function nice vdo

  • Saqlain Shaikh
    Saqlain Shaikh 6 days ago

    Thanks Ajay sir

  • Anand Pillay
    Anand Pillay 6 days ago

    Namsate Guruji, Please show how to create the progress bar in VBA while copy paste the Data From Access to Excel . % Progrress bar Or 1 out of 10 like this.

  • Sujeet Kumar
    Sujeet Kumar 7 days ago

    Great

  • renuka rai
    renuka rai 7 days ago

    Hey hi ajay I m Getting error user defined not found for do while

  • Manoj Yadav
    Manoj Yadav 7 days ago

    Entire email is not coming in excel

  • Manjunath J
    Manjunath J 7 days ago

    Hello Sir, how to create a dynamic pivot, which can auto refresh when there is a change in the table?

  • Bhagat Singh Tiwari

    Aaj se aapke video suru kiye hain ajay bhai

  • POOJA
    POOJA 7 days ago

    Sir agar humne VBA ki puri coding kr di or ab hume pura data excel sheet pr lana hai to hum f8...f8.... press karte rahenge. Agar bahut sara data hua to ek bar me run nhi kar sakte

    • POOJA
      POOJA 7 days ago

      @Ajay Kumar ok.

    • Ajay Kumar
      Ajay Kumar 7 days ago

      Check introduction series

  • Manoj Yadav
    Manoj Yadav 8 days ago

    I am getting run time error 13

  • Manoj Yadav
    Manoj Yadav 8 days ago

    its not working for me using the same code kindly suggest

  • bhanubhusan sarkar
    bhanubhusan sarkar 8 days ago

    VERY NICE SIR. I AM LUCKY TO HAVE KNOWLEDGE OF JAVA,VB 2010, ECLIPSE, NETBINS AND SO MANY SOFTWARE. YOUR SERIES HAS HELPED ME LOT. THANK YOU VERY MUCH. MAY GOD BLESS YOU FOR FURTHER PROGRESS

  • Shreekant Vishwakarma

    Sir can u make one more video on web scrapping to automate web calander. It is very diffcult to automate it. Thanks in advanced

  • uday narayan Singh
    uday narayan Singh 8 days ago

    SIR, IF MY ARRAY IS IN OTHER FILE THEN HOW TO DECLAIR MYARRAY ?

  • Sally Chau
    Sally Chau 8 days ago

    Thanks for this! Can unmatched query be used for 3 tables?

  • Bindhyesh Tripathi
    Bindhyesh Tripathi 8 days ago

    Nice video

  • Rana Singh
    Rana Singh 8 days ago

    CTRL+G wala example zabardast tha Sir, you are absolutely amazing & rocking Sir...!!

  • POOJA
    POOJA 8 days ago

    Sir apne java ki bhi video bana rakhi hai kya?

  • Santosh Kumar
    Santosh Kumar 9 days ago

    Superb...

  • noorul hasan
    noorul hasan 9 days ago

    Is there is. Any way to change the BG color of email in outlook (row color). I have searched over online I couldn't find right and only option to change the theme color and font color of email. Is there any change in vba?.

    • noorul hasan
      noorul hasan 8 days ago

      Thanks for your reply sir. I googled most of them saying we can use the few themes given by Microsoft . Any way in vba?

    • Ajay Kumar
      Ajay Kumar 9 days ago

      U need to google. I heard some outlook template can be used..

  • Vipin Goswami
    Vipin Goswami 9 days ago

    Sir u doing really good job, i got job as vba developer and ur videos really help me alot. Thank you again❀

  • janardan rajput
    janardan rajput 9 days ago

    now xlookup is come there is also 5 parameters

    • Ajay Kumar
      Ajay Kumar 9 days ago

      @janardan rajput it's on beta testing and not launched fully.. Let's wait

    • janardan rajput
      janardan rajput 9 days ago

      but for your afforts hatts offf.....

  • Saleem Malik
    Saleem Malik 10 days ago

    Hi, I'm getting run-time error 462 remote server machine does not exist or is unavailable, at set idoc = i.document

    • Saleem Malik
      Saleem Malik 9 days ago

      @Ajay Kumar on loop also giving the same error

    • Ajay Kumar
      Ajay Kumar 9 days ago

      Use loop.. Till site doesn't load it keeps looping

  • Jugnu Singh
    Jugnu Singh 10 days ago

    Thank you Sir!

  • Ansari Irfan
    Ansari Irfan 10 days ago

    Sir.. really helpful information u have provided.. thank you. I would like to continue this vba lactures sequence wise. So please let us know what will next after these 5 videos?

  • Somanath Biswal
    Somanath Biswal 10 days ago

    Nice Sir