Oct

14

2019

Excel Power Query Tips and Techniques

Laser 14 Oct 2019 18:25 LEARNING » e-learning - Tutorial

Excel Power Query Tips and Techniques
MP4 | Video: AVC, 1280x720 30 fps | Audio: AAC, 48 KHz, 2 Ch | Duration: 51m 36s
Skill Level: Intermediate | Genre: eLearning | Language: English + Subtitles | Size: 145 MB

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.
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

DOWNLOAD
uploadgig



rapidgator


nitroflare

High Speed Download

Add Comment

  • People and smileys emojis
    Animals and nature emojis
    Food and drinks emojis
    Activities emojis
    Travelling and places emojis
    Objects emojis
    Symbols emojis
    Flags emojis