New Data Types in Excel - game changer
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 what the New Data Types are and how to use them. It also explains why they can be one of the biggest game-changers in the way we distribute and consume organizational data 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 Spoiler alert 0:14 Excel Olympics Animation 0:22 Geography Data Type 5:31 Stock - Currency Data Type 6:27 People Data Type - Multiple Data Types 12:04 End Screen and Bloopers You can read the accompanying blog post 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-editor.html 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
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 what the New Data Types are and how to use them. It also explains why they can be one of the biggest game-changers in the way we distribute and consume organizational data 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 Spoiler alert 0:14 Excel Olympics Animation 0:22 Geography Data Type 5:31 Stock - Currency Data Type 6:27 People Data Type - Multiple Data Types 12:04 End Screen and Bloopers You can read the accompanying blog post 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-editor.html 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