MrExcel Excel Videos

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

Microsoft Excel Tutorial: Why Are SEC Edgar Numbers Showing as Text in Excel? In this episode of the Learn Excel podcast, MrExcel dives into a common issue when working with numbers copied from the SEC Edgar database. Sometimes, Excel displays these numbers as text, causing frustrating #VALUE! errors during calculations. We'll take a quick break from Copilot and explore why this happens and how to fix it! The problem? Non-breaking spaces (character 160) sneak into your data when copying from sources like SEC Edgar. Even though they look like regular spaces, they can cause Excel to treat numeric data as text. And, unfortunately, Excel's CLEAN function won't remove these sneaky characters. But don’t worry! MrExcel walks through a...

Microsoft Excel Tutorial: Using Copilot Outside of Excel to Analyze Financial Statements! In today's video, we dive into something that completely blew me away – analyzing financial statements using Microsoft Copilot but not in Excel! You won’t believe what Copilot can do with financial data when working outside of Excel, like in OneDrive or Word. We're taking three financial statements (Income Statement, Balance Sheet, and Cash Flow) and letting Copilot generate summaries, calculate financial ratios, and even provide a financial outlook. It's a game changer for anyone working with complex datasets! A shoutout to Dr. Nitin, who first showed me this incredible concept. You have to check out his YouTube channel, @Efficiency365. He’s...

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