Just like the Guess Your Age booth at the Carnival, Excel can guess your age from your given name. In episode 2348, we will take a look at the Wolfram Alpha data types for Given Name, Fictional Character, Amusement Parks, Notable Texts, and Authors.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
The CONVERT function isn't working with arrays. But the easy solution: Add a unary PLUS sign before the array reference.
Sanjeev needs a function like NETWORKHOURS() but there is no such function in Excel. Bill Jelen from MrExcel and Mike Girvin from ExcelisFun try different approaches for solving the problem.
When Data Types first debuted in Excel, the most-requested additions were Exchange Rates and Weather. Well, Wolfram Alpha didn't mention weather, but there is Weather History for many locations in the new data types.
The new Wolfram Alpha data types in Excel are not as clever as the old data types. This episode shows how to improve the conversion to data types.
Yesterday, in 2342, I complained that the Data Cards from the new Data Types were too **** narrow for all the information offered. Little did I know... they added a resize icon and a whole new way to drill down within the cards! I was wrong. Data Cards in Excel are Awesome!
Tell me your five favorite music acts and I will use Wolfram Alpha Data Types in Excel to guess your age. This is my second video showing the new Wolfram Alpha Data types in Excel.
How to remove a ProPlus subscription from your computer: Reset Microsoft 365 Apps for enterprise activation state - Office
New in Office 365 Home/Student: Wolfram Alpha Data Types. After Excel added Geography and stock data types last year, we now have a hundred new data types. Each is curated content from Wolfram Alpha.
Beyond the new data types, we have several new features:
New! Data Types can return an array of values!
New ARRAYTOTEXT() function and VALUETOTEXT() functions.
A Data Type can return another Data Type!
Data Types can return images (but you will have to resize the cell).
Why isn't there a date picker in Excel? Sam Rad from the Excel team wondered the same thing and has given the world an awesome Date Picker for Excel. It is free from Excel Date Picker — Sam Radakovitz.
In today's episode, I will show you how to use it.
Table of Contents
(0:00) Date picker in Excel
(0:40) More reliable way to load Add-ins
(1:14) Using the Date Picker
(3:00) Launching from Right-Click Menu
