Are Prereqs Recommended?

Yes, they are recommended only, and nothing is required for this course. We will say that for some it will enhance the experience to explore some of the recommendations before your session. The benefit to you is that it will confirm you have the general understanding to get the most of this course. Recommendations You need to know at least generally about Power Query and what it is about. You don't need to know a lot about it, but you should know what it is and how to access it.

What exactly do you cover in this course?

This course really breaks down into the three major categories. Understanding the more advanced data transformation features in Power Query Understanding how to work with the Advanced Editor Understanding how to automate routine data cleaning and modeling tasks

Who is this course designed for?

This course is designed for the rising Excel user who is comfortable with the basics and looking for more. It's also good for experienced users who have heard about what Power Query can do and want to know how to make use of it in their own work.

What technologies are you using in the course?

We focus on Microsoft Excel in this course, specifically Microsoft Excel 2016 or later (earlier versions do not include Power Query). If you have more questions on this, please contact us.