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/
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 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”
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”
There are so many new and more productive ways you can use Power BI now by augmenting all your work with AI. Listen in for many insights into how to develop quality Power BI reports from 2024 onwards. HINT – using AI to help at all steps boosts your productivity an incredible amount. Embrace it!
In this video we go through how amazing AI voices are becoming. They can already walk you through in a very customized way how to learn about new skills in the data and programming space. You can acquire advanced new skills much faster than you ever thought possible if you embrace this new way of learning.
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.
Form to fill out: https://lnkd.in/eT4jM3Bd
Celia’s MVP story: https://www.linkedin.com/feed/update/urn:li:activity:7220049752489431040/
Celia’s YouTube Channel: https://www.youtube.com/c/CeliaAlvesSolveExcel
Here is a poem about excelisfun and the revoked MVP by Hiran de Silva.
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
Need to do a bulk change of something in your Power BI report? The new Power BI report format enables some slick automations. Patrick uses Sempy to get this done!
What is semantic link?
https://learn.microsoft.com/fabric/data-science/semantic-link-overview
Items – Get Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/get-item-definition?tabs=HTTP
Items – Update Item Definition
https://learn.microsoft.com/rest/api/fabric/core/items/update-item-definition?tabs=HTTP
📢 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
— rel=”nofollow”>http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #report #GuyInACube
Ready to take the Power BI card visual to the next level? Adam tinkers to get it to look just right. It’s a lot of customization but the outcome is way better than the starting point.
Create a (new) card visualization in Power BI Desktop (preview)
https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-new-card?tabs=On-the-ribbon
📢 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
— <a Continue reading “Happy little accidents with the Power BI Card Visual”