Abhay Gadiya
Abhay Gadiya
  • 293
  • 375 318

Video

Top 500 companies in India list extracted in Excel
zhlédnutí 46Před 14 dny
This video shows how can you quickly get ET 500 companies list in Excel without lot of formatting and performing complex steps
SUMIFS not working on multiple sum column range full video #excel #exceltips #sumifs #exceltutorial
zhlédnutí 182Před 28 dny
SUMIFS not working on multiple sum column range full video #excel #exceltips #sumifs #exceltutorial
Interactive Chart with slicer displaying highest and lowest sales month new #exceltricks #charts
zhlédnutí 217Před 2 měsíci
Interactive Chart with slicer displaying highest and lowest sales month new #exceltricks #charts
Long Term Capital Gain on shares purchased before Jan 31, 2018 #ltcg #capitalgaintax #capitalgain
zhlédnutí 2,4KPřed 2 měsíci
Long Term Capital Gain on shares purchased before Jan 31, 2018 #ltcg #capitalgaintax #capitalgain
Totals inside Pivot Tables are incorrect how to resolve it.
zhlédnutí 195Před 2 měsíci
Totals inside Pivot Tables are incorrect how to resolve it.
How to do approximate Match inside Power Query
zhlédnutí 165Před 2 měsíci
How to do approximate Match inside Power Query
Getting Serial number starting 1 to 1000 instantly
zhlédnutí 272Před 2 měsíci
Getting Serial number starting 1 to 1000 instantly
Unpivot columns using excel formulas
zhlédnutí 225Před 2 měsíci
Unpivot columns using excel formulas
How to get distinct count inside pivot table full video
zhlédnutí 66Před 3 měsíci
How to get distinct count inside pivot table full video
India Elections 2024 - predicted seat winning by party presented in waffle charts.
zhlédnutí 340Před 3 měsíci
India Elections 2024 - predicted seat winning by party presented in waffle charts.
Unpivot Dataset using Excel formula #exceltips #exceltech #exceltricks
zhlédnutí 245Před 3 měsíci
Unpivot Dataset using Excel formula #exceltips #exceltech #exceltricks
Waffle Charts inside Excel to show percentage of completion of a project or task.
zhlédnutí 197Před 3 měsíci
Waffle Charts inside Excel to show percentage of completion of a project or task.
SUMIFS with OR criteria full video
zhlédnutí 179Před 3 měsíci
SUMIFS with OR criteria full video
Dumbbell Chart All the steps inside Excel
zhlédnutí 336Před 3 měsíci
Dumbbell Chart All the steps inside Excel
Dumbbell Charts Introduction
zhlédnutí 154Před 3 měsíci
Dumbbell Charts Introduction
How to open same Excel file multiple times and compare the Excel sheets
zhlédnutí 276Před 3 měsíci
How to open same Excel file multiple times and compare the Excel sheets
Horizontal Bar chart with Long Labels
zhlédnutí 522Před 4 měsíci
Horizontal Bar chart with Long Labels
Unstack Shorts
zhlédnutí 39Před 4 měsíci
Unstack Shorts
Unstack with Sequence & Replace command
zhlédnutí 91Před 4 měsíci
Unstack with Sequence & Replace command
Referencing Intermediate steps from other Power query
zhlédnutí 525Před 7 měsíci
Referencing Intermediate steps from other Power query
Treemap Chart Intro
zhlédnutí 1,9KPřed rokem
Treemap Chart Intro
Extract Day number of week and assign it to respective column for day of week
zhlédnutí 315Před rokem
Extract Day number of week and assign it to respective column for day of week
Convert Multiple Column Groups to Rows - Power Query Challenge
zhlédnutí 2,4KPřed rokem
Convert Multiple Column Groups to Rows - Power Query Challenge
Butterfly chart in Excel using Data bars from conditional formatting
zhlédnutí 12KPřed 3 lety
Butterfly chart in Excel using Data bars from conditional formatting
Hortizontal Stacked Bar chart in Excel - better alternative method
zhlédnutí 26KPřed 3 lety
Hortizontal Stacked Bar chart in Excel - better alternative method
How to created multiple line area chart stacked in Excel - advanced excel customised
zhlédnutí 713Před 3 lety
How to created multiple line area chart stacked in Excel - advanced excel customised
How to create multiple line chart stacked in Excel - Advanced Excel customised
zhlédnutí 3,9KPřed 4 lety
How to create multiple line chart stacked in Excel - Advanced Excel customised
Small multiple stacked column chart in Excel
zhlédnutí 1KPřed 4 lety
Small multiple stacked column chart in Excel
Introduction to small multiple stacked column chart in Excel
zhlédnutí 513Před 4 lety
Introduction to small multiple stacked column chart in Excel

