MrExcel Excel Videos

Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Excel Pivot Table Mastery: Rearrange Columns Like a Pro - Super Bowl Squares - Episode 2387
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...
Bakersfield to Stockton via Excel Hash - 2386
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...
Super Bowl Squares Percentages with Rocket Mortgage Change - 2385
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.
Goal Seek Replaces Algebra - 2283
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.
Surprisingly Easy Split ACH File Into 205 Columns - 2294
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.
Look Ahead Selecting Names From List in Excel - 2380
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.

Forum statistics

Threads
1,226,730
Messages
6,192,705
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top