Uploaded October 2025 | Updated September 2026, 2 weeks ago
I finally got it working: Uninstalling and Re-installing Excel Labs was the trick. Sometimes you can do this via Excel for Web Addins - Manage but I had no option to REMOVE. So then I had to go to my M365 Admin Portal ➡️ Settings ➡️ Integrated Apps and first remove it there.... THEN i could go to Excel for web ➡️ Addins ➡️Manage and remove it. THEN I could re-install it. THEN it worked 🪄
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
Curious about the new Excel Agent and how it stacks up against ChatGPT for creating dummy data in Excel? In this quick and unfiltered comparison, I test both tools with the same prompt—aiming to generate a movie schedule dataset. The goal? To see which tool delivers cleaner, faster, and more useful results right out of the gate.
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
📗 Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
00:00 Introduction
00:21 Setting up Excel Agent in the browser
00:56 Creating a dummy dataset with Excel Agent
01:28 Running the same prompt in ChatGPT
02:13 Copying and reviewing ChatGPT's output
02:42 Excel Agent delays and real-time issues
03:33 Attempting conditional formatting with Excel Agent
04:20 Final thoughts on reliability and future use
I finally got it working: Uninstalling and Re-installing Excel Labs was the trick. Sometimes you can do this via Excel for Web Addins - Manage but I had no option to REMOVE. So then I had to go to my M365 Admin Portal ➡️ Settings ➡️ Integrated Apps and first remove it there.... THEN i could go to Excel for web ➡️ Addins ➡️Manage and remove it. THEN I could re-install it. THEN it worked 🪄
🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
Curious about the new Excel Agent and how it stacks up against ChatGPT for creating dummy data in Excel? In this quick and unfiltered comparison, I test both tools with the same prompt—aiming to generate a movie schedule dataset. The goal? To see which tool delivers cleaner, faster, and more useful results right out of the gate.
🧑🏻🎓Learning Power BI?
Check out our online course
accessanalytic.thinkific.com
📗 Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/
00:00 Introduction
00:21 Setting up Excel Agent in the browser
00:56 Creating a dummy dataset with Excel Agent
01:28 Running the same prompt in ChatGPT
02:13 Copying and reviewing ChatGPT's output
02:42 Excel Agent delays and real-time issues
03:33 Attempting conditional formatting with Excel Agent
04:20 Final thoughts on reliability and future use




![The Amazing New Slicer and Card visual in Power BI (Tutorial)
⚡⚡⚡ The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
00:00 Intro
00:30 the Files and playing along
01:44 importing the data and discuss the Calendar and Time Tables
05:25 The New Slicer
07:58 The New Card
12:12 The DAX formula for the up down arrow
12:49 Conditional formatting on the up down arrow
14:20 The Line Chart features
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
🔗Links
🔗 Online Version to play with: https://url.pbi.guide/EnergyReport
🔗Download a starting point file and the data: https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EjQ-FCZI75tAkO4j0raxXbwB7CJ0pRyKha0Q6-TQ4-V0gg?e=dSAcS0
🔗Access Analytic Template files: https://accessanalytic.com.au/free-excel-stuff/free-excel-templates/
🔗UNICHAR Codes: https://www.vertex42.com/ExcelTips/unicode-symbols.html
🔗The Conditional Formatting Video: https://youtu.be/WJ0PPKWHJPo?si=QjSk2cYzGb35VVXr
The DAX for the indicator
!!Note I cant use angled brackets here so Ive used emoji instead
Usage PY Variance Indicator =
//For use in Card Visual Details section
VAR _Variance = [Usage v Prior Year]
VAR _Result =
SWITCH(
TRUE(),
_Variance◀️0, UNICHAR(129055),
_Variance=0, UNICHAR(129112),
_Variance▶️0, UNICHAR(129053)
)
RETURN
_Result
Did you know Ive written a book Power BI for the Excel Analyst?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/ The Amazing New Slicer and Card visual in Power BI (Tutorial)](https://i.ytimg.com/vi/8mQn7Dmr9fg/mqdefault.jpg)





