Author
Released
10/14/2019- 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
Skill Level Intermediate
Duration
Views
- You've seen Power Query, also called get and transform, and sense its vast capabilities for preparing data. This course will help you truly harness that power and get more from Power Query. You see, things aren't as intuitive, and the interface isn't as robust as it is in native Excel. So I am going to whoop on you some fast bite-sized tips and techniques to help you work more efficiently. I'll provide some insight into the non-intuitive aspects of Power Query. You ultimately, the here's the deal. I'm sharing with you what I think is important for you to know so that you're inspired to play and explore in this vibrant, fascinating wonderland that we call Power Query.
Related Courses
-
Excel Weekly Challenge
with Oz du Soleil5h 18m Beginner -
Excel in the Real World
with Oz du Soleil42m 32s Intermediate
-
Introduction
-
1. Customizing Your Environment
-
View monospaced40s
-
2. Organizing Your Work
-
Rename column1m 24s
-
Rename steps in a query1m 40s
-
-
3. Working with Queries
-
Navigate to new source1m 53s
-
Change load-to destination1m 10s
-
Reference a query4m 9s
-
Rename queries1m 35s
-
Merge queries as new1m 51s
-
-
4. Power Query Peculiarities
-
Filtering in Power Query2m 30s
-
Sorting in Power Query1m 17s
-
Prevent table from resizing1m 12s
-
Transformation table2m 48s
-
Warning: Two types of merges3m 18s
-
Splitting columns1m 14s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Get more from Power Query