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!!!
Month: October 2024
Amazing XLOOKUP Formula with Lookup Value From Within Description: Excel Magic Trick 1860
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
UNIQUE-SORT, not SORT-UNIQUE: Killer Array Formula Trick That Everyone Should Know. EMT 1861
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
Discover Adam and Patrick’s Epic 2024 Adventure
July is here and conferences are coming for the 2nd half of 2024. Learn where you’ll find Adam and Patrick and how you can register. We hope to see you there!
SQL Saturday Baton Rouge 2024 – July 27th
https://sqlsaturday.com/2024-07-27-sqlsaturday1076/
Data Saturday Dallas – September 7th
https://datasaturdays.com/Event/20240907-datasaturday0056
Power Platform Conference – Las Vegas, NV – September 18-20th
https://powerplatformconf.com/
European Microsoft Fabric Community Conference – Stockholm, Sweden – Sept 24-27th
https://aka.ms/fabcon-europe
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “Discover Adam and Patrick’s Epic 2024 Adventure”
REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 13, 2024)
Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout
📢 Become a member: https://guyinacu.be/membership
*******************
Want Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 13, 2024)”
Multiple DAX Measure updates in DAX Query View? Yes, Please!
We got some new updates for the DAX Query view in Power BI Desktop that take it to a whole other level! Patrick shows you how you can start using it with models in the service and more!
Power BI July 2024 Feature Summary
https://powerbi.microsoft.com/en-us/blog/power-bi-july-2024-feature-summary/#post-27650-_Toc1615654178
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #DAX #GuyInACube
Overwhelmed with all the Microsoft Fabric Updates???
There are a lot of updates coming with Microsoft Fabric just like there was with Power BI. It can be overwhelming and hard to keep up. Adam gives some thoughts and lets you know it’s ok!
Managers, What Are You Doing About Change Exhaustion?
https://hbr.org/2022/05/managers-what-are-you-doing-about-change-exhaustion
Navigating Change Fatigue: Strategies For Resilience https://www.forbes.com/sites/johnkotter/2023/09/18/navigating-change-fatigue-strategies-for-resilience/
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: https://guyinacu.be/courses
*******************
LET’S CONNECT!
*******************
— http://twitter.com/guyinacube
— <a Continue reading “Overwhelmed with all the Microsoft Fabric Updates???”
REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 20, 2024)
Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout
📢 Become a member: https://guyinacu.be/membership
*******************
Want Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (July 20, 2024)”
Learn Power Query M Code From Mike Girvin New Book
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”
Microsoft Excel Where Did They Move 3D Map Feature – 2646
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/
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: 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”
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”