Learn how to do a bulk find and replace in power query based on a list of values.
Bulk Find And Replace In Power Query
read more
Replicate Excel’s TRIM Function In Power Query
Learn how to build a custom query function in power query that will replicate Excel’s TRIM function.
Introduction To Power Query M Code
Learn the basics of power query’s M code language with this complete guide to M code.
Import XML Files into Excel
In this post we’ll take a look at how to import an XML file into Excel and turn it into a more human readable table format. Excel has support for XML files and it’s actually really easy to import and covert them to tables using Power Query
25 Amazing Power Query Tips and Tricks
Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. Here are some tips and tricks to help you get the most out Power Query.
Create Grouped Serial Numbers with Power Query
Learn how to add grouped serial numbers to your data using Power Query.
Get The Latest News
Follow Us
Follow us on social media to stay up to date with the latest tips in Excel!