Komentáře

  • @PowerMacro
    @PowerMacro Před dnem

    Nice Trick Sir

  • @aarish1337
    @aarish1337 Před 5 dny

    Can we make the filter dynamic?

    • @abhaygadiya2207
      @abhaygadiya2207 Před 5 dny

      @@aarish1337 will need VBA code to make it dynamic or else needs to use power query

    • @aarish1337
      @aarish1337 Před 5 dny

      @@abhaygadiya2207 can u show using power query?

    • @AbhayGadiya
      @AbhayGadiya Před dnem

      Sure, actually using the FILTER function it can be made dynamic. No need for VBA. Will try to create a video for it.

  • @shubhabratadey
    @shubhabratadey Před 7 dny

    This is exactly what I was looking for. Just a question, if I do any steps in Query 1 and 2 that wouldn't affect the Mother Query 'Sales' table...right? Also, while trying to use your steps, I am getting this error Formula.Firewall: Query 'XXXX' references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. How can I address this?

  • @meshi7999
    @meshi7999 Před 10 dny

    GOOD SIR

  • @giridarn2607
    @giridarn2607 Před 14 dny

    👏🏽👏🏽

  • @AAKASHKUMAR-sc3ps
    @AAKASHKUMAR-sc3ps Před 14 dny

    Nice one, i have literally viewed multiple videos for this

    • @AbhayGadiya
      @AbhayGadiya Před 14 dny

      Thanks, there is one more coming soon on the same topic so stay tuned.

  • @PowerMacro
    @PowerMacro Před 15 dny

    Go to get data and select from web, paste the link extract entire record

    • @AbhayGadiya
      @AbhayGadiya Před 15 dny

      Try it and let me know if it works on this site. Also, I wanted to show the WRAPROWS function in this video, how useful it is.

    • @PowerMacro
      @PowerMacro Před 15 dny

      @AbhayGadiya Abhay Sir, sure I will try, by my comment I am not coutering your expertise. I am showing another method of doing it. I know you are the best on excel.

    • @AbhayGadiya
      @AbhayGadiya Před 15 dny

      @@PowerMacrothanks for appreciation. In the short video I could not show the challenge with the approach you mentioned. Your approach is correct and it works only on a few websites. So this video is where it does not work

  • @amandeepsinghbassi1600

    Kindly upload playlist of power bi and power query OR provide coupon for all courses access coz 15 Aug coming

    • @AbhayGadiya
      @AbhayGadiya Před 16 dny

      Check out my courses here - www.udemy.com/user/abhay-gadiya/

  • @afeesakanni
    @afeesakanni Před 21 dnem

    Thanks for the tutorial. Kindly consider sharing exercise files so one can follow as they watch.

  • @aarish1337
    @aarish1337 Před 21 dnem

    Really good. Can we use sumproduct in any way in this?

    • @AbhayGadiya
      @AbhayGadiya Před 21 dnem

      Yes, in the older version you have to use SUMPRODUCT

  • @bettydominguez8467
    @bettydominguez8467 Před 25 dny

    Can you show how to do this while having an overlapping bar chart with a long label above it? Any suggestions?

    • @AbhayGadiya
      @AbhayGadiya Před 15 dny

      With Excel it's not possible with the current options

  • @afeesakanni
    @afeesakanni Před 27 dny

    Awesome tip here. At first, only 3/4 of the names I wanted were printed until I realised one exceeded the number of characters (31) for naming a sheet. Then it worked perfectly.

  • @afeesakanni
    @afeesakanni Před 28 dny

    Awesome one, Abhay ji. Thank you.

  • @wanderleihuttel
    @wanderleihuttel Před 28 dny

    That's interesting. Another possibility would be to use the "BYCOL" function. =SUM(BYCOL(C5:F15, LAMBDA(AMOUNT, SUMIFS(AMOUNT, B5:B15, B2))))

  • @amitpatel75
    @amitpatel75 Před 28 dny

    amazing tips , tricks you have shared , thanks can you make short video to teach us how to highlight blue color to all banana rows like you show in this video.

    • @AbhayGadiya
      @AbhayGadiya Před 28 dny

      Sure, will do it. Thanks for appreciation, please do share with others and support the channel.

  • @Pachputeanuj
    @Pachputeanuj Před měsícem

    Far better than so called cource seller

  • @afeesakanni
    @afeesakanni Před měsícem

    Hello, Abhay ji. Thank you for this tutorial. I am curious to know what you have as "ASAP Utilities" in your ribbon. Perhaps you want to share some productivity hacks with your teeming CZcams students. Thank you.

    • @AbhayGadiya
      @AbhayGadiya Před měsícem

      It's a free addin, you can google it and use it.

  • @afeesakanni
    @afeesakanni Před měsícem

    This is arguably one of the best courses I have come across on CZcams. Thanks for putting this up. It has been of great help. Thank you, Abhay Ji. You have my respect.

    • @AbhayGadiya
      @AbhayGadiya Před měsícem

      Thanks a lot for your appreciation. Please share in your circle of influence and support.

  • @unnikrishnansanthosh
    @unnikrishnansanthosh Před měsícem

    wonderful, thank you for sharing

  • @OmPrakashLalKarn-b2v
    @OmPrakashLalKarn-b2v Před měsícem

    You are save the time sir

  • @CANILESHKUCHERIYA
    @CANILESHKUCHERIYA Před měsícem

    Transpose Unique Filter 👍

  • @Tanish-eb1fl
    @Tanish-eb1fl Před měsícem

    Nice sir ❤

  • @amyspringrose9231
    @amyspringrose9231 Před měsícem

    Amazing effective explanation, tks so much !

  • @venkataramanadevuri4844
    @venkataramanadevuri4844 Před měsícem

    Good explanation. But Where will I get FMV of the unit as on 31 jan 2018

    • @AbhayGadiya
      @AbhayGadiya Před měsícem

      From BSE or NSE site bhav copy

    • @venkataramanadevuri4844
      @venkataramanadevuri4844 Před měsícem

      Than q sir​@@AbhayGadiya

    • @HariPrasad-bc3ub
      @HariPrasad-bc3ub Před měsícem

      For me FMV is less than the purchase price ( for suzlon) , so it is considered to pay tax. 😢

    • @HariPrasad-bc3ub
      @HariPrasad-bc3ub Před měsícem

      Thank you, many people who demo ITR-2, skipping shares which was bought before 2018, you covered this.

  • @NomanKhan-ii9oo
    @NomanKhan-ii9oo Před měsícem

    Impressive

  • @giridarn2607
    @giridarn2607 Před 2 měsíci

    👌🏽

  • @giridarn2607
    @giridarn2607 Před 2 měsíci

    Tks

  • @sagyshehata3616
    @sagyshehata3616 Před 2 měsíci

    wow

  • @mirrorreflection3479
    @mirrorreflection3479 Před 2 měsíci

    How do you come up with all these awesome tricks which I have not seen even some of the famous channels doing them.

  • @mirrorreflection3479
    @mirrorreflection3479 Před 2 měsíci

    Genius

  • @robbobtc8742
    @robbobtc8742 Před 2 měsíci

    Very useful. Thank you.

  • @AmeeraHazmar
    @AmeeraHazmar Před 2 měsíci

    Superb

  • @himadrisubhradas
    @himadrisubhradas Před 2 měsíci

    excellent

  • @ndiwalanaisaac5558
    @ndiwalanaisaac5558 Před 2 měsíci

    Thanks

  • @ubaidillahmuhammad20
    @ubaidillahmuhammad20 Před 2 měsíci

    Nice. give the files in the description

  • @caganeshpanchal7295
    @caganeshpanchal7295 Před 3 měsíci

    Thanks Abhay Sir for wonderful Excel trick.Very Useful formula. Keep Sharing

    • @AbhayGadiya
      @AbhayGadiya Před 3 měsíci

      Thanks, please share and subscribe.

  • @AN-fl6rz
    @AN-fl6rz Před 3 měsíci

    Great video…! Really helpful. My sincere gratitude sir!

  • @tippusultan6726
    @tippusultan6726 Před 3 měsíci

    Sir, Please provide excel files used in your video for practice. Thanks.

  • @tippusultan6726
    @tippusultan6726 Před 3 měsíci

    Dear sir, It would be of great help to provide / upload data file as well. Regards.

  • @tippusultan6726
    @tippusultan6726 Před 3 měsíci

    Thanks for the help. Please provide the Data file used. Regards.

  • @mikehaynes8638
    @mikehaynes8638 Před 4 měsíci

    How is the performance using this method versus creating an extracted version of the referenced query?

    • @AbhayGadiya
      @AbhayGadiya Před 4 měsíci

      I have not tested that yet.

    • @mikehaynes8638
      @mikehaynes8638 Před 4 měsíci

      @@AbhayGadiya thanks. This method is great. I’m hoping someday that there’s a trick that caches the source query to only run once and every dependency can use that cache. Would greatly improve performance.

    • @tmb8807
      @tmb8807 Před 3 měsíci

      @@mikehaynes8638 Agree. Seems pretty glaring. The only way I've found that forces the data source to be hit only once is to load the 'intermediate' step to a worksheet, and then use the worksheet as the source for any subsequent queries. But that obviously means you end up with a superfluous worksheet (and it won't be of any use if your dataset contains more than 1m rows).

  • @amandeepsinghbassi1600
    @amandeepsinghbassi1600 Před 4 měsíci

    very informative

  • @amandeepsinghbassi1600
    @amandeepsinghbassi1600 Před 4 měsíci

    thanks, abhay sir keep uploading videos regularly amd share practice file also

  • @PriyankSaraf-ej5cq
    @PriyankSaraf-ej5cq Před 4 měsíci

    thanks, very helpful

  • @amandeepsinghbassi1600
    @amandeepsinghbassi1600 Před 4 měsíci

    thanks abhay sir for this awesome playlist on POWER BI ..

  • @muralichennu5651
    @muralichennu5651 Před 4 měsíci

    Thank you

  • @khaledjamal9807
    @khaledjamal9807 Před 6 měsíci

    thank you Sir.

  • @shivasai25
    @shivasai25 Před 6 měsíci

    Highly appreciated for your efforts bringing this concept here Thanks

  • @rahulkalbhor1
    @rahulkalbhor1 Před 7 měsíci

    Saved so much time.. thank you so much sir💐💐

  • @Domble22
    @Domble22 Před 7 měsíci

    thank you