New Data Types in Excel - Creating Your own - Most influential change for Organizations in Excel
From an organizational standpoint, the New Data Types are the biggest thing that happened in Excel in the last eight years (and that is saying a lot). This video explains how organizations can utilitze the New Data Types. It also explains how a user or organization can create it's own Data Types in Excel.
This tutorial was made using Excel 365, and at the time of filming, the New Data Types are only available in Office 365, and due to the nature of this feature, that is not likely to change soon.
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction
1:46 Creating a Data Type in Excel with Power Query
7:16 Creating an Organizational Data Type in Power BI
11:56 Outro
You can read a blog post about Data Types here: https://bit.ly/3gXE4Eu
And here is another resource explaining the filter behavior: https://bit.ly/35X4Lmj
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission with NO additional charge to you! Thank you for your support!
#Excel #ExcelOlympics #gasperkamensek