15:49
Jun 4, 2022
0
0
'Excel has always been able to do sophisticated calculations with the information you feed it, but this revolutionary new tool can actually fetch data from over 100 types. Movies, music, food, exercises, yoga poses, animals, planets, landmarks, cities, names etc. Excel\'s new partnership with Wolfram (a data repository) makes Excel a more efficient research tool than web browsing in certain ways. I walk through how to get started, what kind of fields you can pull out, and how to interact with it, with formulas, and how this integrates with Dynamic Arrays, the other huge recent update to Excel. At this time, Wolfram data types are not available for corporate subscriptions but this is coming soon so check for updates on this description. Power BI linked data types: https://youtu.be/ZJUSZQoVTwM Dynamic arrays: https://youtu.be/r4tD5PioqMA Dynamic arrays in Google Sheets: https://youtu.be/14Uo4gMRsFw 00:00 - Movies 01:07 - Food 03:06 - Create linked data types 03:50 - Card 04:20 - Add into to the grid 04:48 - Right click options & change 06:00 - Tables 06:45 - Write out formulas 07:16 - Arrays in data types 07:32 - TRANSPOSE 07:44 - Drilling down with formulas 08:37 - Dynamic arrays 09:36 - What data types & licenses 10:19 - Which Excel version? 10:36 - Names data type 11:02 - Planets 11:21 - Medicines 11:34 - Organs 11:46 - Animals 12:15 - Landmarks 12:53 - Geo & location double data type 13:39 - Power BI data types 14:19 - Fictional characters 14:34 - IFERROR 15:02 - Filtering data types'See also:
comments