AuthorOz du Soleil
- 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
- 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.
1. Customizing Your Environment
2. Organizing Your Work
3. Working with Queries
4. Power Query Peculiarities
- 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.Cancel
Take 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.