MrExcel Excel Videos

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.

Michel asks how to get the chart trendline coefficients from the chart into the grid. Table of Contents (0:00) Question from Michel (0:27) Adding a trendline to a chart with the formula (1:14) How to tell if your Excel has Dynamic Arrays (1:30) Entering LINEST function with additional statistics (2:54) Entering LINEST with Ctrl+Shift+Enter (Before Dynamic Arrays)

For cyclists who ride with a Polar Heart Rate Monitor and use the Polar Flow App to track your rides. This video shows how you can export a ride from Polar Flow and import that data into Excel. The visualization in this analysis shows speed and heart rate on a map. Table of Contents (0:00) Welcome (2:15) Demo of finished visualization (8:36) Exporting Data from Polar Flow (10:41) Importing & Cleaning Data using Power Query (18:14) Mapping the Data (23:41) 3D Map navigation tips Excel Virtually Global Conference: 50+ Hours of Excel Training for US $24 With Proceeds to Charity

Soon, Excel's Rich Data Type feature (aka Project Yellow) will be expanding with 100 new data types. Read the Microsoft blog post here: Introducing the new Microsoft 365 Personal and Family subscriptions Recently, a question arose: Where is Excel storing the fields in the data type? In this episode, I will show you how to crack the Excel Workbook open and find that the information is actually stored in the workbook. Table of Contents: (0:00) Welcome and Discussion of the new Data Types coming (0:30) 100 New data types coming to Excel (1:38) Renaming XLSX file to Zip File (2:18) Looking inside the XML files for Geography Fields (3:30) Thanks and Subscribe