Content addresses some common encounters like how to efficiently use power query's drill-down function to automate your variables and the different join types. However, the depth and scope were somewhat elementary for the more advanced users, and so the content is perhaps better suited for beginners just trying to move into the intermediate. Also received an extra 2 CPE NABA credits while at it which is a great benefit too!
Excel Power Query Tips and Techniques
With Oz du Soleil
Liked by 1,706 users
Duration: 51m
Skill level: Intermediate
Released: 10/14/2019
Course details
Learn timesaving tips on using Power Query, also called Get & Transform, a data connection technology that simplifies gathering, connecting, combining, and refining data in Microsoft Excel and Power BI Desktop. Power Query is simple to use but can be especially powerful when you learn a few techniques. In this course, instructor Oz du Soleil demonstrates customizing your Excel environment, then dives into organizing your work. He offers strategies for working with queries including referencing, duplicating, and renaming queries. Finally, Oz shows how to approach tasks where Power Query works differently from Excel.
Skills you’ll gain
Meet the instructor
Learner reviews
-
Jude Katatumba CPA, MBA, MAcc
Jude Katatumba CPA, MBA, MAcc
Director of Accounting & Financial Reporting, CITY OF DETROIT
-
Luke Devine
Luke Devine
--
Contents
What’s included
- Practice while you learn 2 exercise files
- Test your knowledge 3 quizzes
- Learn on the go Access on tablet and phone
- Stay up to date Continuing Education Units