MrExcel Excel Videos

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

Nick needs to create a chart that will always chart today's data. In this quick episode, how to use =TODAY() and VLOOKUP to return today's data.