MrExcel Excel Videos

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.

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.