Author: Annie D

Excel Pivot Table Number Format Copied From Source Data Episode 2674

Posted on by Annie D

🚀 *Unbelievable Excel Update!* 🚀

Pivot Table numeric formatting is now automatically coming from the grid! 🎉 Microsoft didn’t announce this (that I’ve seen), but it just *worked* this morning. No more manually formatting numbers in your Pivot Tables—Excel is pulling it straight from the source data.

✅ Thousands separator? ✔️
✅ Currency symbols? ✔️
✅ No extra steps? ✔️

Watch as I demo this game-changing update with a quick dataset. This small but mighty improvement is a *huge* win for efficiency!

💡 Have you seen this in your version of Excel yet? Let Continue reading “Excel Pivot Table Number Format Copied From Source Data Episode 2674” →

How to Build Valuable Web Apps in Less Than a Day

Posted on by Annie D

***** Video Details *****
The rapid evolution of AI-driven app development is unlocking unprecedented opportunities for business and innovation. In this discussion, Sam introduces LearnFlow, a prototype application built in just a few hours using Lovable.dev—without writing any code. The app automates the creation of structured learning materials by integrating AI models via API calls, demonstrating the efficiency and scalability of no-code development. The conversation also explores how AI-powered tools like Windsurf and Cursor allow developers to iterate and enhance applications rapidly. The potential for integrating audio AI, automation, and multimodal AI models suggests a new frontier in software creation where Continue reading “How to Build Valuable Web Apps in Less Than a Day” →

Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68

Posted on by Annie D

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

The AI Revolution: How Automation, APIs, & No-Code Tools Are Changing Everything with Brian Julius

Posted on by Annie D

***** 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” →

PIVOTBY & LAMBDA Functions to Covert Bad Data Into Proper Table, When There Are Duplicates. EMT 1877

Posted on by Annie D

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

Unbelievable PIVOTBY & SINGLE Functions to Covert Bad Data Into Proper Table. Excel Magic Trick 1876

Posted on by Annie D

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)

Posted on by Annie D

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)” →

No VBA Needed : ) Simple Power Query Table.Pivot Function Makes it Simple! Excel Magic Trick 1875

Posted on by Annie D

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” →

Unleash Data Governance with Microsoft Purview & Microsoft Fabric

Posted on by Annie D

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” →

FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874

Posted on by Annie D

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

What about relationships with Multiple facts in Power BI?

Posted on by Annie D

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?” →

LET Function to Define LAMBDA as f, then Perform Column Iteration With Vertical Spill. #Short 67

Posted on by Annie D

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” →