A Beginner’s Guide to Power Query - Knack Training

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

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

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