1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
Excel Power Query Tips and Techniques Preview

Excel Power Query Tips and Techniques

With Oz du Soleil Liked by 1,847 users
Duration: 51m Skill level: Intermediate Released: 10/14/2019

Start my 1-month free trial Buy for my team

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

4.8 out of 5

837 ratings
  • 5 star
    Current value: 691 83%
  • 4 star
    Current value: 116 14%
  • 3 star
    Current value: 20 2%
  • 2 star
    Current value: 5 <1%
  • 1 star
    Current value: 5 <1%
  • Vardan Kukreti Vardan Kukreti

    Vardan Kukreti

    Aspiring Data Analyst | 7+ Years Accounting Experience | Certified in Excel, Power BI, Power Query | Turning Financial Data into Insights

    4/5 May 5, 2025
    Very useful!
    Helpful · Report
  • Rich Smillie Rich Smillie

    Rich Smillie

    Reporting Manager | APM | Prince2 | BA Hons | PBI | Data Analytics | Reporting | Project Management | Trend Analysis | Data Modelling | Performance…

    5/5 February 18, 2025
    Very useful
    Helpful · Report
  • Irfan Khan Irfan Khan

    Irfan Khan

    Quality Assurance - RCM

    5/5 January 14, 2025
    Practice material are real helpful by Instructor and his explanation
    Helpful · Report

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.

Download on the App Store Get it on Google Play