MrExcel Excel Videos

Nas T has to convert sport names to a 4-letter abbreviation. If the sport name has one word, then use the left four characters. But, if the sport name has two words, use the left 3 letters from the first word followed by the first letter from the second word. AND... Nas says we have to use the IF formula. My solution includes some LEFT, MID, IFERROR, FIND functions. Also in this episode: Flash Fill.

Microsoft Excel Tutorial: ExcelHash participants discuss lessons learned and memorable moments. #ExcelHash #Excel #microsoftexcel Buy Bill Jelen's latest Excel book: MrExcel 2022 Boosting Excel You can help my channel by clicking Like or commenting below: Why clicking Like on a YouTube video helps my channel #excel #microsoft #exceltutorial #exceltips #microsoftexcel #exceltricks

Microsoft Excel Tutorial: Amazing way to rearrange the columns or rows in an Excel pivot table. In this episode of the MrExcel Podcast, the host discusses rearranging a pivot table. He mentions playing the Rocket Mortgage Super Bowl Squares and shares the numbers that were chosen. He explains how he chose his square randomly and discusses his wife's square as well. The host then demonstrates how to rearrange the numbers in a pivot table by typing them in the desired order. He also mentions that he fixed the data in the table to have AFC and NFC in the correct order. The host concludes by inviting viewers to share their favorite square in the comments and offering a free copy of his new book to anyone whose number comes up in the game...

You have a list in Excel. You want to know how many times each entry appears in the list. This week, Bill and Mike show a solution using a pivot table or Advanced Filter with COUNTIF.

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.