MrExcel Excel Videos

Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Excel Why Are SEC Edgar Numbers Showing as Text in Excel? – Episode 2654
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...
Mind-Blowing! Using Copilot Outside of Excel to Analyze Financial Statements! Episode 2652
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...
Excel Copilot With Excel With Python - First Look - Episode  2653
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...
Excel Extract Everything After First Digit - Episode 2650
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...
Excel New Range Reference For Dynamic Sized Ranges - Episode 2651
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...
Copilot Never Watch An Entire YouTube Video Again! Episode 2649
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...
Excel Copilot First Look August 2024 - Episode 2648
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...
Creating Custom KML Regions For Excel 3D Map - 2557
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
Excel Adds Support For RegEx In XLOOKUP And XMATCH - Episode 2647
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...

Forum statistics

Threads
1,226,269
Messages
6,189,953
Members
453,584
Latest member
daihoctuxaeptit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top