Excel Power Query Crash Course

Description



This short course will give you the base level knowledge, and a few tips and tricks, that will embolden you to explore the new “Power Query” tool.  It was first launched in Excel 2010 and has only gotten better and easier since then.  It’s purpose is for redundant data clean-up that will then be used in data analysis, charts, and pivot tables. Set up the clean-up steps once and for all, then just refresh each time you need it.

Who this course is for:



   Any Excel user who is tasked with preparing data for further analysis and charts



Requirements



   Must have Microsoft Excel 2010, 2013, 2016, 2019



Last updated 3/2019