MrExcel Excel Videos

Microsoft Excel Tutorial: Learning the Building Blocks for RegEx in Excel Learn the basic building blocks of RegEx in Excel. To download the RegEx Cheat Sheet and workbook from today: Excel - RegEx Building Blocks - 2643 Sample Files - MrExcel Publishing Welcome back to MrExcel's YouTube channel! In this video, we'll dive into the building blocks for mastering Regular Expressions (RegEx) and their integration in Excel. If you find this video helpful, don’t forget to click the Like button below – it helps us reach more viewers. We've got over 2,500 videos on various Excel topics, so there's plenty to explore! Our focus today is on RegEx, specifically the new functions in Excel: RegExTest, RegExExtract, and RegExReplace. I’ll break...

Microsoft Excel Tutorial: Excel Adds RegEx Support for Pattern Matching in Excel. 🎥 Unlocking the Power of RegEx in Excel: New Features Explained! 📊 Hey Excel enthusiasts! 🌟 In today's video, we're diving into an exciting new feature: RegEx support in Excel for pattern matching. If you enjoy exploring new Excel functionalities, this is a must-watch! Don't forget to Like this video to help it reach more people. 👍 🔥 What's New? 🔥 Excel has introduced three powerful RegEx functions: RegExTest, RegExReplace, and RegExExtract. These functions are set to revolutionize how we handle data patterns. Plus, there are updates to XLOOKUP and XMATCH functions that now include RegEx capabilities! Let's explore how these tools can make your data...

Microsoft Excel Tutorial: Three ways to delete hundreds of tiny blank columns in Excel. Welcome back to another MrExcel tutorial! In this video, we tackle a common Excel dilemma: deleting 365 blank columns swiftly. Hailing from Green Bay, Wisconsin, our viewer shared their data download challenge, and we're here to provide not one, not two, but three lightning-fast solutions. First up is the Ctrl+Y or F4 trick, a nifty shortcut that repeats the last command. Watch as we demonstrate how to breeze through column deletion with just a few keystrokes, saving you valuable time. Next, we delve into the power of Excel's Go To Special feature. Learn how to select all blank cells in a flash, followed by a quick deletion process. Despite a...

Google docs still does not render all Excel files correctly. If you have particular formatting, there is a chance that your gmail recipients will simply preview the file in gmail, which renders using Google Docs, which means they won't see the right version of the spreadsheet. In today's episode, I show you how to force gmail to open the attachment in the real Excel.

Microsoft Excel Tutorial: Excel Keeps Inserting Old Formula - How to Fix It! Every time that Tori adds a new row to her Excel table, four columns auto-fill formulas from years ago. Oh my gosh. Ever had a crazy frustrating problem with Excel? In this video, we tackle Tori's Excel nightmare head-on. Tori's adding new rows to her table, only to find four columns haunted by formulas from three years ago! What gives? Hey there! If you're facing Excel woes like Tori, hit that Like button below to help more folks find this solution-packed video – thanks for the support! Picture this: Tori's table looks fine until she adds a new row – then, bam! Ancient formulas appear like unwelcome ghosts. What's the deal? I was stumped, but thanks to...

Microsoft Excel Tutorial: Create an Excel Pivot Table to Identify Which Customers Are Paying Less than Average for a Product. To download the workbook from today: Excel Customers Paying Less Than Average - Episode 2639 Sample Files - MrExcel Publishing Hey Excel enthusiasts! 👋 In this MrExcel netcast, we tackle a fascinating question from Glenn, who joined our recent Nashville IMA webinar. Ever wondered which customers are paying less than the average? 🧐 We've got you covered! 🔍 Using a special pivot table based on the Data Model, we delve into the powerful DAX function CALCULATE. Follow along as we transform our data into a table named "Sales" and explore 12,000 rows of last year's data with 20 customers and two products. 💡 Learn...

Microsoft Excel Tutorial: Microsoft improves the Show Details feature in a pivot table and adds new entry points. To download the workbook from today: Excel Show Details In Excel Pivot Table - Episode 2638 Sample Files - MrExcel Publishing Unlock New Insights with Excel Pivot Tables! 🚀 In this tutorial, we dive into the latest updates from the Excel team. Discover the new Show Details feature, making data analysis smoother than ever! 📊💡 🔍 Show Details Icon: Spot the new icon on the Pivot Table Analyze tab - it's a game-changer! Similar to the classic double-click, it opens a new sheet to the left with detailed information. Now, with a handy title indicating the source, making your analysis more straightforward. 🏆 🔄 Multiple Entry...

Microsoft Excel Tutorial: Preview of AI Copilot for Excel. Welcome to episode 2636 of Mr. Excel's netcast! In this video, we will be taking a first look at Copilot AI for Excel, a new feature from Microsoft that has been generating a lot of buzz. I was lucky enough to get a sneak peek at this feature, even though it was initially only available for enterprises with over 100 customers. But now, I have access to it and I'm excited to share it with you. In this video, we will be exploring the Copilot feature and its capabilities. We will be working in Excel online, as it is currently easier to use for this feature. The data we will be using needs to be in a table for Copilot to work. Once we have the data in a table, we can access the...

There was a scary post online today... the Excel Status Bar sum was WRONG! But it is not wrong... it is a great trick that will win you bar bets from your Excel guru friends! The Status Bar sum is CORRECT when you select from bottom to top! But it is INCORRECT when you select from top to bottom! Down in the YouTube comments, tell me how I managed to do this. It required no VBA. You can easily do it yourself and freak out your Excel guru friends! Don't feel bad... when I first saw it, I could not figure it out either. This relies on one of those odd facts about Excel.