Power Query is the newest Excel tool for scrubbing your data. If you use functions like Text to Columns, macros, text functions, date functions, or VLOOKUP, Power Query can replace them with a more powerful, flexible, and easy-to-use tool. Sound good? Download the guide to see more about this incredible tool.
Related everyday office posts
Building a Color-Coded Calendar Grid in Excel
People are always badmouthing Excel and working in various new and powerful data visualization tools. In this video, we duplicate...
Going Text to ROWS with Power Query
Text to Columns is a common tool in Excel (although the Text to Columns feature in Power Query, called Split...
