MrExcel Excel Videos

Microsoft Excel Tutorial: Excel Copilot With Excel With Python An exciting announcement from Satya Nadella this morning. In today's video, we’re diving into something groundbreaking! It’s September 16th, 2024, and right now, Satya Nadella is still talking at Microsoft’s big event, but the exciting news is already here—Copilot in Excel is now generally available, and even better, Copilot with Excel with Python for Advanced Analysis is in preview! 📊 What's in this Episode? I’ve got 18,000 customer records categorized into four groups—Excel Books, Power BI, Power Query, and VBA—and I’m using Python's K-means clustering to create six clusters, giving me a clearer picture of how to market to these customers. The entire process is happening...

Microsoft Excel Tutorial: Extract Everything After First Digit **How to Extract Everything in a Cell Starting from the First Digit in Excel!** In today's video, we tackle a great question from Alex: *How do we extract everything in a cell starting from the first digit?* Alex has a large dataset, and in one of the columns, he needs to separate "what has to be done" from the address where it needs to be done. The tricky part? There's no consistent delimiter to separate these two pieces of information. Today, I'll show you two different solutions to solve this problem—one for those who have access to the latest Excel features and one for those who don't. To download the workbook from today: Excel Extract Everything After First Digit...

Microsoft Excel Tutorial: Excel New Range Reference For Dynamic Sized Ranges and TRIMRANGE function. In today's video, we're diving into an exciting new feature in the Excel beta that's bound to change the way we work with dynamic ranges. Microsoft has introduced a groundbreaking method for referencing ranges using a simple dot notation, or by leveraging the new TRIMRANGE function. Say goodbye to inefficient full-column references and hello to cleaner, more efficient formulas. Stick around as we explore how these new features can streamline your Excel workflows! First up, let's talk about the TRIMRANGE function. This new function allows you to specify a range and trim out any unwanted empty cells—either at the top, the bottom, or...

With a subscription to Copilot 365 and the Edge browser, you will never have to watch an entire YouTube video again. In this video, I'm showing you an incredible hack using Copilot in Microsoft Edge that will save you from having to watch entire YouTube videos again! Imagine being able to jump straight to the key moments of any video without sitting through the lengthy intros or outros. With Copilot, you can do exactly that—access the essential highlights from any video and skip all the fluff. Here, I'll walk you through how to do it step-by-step with a practical example from one of my own videos. I start by heading over to MRX.CL/GPT, where you'll find the twin box implementation for every YouTube video I've ever recorded. Let’s say...

Microsoft Excel Tutorial: First Look at Copilot in Excel, recorded late August 2024 In today’s video, I dive into my very first experience with the new Copilot feature in Excel on Windows. This is exciting stuff, folks! Imagine Bobby Moynihan’s SNL characters bringing some sass to Excel—because that’s exactly what it felt like working with this tool! 😄 Copilot has some cool new tricks up its sleeve, like no longer needing your data to be in a table format. It can now work with regular ranges, making things so much easier for all of us Excellers. We’re talking about features like Suggest a Formula, Show Data Insights, Add Conditional Formatting, and even answering your complex data questions. But hey, it's not all smooth sailing. I ran...

What if you want to map custom regions in Excel 3D Map? After yesterday's video importing KML files from the Census.Gov site, today, we take a look at creating your own KML file using Google Maps and then exporting it to Excel. In today's example, I create a custom map of 10 neighborhood allotments. Google Maps makes it easy to draw new polygons, name them, and then export the layer to KML. You can then import to Excel for Windows using 3D Maps. Table of Contents (0:00) Create custom shapes for Excel 3D Maps (0:22) Neighborhood Allotments (1:04) Open Google Maps (1:34) Drawing a polygon for one jurisdiction in Google Maps (2:40) Export polygons to KML in Google Maps (3:00) Mapping in Excel with your custom jurisdictions (4:37) Wrap-up

Microsoft Excel Tutorial: Using a RegEx match in Excel XLOOKUP To download the workbook from today: Excel Adds Support For RegEx In XLOOKUP And XMATCH - Episode 2647 Sample Files - MrExcel Publishing Welcome to another exciting update from MrExcel! In today’s video, we’re diving into a major breakthrough: RegEx support in XLOOKUP and XMATCH, which was just rolled out on August 14th, 2024. This new feature has been made available to 50% of insiders and promises to revolutionize how you work with data in Excel. If you enjoy the content, don’t forget to hit that Like button below to help more people discover this video! We’ll start by exploring the new RegEx functionality in XLOOKUP and XMATCH. Imagine you have a dataset involving...

Microsoft Excel Tutorial: Where is the 3D Map feature in Excel? I am a fan of 3D Maps, formerly called Power Map, formerly called GeoFlow. But today, the feature is no longer on the Insert tab. Where did they move it? Go to the Data Tab. Look towards the right to the Data Tools group. In that group, find the Data Model drop-down. Open that drop-down and there you will find 3D Map. Buy Bill Jelen's latest Excel book: MrExcel 2024 Igniting Excel

Every time I use the Power Query interface, I am aware that I am writing code that is probably as inefficient as recorded VBA code. Today, a new book from Mike Girvin will teach you how to write M code in Power Query. This is for Power Query in Excel, Power BI, or Power Automate. The book will be shipping from Amazon on October 1, 2024. However, by the third week in August, I am going to have 200 advance copies. For $29.95, you can buy one of these books with free shipping to the USA. While you wait, you can download the PDF immediately. If you are outside of the USA, you can buy just the PDF today for $14.99. Or, wait until October 1, 2024 when your local Amazon should have the book available. Buy from here: The Transformative...