Back to resources

A Beginner’s Guide to Power Query

Download PDF file

A Beginner’s Guide to Power Query

ABOUT THE MANUAL

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.

View more about this topic

Related everyday office posts

Youtube videos Building a Color-Coded Calendar Grid in Excel

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...

Youtube videos Going Text to ROWS with Power Query

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...