MrExcel Excel Videos

Microsoft Excel Tutorial: Word Cloud Using Copilot And Python In Excel - Episode 2656 Creating a word cloud in Microsoft Excel has never been easier! In this video, I walk you through how to generate a word cloud using the new Copilot - Advanced Analysis feature. With just a few clicks, I transformed 3000 rows of data from the Title column into a visually stunning word cloud. The best part? Excel automatically excludes common stop words like "The," "A," and "of" so you can focus on the key terms. I was amazed at how Excel leverages Python to make this happen behind the scenes. Even though I received a warning about exceeding my Python usage limit, the process continued smoothly, and Excel generated the Python code for me. It even gave...

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