It is like the Christmas where you got almost every thing you asked for. The Excel team has given us almost everything I asked for with the new data types. You can now create your own data types in Excel, without help from the I.T. department.
I’ve been out for two months, and while I was away from the computer, I read a book about narrative storytelling in radio. This is a longer video, with a lost of “this happened, then this happened, then this happened”. I am not sure this will become the new normal. But I hope you can put up with it for today.
Table of Contents
(0:00) Welcome & history of Data Types
(1:09) What would you like them to add?
(1:48) Exchange rates done in March 2019
(2:16) Wolfram Alpha data types raised the bar
(2:41) Getting Weather History in Excel
(3:10) What I envisioned versus what they did
(5:03) If I had asked for a sports car…
(5:51) Improved development cycle for Microsoft 365
(7:06) Welcome to the Podcast – Starting Over
(7:23) The struggle between I.T. and the Other Departments
(8:06) Those who can do VLOOKUP versus those who can’t
(8:27) The term “User” is a pejorative when spoken by the I.T. department
(9:01) Plan to create a too-wide data set in Power Query
(9:34) Finishing the last merge to create a wide data set
(10:12) Defining a Data Type in Power Query
(12:38) Using data types in the grid – displaying a card
(13:01) Filtering by a field not in the grid
(13:32) Adding data type fields to the grid and calculating revenue
(14:47) When you get almost everything you ask for