MrExcel Excel Videos

Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Excel - Unlock the Secrets of Excel's New Compatibility Version! - Episode 2663
Microsoft Excel Tutorial: Unlock the Secrets of Excel's New Compatibility Version! Are you tired of mismatched results when sharing Excel files between coworkers using different versions? Microsoft has finally addressed this issue. Today we dive into the game-changing **Function Compatibility Version**. This feature offers a solution to inconsistencies caused by updates to five key functions: **LEN, MID, SEARCH, FIND, and REPLACE**. While the updates might seem minor, the implications are massive, especially for teams juggling old and new versions of Excel. Learn how the new **Compatibility Version** setting makes it easier to manage version disparities. Whether you're stuck on Excel 2016 or using the latest features in Excel 365...
Excel Assign Thanksgiving Dinner Sides Using Excel - Episode 2662
Microsoft Excel Tutorial: Randomly Assign Sides for Thanksgiving Dinner In today’s tutorial, we’re tackling a fun holiday challenge: assigning dinner sides for Thanksgiving using Excel! Whether you’re hosting a big feast or coordinating a potluck, Excel makes it easy to assign dishes randomly and fairly. In this video, I’ll walk you through the process step by step, using Excel’s powerful SORTBY and RANDARRAY functions. Have you ever used a spreadsheet to manage your holiday meals? Let me know in the comments! My friend Katie from my morning workout group inspired this video—she needed a way to assign sides for her large Thanksgiving dinner. Together, we built a system in Excel to ensure everyone gets a dish to bring. You’ll...
Excel Which Products Contain Both Of These Items - Episode 2661
Microsoft Excel Tutorial: Which Products Contain Both Of These Items? Today, an odd data problem. I have a solution, but I suspect there are much easier ways to do this. I have a list of songs in workouts from Supernatural VR. Over 500 workouts are Quick Hits with just two songs. Each Quick Hits workout should be a subset of a longer workout. Given the two lists, how can you use Excel to find the parent workout? My solution involves an XLOOKUP with a concatenated key and a concatenated lookup vector. This gives me a list of the Workout IDs that contain song 1 and the Workout ID's that contain song 2. Given these two list of workout IDs, how can you find which workout ID is in common between the two cells? I was surprised to find...
Excel Easy Fake Data From Python In Excel - Episode 2660
Microsoft Excel Tutorial: Excel Fake Data From Python In Excel Creating fake data with Python in Excel has never been easier! In this video, I walk you through generating random data directly in Excel using Python’s powerful capabilities. We start from a completely blank workbook, search for Python, and dive into some exciting new options like the QR code generator and random data generator. This process is amazing for anyone who needs quick, randomized data sets without leaving Excel. Just a few clicks, and you can have it all right at your fingertips! We'll start by setting up Python to generate a sample data set, including names, cities, countries, addresses, or whatever fields you need. I demonstrate how you can adjust the data...
Excel Draw Perfect Shapes With Draw And Hold Gesture - Episode 2659
Microsoft Excel Tutorial: Draw Perfect Shapes With Draw And Hold Gesture In this video, I'm diving into a new feature in Microsoft Excel: the Draw and Hold Gesture! If you've ever wanted to create shapes in Excel without struggling with awkward mouse drawing, this update is for you. While the feature has been available in OneNote for a while, it’s finally made its way to Excel and PowerPoint—at least for those on the Insider’s channel. I’ll walk you through how to activate this new tool and show you what it can do! First, if you don’t see the Draw tab in your ribbon, I’ll show you how to get it. It's just a quick right-click and then a trip to the “Customize Ribbon” menu. Once activated, you’ll have access to a variety of freeform...
Excel Which Invoices Add Up To This Check Amount - 2658
Microsoft Excel Tutorial: Which Invoices Add Up To This Check Amount - Faster method using Python in Excel. To download the workbook from today: Excel Which Invoices Add Up To This Check Amount - 2658 Sample Files - MrExcel Publishing Today, I'm excited to share a powerful solution to a problem I used to call the "knapsack problem" in accounts receivable. We often face scenarios where customers send a payment without specifying which invoices are covered—leaving us to solve the puzzle! In this video, I'll show you how to identify which invoices match a specific payment amount using Python in Excel, without the need for a Copilot subscription. 🚀 This challenge involves finding a combination of invoices that add up to the exact payment...
Excel - Create an NBA Shot Chart Using Python & Copilot | LeBron James - 16 Playoffs - Episode 2657
Microsoft Excel Tutorial: Create an NBA Shot Chart Using Python & Copilot | LeBron James - 16 Playoffs In this video, I’m excited to show you a demo I saw from Microsoft that's seriously cool! We’re diving into how to use the new Python integration with Excel Copilot to create an NBA basketball shot chart. With data sensors installed in every NBA arena since 2013, we now have detailed info on every shot, including the exact X and Y coordinates and whether the shot was made or missed. This data opens up a whole new world of possibilities for sports analytics in Excel. For this example, I’ve extracted LeBron James' shot data from the 2016 playoffs with the Cleveland Cavaliers – the Cavs' only championship season during my lifetime! With...
Excel Word Cloud Using Copilot And Python In Excel - Episode 2656
Microsoft Excel Tutorial: Word Cloud Using Copilot And Python In Excel - Episode 2656 Creating a word cloud in Microsoft Excel has never been easier! In this video, I walk you through how to generate a word cloud using the new Copilot - Advanced Analysis feature. With just a few clicks, I transformed 3000 rows of data from the Title column into a visually stunning word cloud. The best part? Excel automatically excludes common stop words like "The," "A," and "of" so you can focus on the key terms. I was amazed at how Excel leverages Python to make this happen behind the scenes. Even though I received a warning about exceeding my Python usage limit, the process continued smoothly, and Excel generated the Python code for me. It even gave...
Copilot In OneDrive Versus Copilot In Excel for Excel Workbooks - Episode 2655
Microsoft Excel Tutorial: Copilot In OneDrive Versus Copilot In Excel for Excel Workbooks In today’s video, we’re diving into Copilot in OneDrive and how it handles analyzing an Excel workbook. But first, let’s settle a little controversy that popped up about my “Spreadsheets are my Jam” coffee mugs. Take my survey to let me know if you carry your coffee mug in your dominant hand or not. Now, let’s get back to Excel. Remember that awesome trick from Dr. Nitin, where he used Copilot in Word to analyze financial statements? Well, I decided to throw a regular Excel file at Copilot in OneDrive to see how it performs. Spoiler alert: it didn’t do much math. It mostly reworded the data into sentences without doing many calculations. Out...

Forum statistics

Threads
1,226,269
Messages
6,189,953
Members
453,584
Latest member
daihoctuxaeptit

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