![Abhay Gadiya](/img/default-banner.jpg)
- 293
- 375 318
Abhay Gadiya
India
Registrace 16. 06. 2011
Videos related Excel and other software
Total value changes based on filtered records #shorts #shortvideo #youtubeshorts #excel #trending
How to change SUM value based on filter applied on dataset is explained in this video.
zhlédnutí: 61
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
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.
Dumbbell Chart All the steps inside Excel
zhlédnutí 336Před 3 měsíci
Dumbbell Chart All the steps inside Excel
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 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
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
Nice Trick Sir
Can we make the filter dynamic?
@@aarish1337 will need VBA code to make it dynamic or else needs to use power query
@@abhaygadiya2207 can u show using power query?
Sure, actually using the FILTER function it can be made dynamic. No need for VBA. Will try to create a video for it.
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?
GOOD SIR
👏🏽👏🏽
Nice one, i have literally viewed multiple videos for this
Thanks, there is one more coming soon on the same topic so stay tuned.
Go to get data and select from web, paste the link extract entire record
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.
@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.
@@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
Kindly upload playlist of power bi and power query OR provide coupon for all courses access coz 15 Aug coming
Check out my courses here - www.udemy.com/user/abhay-gadiya/
Thanks for the tutorial. Kindly consider sharing exercise files so one can follow as they watch.
Really good. Can we use sumproduct in any way in this?
Yes, in the older version you have to use SUMPRODUCT
Can you show how to do this while having an overlapping bar chart with a long label above it? Any suggestions?
With Excel it's not possible with the current options
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.
Awesome one, Abhay ji. Thank you.
Thanks
That's interesting. Another possibility would be to use the "BYCOL" function. =SUM(BYCOL(C5:F15, LAMBDA(AMOUNT, SUMIFS(AMOUNT, B5:B15, B2))))
Thanks for sharing
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.
Sure, will do it. Thanks for appreciation, please do share with others and support the channel.
Far better than so called cource seller
Thanks
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.
It's a free addin, you can google it and use it.
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.
Thanks a lot for your appreciation. Please share in your circle of influence and support.
wonderful, thank you for sharing
Thank you
You are save the time sir
Thanks
Transpose Unique Filter 👍
Thanks
Nice sir ❤
Thanks
Amazing effective explanation, tks so much !
You are welcome!
Good explanation. But Where will I get FMV of the unit as on 31 jan 2018
From BSE or NSE site bhav copy
Than q sir@@AbhayGadiya
For me FMV is less than the purchase price ( for suzlon) , so it is considered to pay tax. 😢
Thank you, many people who demo ITR-2, skipping shares which was bought before 2018, you covered this.
Impressive
Thanks
👌🏽
Tks
wow
How do you come up with all these awesome tricks which I have not seen even some of the famous channels doing them.
Thanks a lot for appreciation
Genius
Thanks
Very useful. Thank you.
Thanks
Superb
Thanks 🤗
excellent
Thanks
Thanks
Welcome
Nice. give the files in the description
Thanks Abhay Sir for wonderful Excel trick.Very Useful formula. Keep Sharing
Thanks, please share and subscribe.
Great video…! Really helpful. My sincere gratitude sir!
Glad it was helpful!
Sir, Please provide excel files used in your video for practice. Thanks.
Dear sir, It would be of great help to provide / upload data file as well. Regards.
Thanks for the help. Please provide the Data file used. Regards.
How is the performance using this method versus creating an extracted version of the referenced query?
I have not tested that yet.
@@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.
@@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).
very informative
Glad you think so!
thanks, abhay sir keep uploading videos regularly amd share practice file also
thanks, very helpful
You're welcome!
thanks abhay sir for this awesome playlist on POWER BI ..
Most welcome
Thank you
You're welcome
thank you Sir.
Most welcome
Highly appreciated for your efforts bringing this concept here Thanks
It's my pleasure
Saved so much time.. thank you so much sir💐💐
Welcome 👍
thank you
Welcome!