Category: Excel

UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1861.xlsx
Download Timing Test file: https://excelisfun.net/files/EMT1861TestResults.xlsx
When extracting a sorted unique list with a formula, it is more efficient to use UNIQUE-SORT, rather than SORT-UNIQUE.
Topics:
1. (00:00) Introduction
2. SORT-UNIQUE combination tends to calculate slowly.
3. UNIQUE-SORT tends to calculate quickly.
4. () Summary
5. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #sort #unique #arrayformulas #excelarrys #dynamicspilled arrays

Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1860.xlsx
Learn how to extract a lookup value from a description and use it to lookup a value without getting an error.
Topics:
1. (00:00) Introduction
2. () Use lookup value from description to lookup a value. MID function and XLOOKUP with Plus Zero.
3. () Summary
4. (02:32) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #xlookup #exceltips

Microsoft Revokes excelisfun MVP Status!

Posted on by Annie D

Today, July 10, 2024, I got a letter from Microsoft that says I am no longer an Excel MVP. I posted about the same number of videos, files and free classes as the year before. I just passed 1,00,000 subscribers. I give everything away for free. But Microsoft says: NO MVP for excelisfun. So be it. I will keep making Excel and Power BI videos because it is fun!!!

Excel Adds Support For RegEx In XLOOKUP And XMATCH – Episode 2647

Posted on by Annie D

Microsoft Excel Tutorial: Using a RegEx match in Excel XLOOKUP
To download the workbook from today: https://www.mrexcel.com/youtube/NZybVpM_dI4/

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 Continue reading “Excel Adds Support For RegEx In XLOOKUP And XMATCH – Episode 2647” →

Microsoft Excel Where Did They Move 3D Map Feature – 2646

Posted on by Annie D

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: https://www.mrexcel.com/products/latest/

Learn Power Query M Code From Mike Girvin New Book

Posted on by Annie D

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 Continue reading “Learn Power Query M Code From Mike Girvin New Book” →

Excel Which Invoices Add Up To This Check Amount – 2658

Posted on by Annie D

Microsoft Excel Tutorial: Which Invoices Add Up To This Check Amount – Faster method using Python in Excel.

To download the workbook from today: https://www.mrexcel.com/youtube/6IohCo5KP9Q/

Today, I’m excited to share a powerful solution to a problem I used to call the “knapsack problem” in accounts receivable. We often face scenarios where customers send a payment without specifying which invoices are covered—leaving us to solve the puzzle! In this video, I’ll show you how to identify which invoices match a specific payment amount using Python in Excel, without the need for a Copilot subscription. 🚀

This challenge involves finding a combination Continue reading “Excel Which Invoices Add Up To This Check Amount – 2658” →

Excel Copilot First Look August 2024 – Episode 2648

Posted on by Annie D

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 Continue reading “Excel Copilot First Look August 2024 – Episode 2648” →

1/2 Year Summary Report in a PivotTable? Cool Formula to Help PivotTable! Excel Magic Trick 1862

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1862.xlsx
Learn how to add a formula helper column to the data set to group the dates by half year increments in a PivotTable.
Topics:
1. (00:00) Introduction
2. () Viewer Question
3. () Helper Column Formula
4. () PivotTable
5. () Summary
6. () Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #pivottable #grouping #groupby #formulas #functions