Power Query made easy - learn the power of Quick Steps

No video

Power Query made easy - learn the power of Quick Steps | Excel Off The Grid

Рет қаралды 9,798

Excel Off The Grid

Күн бұрын

Пікірлер: 30

@ExcelOffTheGrid Ай бұрын

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.

@lauphyon 29 күн бұрын

How to add EOTG? I couldn't find it. Thank you!

@ExcelOffTheGrid 27 күн бұрын

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.