Want to get your hands on Power Query Quick Steps? ▶ Get Power Query Quick Steps - exceloffthegrid.com/academy ▶ Learn about Power Query Quick Steps - exceloffthegrid.com/quick-steps
@strangerstranger8360Ай бұрын
Impressive! This is a good demonstration of why a company should be ready to pay for Academy subscription!
@ExcelOffTheGridАй бұрын
This is just a tiny part. It's all the other parts that make the Academy subscription so worthwhile.
@kebincuiАй бұрын
Awesome👍👍
@mohammedelsakally540Ай бұрын
Thank you Mark for your always valuable video's you are providing to us ...
@ExcelOffTheGridАй бұрын
My pleasure!
@GrainneDuggan_ExcelАй бұрын
Great tool Mark to save doing repetitive steps.
@ExcelOffTheGridАй бұрын
Thanks Grainne - I appreciate that.
@lauphyon29 күн бұрын
How to add EOTG? I couldn't find it. Thank you!
@ExcelOffTheGrid27 күн бұрын
It’s available in our membership academy.
@chrism9037Ай бұрын
Thanks Mark, great video
@ExcelOffTheGridАй бұрын
Glad you enjoyed it
@analysiscloudАй бұрын
Wow! The work you have put in to complete this! You have not only built an Excel Add-In but taken the time to build all those functions! And the functions are general enough to cope with the many different table types etc. Amazing! That said, I do think Office Scripts would be my first choice in handling this. I would format both ranges as tables with the word "Breakdown" delimiting the two tables. Then, remove the null columns, null values and so on. With the Macro recorder and your preferred ChatBots' assistance most people should be able to write the script code. Where the code was not able to cope with the transformations I would probably add one or two helper tables(then can reside on other worksheets if necessary) and hide them later. Then, I would use good old Excel formulas maybe even a Lambda function., to complete the transformation. This solution would not require the user to, even, open the workbook in desktop mode. A Power Automate Flow could trigger the workbook update. 🤓
@ExcelOffTheGridАй бұрын
You know I love Office Scripts, but the issue is use-case/environment rather than the actions themselves. If PQ comes to Excel Online, the combo of PQ, PA and OS will be incredible.
@analysiscloudАй бұрын
@@ExcelOffTheGrid Hi Mark, Power Query in Excel can be replaced by its online cousin - Dataflow. See my new demo video on exactly this announced on Linked in yesterday. In the case of an Excel data source the Dataflow would use that as the source, of course. In my demo, below, I use Dataverse for the demo. Can all of your functions be, easily, transferred/used in Dataflow? That is the remaining question. See my 6 minute video: kzfaq.info/get/bejne/gp6gi8qFu57Mf3k.html Les
@JediPhantomАй бұрын
So you need a perpetual license or subscription to use this?
@ExcelOffTheGridАй бұрын
It's available in our membership academy. There is a minimum of 1-month subscription to gain initial access, but after that there is no requirement for on-going subscription.
@dennis5188Ай бұрын
Are you saying that even with just a one month subscription, and then cancelling, I will have the ability to keep using this M code assistance function? The problem with M code is that I don't know which syntax to use as there are so many of them, how will this help me?
@ExcelOffTheGridАй бұрын
Our goal is to help people use Excel in the right way so they can save time, stop working late and spend more time with the children, or doing what they love. The membership has tools/downloads which help our members to do that as quickly as possible. None of those downloads have on-going fees, and can still be used if members cancel (we are not a software company, so we are not about locking people into on-going payments for tools). Last week, we had a live masterclass session called "Understanding M Code", with Q&A afterwards. This would would have provided you all the knowledge the apply the correct M syntax. This is why our members rarely leave, because we are continually trying to add benefit.
@JenMayBАй бұрын
Hi Mark - im having a horrible time figuring out how to extract the 7-digit value that starts with a “6” that is anywhere in a text string.
@ExcelOffTheGridАй бұрын
I can think of a few different ways to approach it. But without seeing the data it would be impossible to advise.
@storieswithtarasharma2914Ай бұрын
Its Ok you have provided these but these functions can not replace M
@ExcelOffTheGridАй бұрын
Given that the functions are written in M, then no, we definitely cannot replace M. That is also why we use the term “easier for longer”, because we can never replace M.
@dharmmuАй бұрын
Its just promotional video. Nothing to learn. 🙄
@ExcelOffTheGridАй бұрын
For a lot of Power Query users, this is exactly the tool they need to prevent months of wasted time, and to stop them giving up on Power Query. So, in all honesty, it would be remiss of me not to tell people about it.
@analysiscloudАй бұрын
I, for one, learnt lots watching this video. So, I disprove your statement.
@dharmmuАй бұрын
@@analysiscloud if you don't have his inbuilt function and you tried doing any of the examples practically as shown in this video and you succeeded to complete it. Then you are genius.👍..good luck for your future...
@cyclingmcАй бұрын
Subscription is a bad idea and money grab. I’m sure AI can create this for you. Offer a flat fee.
@ExcelOffTheGridАй бұрын
You do not need an on-going subscription to continue to use the tool. Some of these could written with AI. But AI cannot give you months of user testing, performance optimization testing and live support to assess your situation and advise on the best methods to take. Unfortunately one-time purchase doesn’t work when you provide live training, live Q&A and develop solutions specifically for the needs of the members. If I want to be continually invested in ensuring the members succeed, then a membership is the only model that works.