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.
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”
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”
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”
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”
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”
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”
Here is link: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/ or Amazon: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ref=sr_1_1
Mike “excelisfun” Girvin’s 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel.
Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.
Remember:
Microsoft and Lotus though that 1900 was a leap year and so they added 2/29/1900 as a date in Excel. But if you import your dates into Excel or the reverse, all dates work.
Here is link: https://www.mrexcel.com/products/the-transformative-magic-of-power-query-m-code-in-excel-and-power-bi/ or Amazon: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832/ref=sr_1_1
Mike “excelisfun” Girvin’s 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel.
Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.
Download Excel File: https://excelisfun.net/files/EMT1863.xlsx
Learn how to use the amazing GROUPBY and PIVOTBY functions to create a sales report with categories to summaries by half year increments.
Topics:
1. (00:00) Introduction
2. (00:02) Viewer Suggestion
3. (00:18) IF Function to create ½ data attributes for the table of data.
4. (00:43) GROUPBY Function
5. (01:47) Conditional Formatting for Report
6. (02:22) GO TO Trick to find cells in worksheet that contain Conditional Formatting
7. (02:48) Mixed Cell References and Conditional Formatting for Total Row
8. (04:26) PIVOTBY Function
9. (05:04) Add New Data and Watch Formulas Update!!!
10. (05:37) Summary
11. (05:50) Closing, Video Links
#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics Continue reading “GROUPBY & PIVOTBY Functions to Create a 1/2 Year Summary Report! Excel Magic Trick 1863”
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 Continue reading “Copilot In OneDrive Versus Copilot In Excel for Excel Workbooks – Episode 2655”
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. Continue reading “Excel Why Are SEC Edgar Numbers Showing as Text in Excel? – Episode 2654”