We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.
The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ...
Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.
Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.
Download Excel File: https://excelisfun.net/files/ExcelShort68.xlsx
Learn how to randomize numbers with a normal distribution using NORM.INV function or use the RANDBETWEEN or RANDARRAY functions to randomize numbers across a uniform distribution.
#excel #excelfunctions #microsoft #excelisfun #data #randomize
***** Video Details *****
This conversation explores the transformative power of AI-driven tools in development, data analytics, and automation, highlighting how new technologies are reshaping workflows and unlocking new opportunities. Sam and Brian discuss the rise of API-driven models, which are making analytics and software development more accessible than ever, allowing users to build applications, automate processes, and analyze data—all with natural language inputs. They challenge the fear-driven narrative that AI will replace jobs, instead arguing that AI is democratizing technology, making software development faster, easier, and more cost-effective while also creating more opportunities in tech, automation, and entrepreneurship.
***** Related Links Continue reading “The AI Revolution: How Automation, APIs, & No-Code Tools Are Changing Everything with Brian Julius”
Download Excel File: https://excelisfun.net/files/EMT1877.xlsx
Learn how to convert to bad data table with records of data in columns to a proper table structure with records in rows using the PIVOTBY & LAMBDA Functions. This solution deals with duplicate values.
This trick comes from ExcelLambda at YOUTUBE.
Topics:
1. (00:00) Introduction.
2. (00:24) PIVOTBY & LAMBDA Functions Solution. See COUNTA and IF Functions and the @ implicit intersection operator.
3. (01:55) Summary
4. (02:04) Closing
#excel #microsoft #excelisfun #excelcourse #groupby #pivotby #excel365 #arrayformulas #datamodeling #data #dataanalytics #datascience #dataanalysis #etl #etltools #cleandata #transformdata #lambda
Download Excel File: https://excelisfun.net/files/EMT1876.xlsx
Learn how to convert to bad data table with records of data in columns to a proper table structure with records in rows using the PIVOTBY & SINGLE Functions. This trick comes from viktorasgolubevas at YOUTUBE.
Topics:
1. (00:00) Introduction.
2. (00:25) PIVOTBY & SINGLE Functions Solution.
3. (01:48) Summary
4. (02:23) Closing
#excel #microsoft #excelisfun #excelcourse
#groupby #pivotby #single #singlemom #singlelife #excel365 #arrayformulas #datamodeling #data #dataanalytics #datascience #dataanalysis #etl #etltools #cleandata #transformdata
Microsoft Power BI / Fabric Q&A – LIVE (March 8, 2025) (Member Chat 2nd Half)Join us live as we answer your questions about Power BI & Microsoft Fabric! 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 “ Microsoft Power BI / Fabric Q&A – LIVE (March 8, 2025) (Member Chat 2nd Half)”
Link to Amazon M Book: https://www.amazon.com/Transformative-Magic-Power-Query-Excel/dp/1615470832 (Please write a review too)
Download Excel File: https://excelisfun.net/files/EMT1875.xlsx
Learn how to convert to bad data table with records of data in columns to a proper table structure with records in rows using the Pivot Column Power Query Feature. Lean about efficient M Code (functional language behind Power Query) also!
Learn about the difference between the Table.Pivot function and the Table.UnPivot function.
Topics:
1. (00:00) Introduction.
2. (00:26) Compare to what we did in Excel Short Trick 61
3. (01:20) Difference between Power Query Pivot Column feature & Unpivot Column feature: STAR!!!!
4. (01:47) Pivot Continue reading “No VBA Needed : ) Simple Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875”
Discover how Microsoft Purview and Microsoft Fabric work together to strengthen data governance, streamline cataloging, and enhance analytics. Marthe gives a look at some ways that Purview can help in your Microsoft Fabric and Power BI journey.
Purview overview
https://learn.microsoft.com/purview/purview
Learn about Microsoft Purview Unified Catalog
https://learn.microsoft.com/purview/unified-catalog
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
— Continue reading “Unleash Data Governance with Microsoft Purview & Microsoft Fabric”
Download Excel File: https://excelisfun.net/files/EMT1874.xlsx
Learn how to do a complicated reverse lookup with a simple formula using the XLOOKUP and FILTER functions.
Topics:
1. (00:00) Introduction.
2. () Formula for reverse lookup with a simple solution using the XLOOKUP and FILTER functions
3. (10:31) Summary
4. (11:12) Closing
#excel #microsoft #excelisfun #excelcourse
Now relationships are causing a problem with multiple facts in Power BI! Patrick looks at another way to avoid a circular dependency by way of relationships.
Demo Files:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250305%20-%20Multiple%20Facts%20pt3.zip
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
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com
***Gear***
Check out my Tools page – <a Continue reading “What about relationships with Multiple facts in Power BI?”
Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch11/ExcelShorst64-67.xlsx
Learn how to create a single cell formula with the functions LET and LAMBDA and BYCOL that will iterate columns in an array and spill multiple aggregate results vertically. LET will use the LAMBDA function to define a reusable function, where all you have to do is enter the aggregate function name and below each column the aggregate calculation will appear from a spill.
Thanks to ExcelLambda at YouTube for the Excel formula knowledge in this video : )
#excel #microsoft #excelisfun #excelcourses #excelcourse #excelfunctions #excelformula #excelfunction #365excel #office365 #office365training #exceltips #exceltutorial #exceltraining #exceltricks #excelmaster #excelmagictrick Continue reading “LET Function to Define LAMBDA as f, then Perform Column Iteration With Vertical Spill. #Short 67”
Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch11/ExcelShorst64-67.xlsx
Learn how to create a single cell formula with the functions LET and BYCOL that will iterate columns in an array and spill multiple aggregate results vertically. The LET function defines an array and a function, which allows the array to be altered for calculations such as Geometric Mean. Thanks to ExcelLambda at YouTube for the Excel formula knowledge in this video : )
#excel #microsoft #excelisfun #excelcourses #excelcourse #excelfunctions #excelformula #excelfunction #365excel #office365 #office365training #exceltips #exceltutorial #exceltraining #exceltricks #excelmaster #excelmagictrick #excelmagic #short #excelshort
#bycol #let #letfunction #aggregate #spilling #dynnamicspilledarrayformulas
Microsoft Excel Tutorial: Excel Clean Data with Copilot
Microsoft Excel just introduced the Clean Data feature in Win32, bringing AI-powered data cleaning straight to the desktop! This tool, previously available in Excel Online since October 2024, promises to detect and fix inconsistencies in your dataset—like inconsistent text, formatting issues, and more. But does it really work as expected?
In this episode, I put Clean Data to the test with a variety of messy datasets. It does well in some areas, like recognizing spelling variations and fixing number formats. However, it struggles with company name inconsistencies, date issues, and partial data cleaning—sometimes catching Continue reading “Clean Data with Copilot in Excel – What Works and What Doesn’t? Episode 2673”