Excel Which Invoices Add Up To This Check Amount – 2658

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

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

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

Introduction to the excelisfun Channel at YouTube: Free Videos, Files and Full Free Courses!!

Home page with free videos, files and full free courses: https://www.youtube.com/@excelisfun
This is an introduction to the excelisfun channel at YouTube, where the videos, practice files and full courses are all free! Mike Girvin created this channel back in 2008 and have posted over 3,700 videos, over 10,000 practice files and over 100 playlists and classes to learn from.

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 Continue reading “Mind-Blowing! Using Copilot Outside of Excel to Analyze Financial Statements! Episode 2652”

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 Continue reading “Excel Copilot With Excel With Python – First Look – Episode 2653”

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 Continue reading “Excel New Range Reference For Dynamic Sized Ranges – Episode 2651”

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 Continue reading “Excel Extract Everything After First Digit – Episode 2650”

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 Continue reading “Copilot Never Watch An Entire YouTube Video Again! Episode 2649”

Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865

Download Excel File: https://excelisfun.net/files/EMT1865.xlsx
Learn how to perform approximate match lookup in Power Query M Code by creating custom functions. The first function we build in a Custom Column using the Table.SelectRows function and the let expression. The second we build as a reusable function in the Advanced Editor using the Table.SelectRows function. The third we build as a reusable function in the Advanced Editor using the List.Accumulate function.

M Code book from excelisfun at Mr Excel Site: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/

M Code book from excelisfun at Amazon: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ref=sr_1_1

The M Code book is Mike “excelisfun” Girvin’s Continue reading “Approximate Match Lookup in Power Query: 2 Amazing Functions! Power BI or Excel. EMT 1865”