MrExcel Excel Videos

Microsoft Excel Tutorial: Excel Introduces TRANSLATE and DETECTLANGUAGE Functions. Unlock the Power of Excel's New Functions: TRANSLATE and DETECTLANGUAGE To download the workbook from today: Excel Introduces TRANSLATE and DETECTLANGUAGE Functions - Episode 2645 Sample Files - MrExcel Publishing Hey Excel enthusiasts! If you found this video helpful, don't forget to click Like down below. It helps more people discover this content. In this video, we're diving into two amazing new Excel functions: TRANSLATE and DETECTLANGUAGE. These functions are game-changers, making it easier than ever to work with different languages in Excel. First up, the TRANSLATE function. This powerful tool allows you to translate any text from one language...

Microsoft Excel Tutorial: Make workbook calculate faster by toggling off the ForceFullCalculation setting. Welcome back to MrExcel! Today, I've got an incredible tip that can make your Excel workbooks run dramatically faster. Have you ever heard of ActiveWorkbook.ForceFullCalculation = False? Probably not, because it's a setting that's rarely documented. But it can make a huge difference in calculation speed, as shown in this example sent by Matt from Chicago, a member of the MrExcel message board. Matt provided us with a file containing 7,000 rows and 27 columns, which is just a fraction of the size of his client's actual files. With numerous complex formulas, including XLOOKUPs and SUMIFS based on the same table, even simple tasks...

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...