LIN | Excel Power Query Tips And Techniques (Office 365) (2019 EN)

Company: Linkedin Learning
Author: Oz du Soleil
Full Title: Excel Power Query Tips And Techniques (Office 365)
Year: 2019
Language: English
Genre: Educational: Spreadsheets
Skill Level: Intermediate
Price: €28.92
-
Files: MP4 (+ Exercise Files, Subtitles .SRT)
Time: 00:51:36
Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 200 kbps
Audio: AAC at 128 Kbps, 2 channels, 48.0 KHz



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:
01. Customizing your environment
02. Disabling data type auto detect
03. The Power Query function library
04. Staying organized
05. Referencing queries
06. Testing and development
07. Duplicating vs. referencing a query
08. Renaming queries
09. Power Query peculiarities
10. Filtering and sorting

Our members see more. Join us!
-------------
Our members see more. Join us!