MrExcel Excel Videos

Today, Excel is offering all sorts of support for Geography, from 3D Map, Filled Map, Geography Data Type, and Location Data Types. But there was a secret project way back in 2005 that dabbled in Geography. In this entry for Excel Hash 2021, see how Sam Rad experimented with a function to identify cities along the I-7 corridor (Bakersfield California to Stockton California). While the functions for the remaining interstates were never completed, you could use LAMBDA, or Power Query Custom Data Types, or FILTER to build your own. This is my entry in the 2021 Excel Hash competition. Check out other entries here: This playlist works on a PC: https://www.youtube.com/playlist?list=PLHrPHBbDHgT1OUshE6AFf5AJqJdhKhJh_ This playlist works on...

Free to enter at: Enter the Rocket Mortgage Super Bowl Squares sweepstakes. They’re giving away $50,000 every score change, plus two grand prizes of $500,000. Enter for free today. #RocketMortgageSquares It is Super Bowl week in America, which means that people are playing the popular Super Bowl Squares gambling game. But this year, Rocket Mortgage is offering a different version of the game. Instead of paying out at the end of each quarter, they are paying out after each score, including before and after the extra points. Does that change the math? You bet it does.

Your VLOOKUP isn't working or the Sync Slicers isn't working. You look at the data and it *looks* the same, but it is not really the same. This video shows how to use MID and CODE to find out why the cells are not really the same.

Check out Rob Collie's Raw Data podcast: Raw Data Podcast - P3 Today, I ran across an unanswered question in a Math board. No one really needs to know this answer. It is a high school math teacher trying to trick people into doing algebra. ALGEBRA? We don't need algebra when we have Excel and Goal Seek.

The URL in the video is Microsoft Forms Today, a problem from Laura who is trying to audit an ACH file. She needs to break the column into 205 individual columns. When you use Excel Text to Columns, it would be incredibly tedious to click 204 times in step 2 of the Text to Columns Wizard. Today, from the Ignite 2019 Show Floor, a surprisingly easy way to solve this using Power Query's Split Column Repeatedly.

Excel has supported the List option in Data Validation for a decade. But let's face it: it is not easy to select from the list. You can't start typing and have the list shorten to just the matches, also known as Look Ahead. Today, a cool trick from Bob Umlas and his friend Alfred. By creating a few hundred range names, you can call up the list quickly. Type the first few letters of the name and you will jump to the names that match those letters. Thanks to Create Names from Selection, this is actually easy to set up.

A simple improvement to Excel appeared in November 2020: You can now unhide multiple worksheets at once. This feature is rolling out to Office 365 subscribers.

It is like the Christmas where you got almost every thing you asked for. The Excel team has given us almost everything I asked for with the new data types. You can now create your own data types in Excel, without help from the I.T. department. I've been out for two months, and while I was away from the computer, I read a book about narrative storytelling in radio. This is a longer video, with a lost of "this happened, then this happened, then this happened". I am not sure this will become the new normal. But I hope you can put up with it for today. Table of Contents (0:00) Welcome & history of Data Types (1:09) What would you like them to add? (1:48) Exchange rates done in March 2019 (2:16) Wolfram Alpha data types raised the bar (2:41)...

Exploring the Microsoft/NASA Day of Data Dataset from Day of Data Today (November 1, 2020) marks 20 continuous years of having a human on the International Space Station (ISS). For today's video, I explore the NASA data set to see: (a) Has there really been someone on the ISS every day? (b) What is the most people aboard the ISS? (c) What is the fewest number of people aboard? (d) What is the most common crew size? Along the way, you will see some Power Query, Date.AddDays, the FILTER function, and more.