MrExcel Excel Videos

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.

Microsoft Excel Tutorial: Embed any Excel Logic in a Web App Using Sheetcast.com. Try this web app now to search my videos: MrExcel's Video Search Welcome to episode 2635 of the MrExcel podcast! It's been 25 years since I started sharing my Excel tips and tricks with all of you, and I couldn't be more grateful for your support. Today, I have something truly amazing to show you - how to publish any Excel logic as a web app using Sheetcast while protecting your intellectual property. Plus, I'll also be sharing how you can search through 25 years of MrExcel content using just 18 Excel functions. Let's dive in! Have you ever wondered how to create a web app from your Excel workbook without giving away your intellectual property? Well, I...

Microsoft Excel Tutorial: Quickly download YouTube Thumbnails into Excel. TubeBuddy Link: Pricing Formula for Edit Hyperlink: =HYPERLINK("YouTube"&B2&"/edit","Edit") Formula to Wrap Thumbnails into 9 columns: =WRAPROWS(FILTER(F2:F2417,G2:G2417=1),9) Welcome to episode 2634 of MrExcel's Net Cast! In this video, we will be exploring two new Excel functions that will help us quickly review over 2400 YouTube thumbnails. As we approach the 25th anniversary of MrExcel, I am grateful for the opportunity to connect with friends and followers from around the world through 67 books, thousands of articles, over 5 million posts on our message board, and 2400 videos on YouTube. If you enjoy this video, please click the like button below to help...

Microsoft Excel Tutorial: Three New Functions Debut in Excel: GROUPBY, PIVOTBY, and PERCENTOF. To download the workbook from today: Excel - First Look GroupBy PivotBy PercentOf Functions - Episode 2633 Sample Files - MrExcel Publishing Read the Microsoft Announcement: New aggregation functions: GROUPBY and PIVOTBY Welcome to episode 2633 of MrExcel's netcast, where we explore the latest and greatest features of Microsoft Excel. In this episode, we will take a first look at three new functions: GROUPBY, PIVOTBY, and PERCENT OF. These functions are incredibly simple to use, yet offer deep options for data analysis. So let's dive in and see what they can do! First up, we have GROUPBY. This function allows us to group data by categories...

Microsoft Excel Tutorial: A new Check Performance Feature debuts in Excel to clean excess cell formatting that can cause large file sizes. Welcome to episode 2632 of MrExcel's Net Cast! In this video, we'll be discussing a new feature in the Windows version of Excel that has been available in Excel online for some time now. It's called Check Performance and it can help you clean up unwanted cell formats and reduce file sizes. This feature can be found on the Review tab and is definitely worth checking out for any workbook that you've been using for years. Now, before you go ahead and click "optimize all", it's important to take a look at what Check Performance has found. It looks for excess formatting, unused cell styles, and unneeded...