The Story
Most Excel users still wrangle their data with hard-to-read formulas, copying and pasting, and a myriad of steps they’ve perfected over the years to get the data just right. What many don’t know is that Microsoft has taken a long hard look at this workflow and created a technology to streamline it. Enter Power Query. Despite the name, it is not a very complicated tool. This course will create a sense of familiarity, ensuring students feel comfortable retrieving data from any source and using Power Query to slice and dice it.
Description
Most Excel users still wrangle their data with hard-to-read formulas, copying and pasting, and a myriad of steps they’ve perfected over the years to get the data just right. What many don’t know is that Microsoft has taken a long hard look at this workflow and created a technology to streamline it. Enter Power Query. Despite the name, it is not a very complicated tool. This course will create a sense of familiarity, ensuring students feel comfortable retrieving data from any source and using Power Query to slice and dice it.