Good instructor and good worksheets, but it would be super helpful to have some examples that we could start from the VERY beginning with and build from the ground up and then manipulate. We're starting all of these from already established queries; I'm still struggling with that aspect.
Excel Power Query Tips and Techniques
With Oz du Soleil
Liked by 1,878 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
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
Kevin B.
Kevin B.
Driving Excellence: Leading AAA Roadside Service Call Centers to Peak Performance with 11 Years of Expertise.
-
-
Janhavi Jha
Janhavi Jha
Senior Analyst @ 7-Eleven | Category & Business Strategy | Retail & Marketplace Analytics | Advance Excel • Power BI • SQL • DOMO| BBA, Marketing
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
Similar courses
Download courses
Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.