 Tip seven, master power query. This is cool. To me, I think this is the number one tip. So I didn't arrange these tips in order. I just typed them all from my head really. But I think this is your number one tip. Go and master power query. And the reason is very simple. Nothing happens without data. Nothing happens. So nothing happens without data. So power query is the data collection God. It is the data, it is the tool that enables you collect data, bring in data, clean up data. In fact, it's an ETL, which means an extract, transform and load tool. That's what it does. It extracts, transforms and loads data, right? So if I come into my, go to Excel, you can see it. Now power query is such an amazing tool. It helps you automate the cleanup process. So it helps you automate, clean up in a wonderful way. So how do you access it? Now it depends on the version of Excel you have. If you have Excel 2010, well, you're out of luck. You shouldn't even have Excel 2010 guys. I mean, you need to update. If you have Excel 2013, well that's when power query was born. So you could download it for free. Think you could also download it for 2010. I'm not sure, but really you shouldn't be using 2010. So Excel 2013, you download power query for free. In Excel 2016, it was added to the data tab. So if you go to the data tab and in Excel 2016, you see it in the data tab next to get external data. So you see something here called get external data and then you see the data tab. Now in Excel, power query is called get and transform data. Because power query is an ETL. It's extract, transform, and loads data for you. So it's called get and transform. You will see it if you have Excel 2016, if you have Excel 2019, but most especially if you have Office 365. If you have Office 365, you would definitely have it here as get and transform. Then when I come to get data, and then you see all the ways you can connect to data. So anytime you're bringing in data, never use anything else, use power query. Now power query is so cool and important that it's everywhere. So Power BI has power query. I think it's called power query in Power BI. In Excel, it's called get and transform. In Azure, when you're using Azure and working with Azure, it's called data flows. So data flows is also power query. It uses the power query and power query has a language, an M language, it's called M. So if I come here, for example, and do a blank query, so I click on a blank query, you're gonna see it's gonna open the power query application. And this application is a click, click, click as you're clicking, you're basically building out, you're building out your power query, power query. Let me pull in the application so you can have a look at it. So hold on a second. So this is the power query application and this is what you use to kind of transform your data. Yeah, so go check it out online. It's cool, as you do stuff, it's recording it here and they're recording, it's a language called M, M language, right? It's really cool stuff. I can't overemphasize how cool this thing is. It's super cool, super, super cool, right? So let me close this, right? Let me just close power query, check it out. And that gives me the two extra skills you need. You need to learn Power Pivot and DAX. You also need to learn Power Query. Let me make it capital, Power Query. And you need to learn this language called M, yeah? So these are skills you must master. If you want to become a guru, you need to know these skills. There's no other choice. And I can tell you once you know the skills, once you know this, you can build enterprise and enterprise scale applications for companies, yeah? Super, let's jump back to our tips.