Guru-G

Often times, when you get data from a source, there will most probably be something incorrect that needs to be fixed using an ETL process of Power Query. And most of those transformations would require either Replacing or Removing string's that are not necessary. For example, if you extract any financial data from a source which has multiple currency symbols, there's a chance that the numbers get extracted along with the currency symbols like "$700"/"€700" instead of 700. And these type of cases makes it tough to Transform the Data to our wish as the value will be considered as a text instead of a number. In those type of cases, we would most likely have to create multiple steps to remove the multiple currency symbols from the Column. But thanks to the solution provided by Marcel for one of the questions posted on Stack Overflow, with a little manipulation of the Query language (M), we can replace/Remove multiple strings in one step using the List.

You might have seen moving spotlights in a lot of videos. How cool would it be if you can do that in Powerpoint for one of your presentations in School/Office? The above GIF is a fast-forwarded recording of PowerPoint slides. You can replicate this effect using a combination of Crop and the Transitions feature of the powerpoint. Below is a video which explains that process to achieve the above result.