It is incomprehensible to the mind how easy and simple it is to clear data using Power Query in Excel or Power BI! Our data rarely comes to light in a work-ready form, and it can take us long hours to clean, filter and transform it. Power Query helps reduce this process during the initial processing of data, and all subsequent updates can be reduced to a simple click on a button. When it comes to importing, cleaning and converting source data for further analysis, mastering Power Query can be much easier than learning Excel formulas or the VBA programming language. There is no doubt that Power Query will forever change the way Excel specialists work with data. If you have Excel, then you already have Power Query - this tool is built into Excel 2016 and above.