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