Excel Power Query Tips and Techniques

English | 51m 36s | Video 720p | Subtitles | Project File

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.

Topics include:

 

Customizing your environment

Disabling data type auto detect

The Power Query function library

Staying organized

Referencing queries

Testing and development

Duplicating vs. referencing a query

Renaming queries

Power Query peculiarities

Filtering and sorting

 

Homepage:

https://www.lynda.com/Excel-tutorials/Excel-Power-Query-Tips-Techniques/2814037-2.html