The Excel Encyclopedia: Food, movies, music ++ with Wolfram data types

Описание: 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:    • Power BI featured tables to Excel linked d...  
Dynamic arrays:    • Dynamic Arrays 5 best & 5 worst features f...  
Dynamic arrays in Google Sheets:    • Google Sheets: Dynamic Arrays - SORTN, SPL...  

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