Home » Education » Creating a Custom Data Type with Power Query; including XLOOKUP and Dynamic Arrays

Creating a Custom Data Type with Power Query; including XLOOKUP and Dynamic Arrays

Written By Excel On Fire (Oz du Soleil) on Saturday, Oct 31, 2020 | 12:48 AM

 
The new Custom Data Types are starting to be rolled out and they're ... exciting ... interesting ... spooky. This video will be the first of several that will explore the Custom Data Types, how they can be used and where to watch for GOTCHAs. In this video we create a basic Custom Data Type using information about specialists. We have their names, contact info, specialties, birthday and school data. Later we add in their hourly rates by using XLOOKUP. #XLOOKUP #CustomDataTypes #PowerQuery You also see the FILTER function for Dynamic Arrays. GOOD STUFF! 🎉 For a list of my Excel courses at Lynda/LinkedIn: https://www.linkedin.com/learning/instructors/oz-du-soleil There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday. Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My old blog: http://datascopic.net/blog-2-2

Disclaimer:
All images, musics and videos copyright are belong to their respective owners. We just put embed contents from Youtube.com and do not host any content in our server. These content(s) may be protected by copyright law or other laws regarding intellectual property of the United States or other countries. Downloading file(s) on this site is just for review purpose. If you love the song, please support the artists by buying the original CD/Cassette or buying the song from iTunes.