Blog

Bonbon's Guide To Data & Tech > Blog

Excel – Naked Cowboy Sings for Spreadsheet Day from Times Square #excel #nsfw – Episode S0050

Posted on by Annie D

Microsoft Excel Tutorial: 🎵 Celebrating Spreadsheet Day in Times Square with the Naked Cowboy! 🎵 | Excel Song and Serenade.

Welcome to my latest video, where the Naked Cowboy, is celebrating Spreadsheet Day from the iconic Times Square in New York City. As a lover of all things Excel, he couldn’t resist the opportunity to serenade the accounting team and all spreadsheet enthusiasts out there with a special song. So, grab your calculators and get ready to sing along with me!

For those who may not know, Spreadsheet Day falls on October 17th and is a day dedicated to celebrating the powerful Continue reading “Excel – Naked Cowboy Sings for Spreadsheet Day from Times Square #excel #nsfw – Episode S0050” →

Excel – First Look At Copilot AI For Excel – Episode 2636

Posted on by Annie D

Microsoft Excel Tutorial: Preview of AI Copilot for Excel.

Welcome to episode 2636 of Mr. Excel’s netcast! In this video, we will be taking a first look at Copilot AI for Excel, a new feature from Microsoft that has been generating a lot of buzz. I was lucky enough to get a sneak peek at this feature, even though it was initially only available for enterprises with over 100 customers. But now, I have access to it and I’m excited to share it with you.

In this video, we will be exploring the Copilot feature and its capabilities. We will be working Continue reading “Excel – First Look At Copilot AI For Excel – Episode 2636” →

We’ve been working on something new…

Posted on by Annie D

Join me as I take you on a journey with our new tool, Data Mentor on Enterprise DNA. Dive into the world of AI-enhanced tools from Code Generators, Debuggers to Visualizers, and Advisors. Understand how Data Mentor can transform your data analytics approach and enhance your AI-driven solutions.

🔍 What to Expect:
– A detailed walkthrough of the Data Mentor’s various AI tools.
– Dive into ‘Creators’ tools like the Pseudo Code Generator and Regex Generator.
– Uncover the potential of ‘Debuggers’ such as the Exception Handler and Syntax Corrector.
– Explore the insights offered by ‘Visualizers’ like the Code Simplifier and Logic Visualizer.
– Introduction Continue reading “We’ve been working on something new…” →

Adding a column to your Lakehouse? Where is it in the Semantic Model???

Posted on by Annie D

When you add a column to your lakehouse in Microsoft Fabric, why isn’t is showing up in the Power BI Semantic Model? Patrick shows you how to get it there!

Gaston Cruz
https://twitter.com/GastonFCruz
https://www.linkedin.com/in/gastoncruz/

📢 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***
🛠 Continue reading “Adding a column to your Lakehouse? Where is it in the Semantic Model???” →

Become A Power BI Power User With DAX

Posted on by Annie D

Business Intelligent Summit are action packed live events showcasing a variety of beginner to advanced Power BI/Power Platform tips and techniques. Summit sessions have a unique focus on how anyone can build and develop analytical solutions with Power BI that solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

***** Details of what you will learn during this event series module *****
Control – the Query, Filter, and Row contexts to write DAX expressions
Realize – what you can achieve when you use the CALCULATE function to inject a filter context
Learn – how to Continue reading “Become A Power BI Power User With DAX” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 4, 2023)

Posted on by Annie D

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.

NOTE: European friends, Time zone trickery is here. It’s an hour different from what it normally is.

💥 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 Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 4, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Nov 11, 2023)

Posted on by Annie D

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 (Nov 11, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE (Dec 9, 2023)

Posted on by Annie D

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 (Dec 9, 2023)” →

REPLAY Microsoft Fabric / Power BI Q&A – LIVE w/ Kim Manis & Bogdan Crivat (Dec 16, 2023)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI) with special guests Kim Manis & Bogdan Crivat from the Fabric Product Team! Get your questions in the chat early as we don’t get to all of them.

This is also the last stream of 2023. It’s time to donate the money in the “It Depends” jar! We have also listed this stream as a fundraiser stream for St. Jude Children’s Hospital. The mission of St. Jude Children’s Research Hospital is to advance cures, and means of prevention, for pediatric catastrophic diseases through research and treatment. Learn Continue reading “REPLAY Microsoft Fabric / Power BI Q&A – LIVE w/ Kim Manis & Bogdan Crivat (Dec 16, 2023)” →

REPLAY Starting off 2024! Microsoft Fabric LIVE Q&A (Jan 6, 2024)

Posted on by Annie D

Join us live as we start off 2024 by answering your questions 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 Continue reading “REPLAY Starting off 2024! Microsoft Fabric LIVE Q&A (Jan 6, 2024)” →

Join us at SQLBits 2024 and save 10%!

Posted on by Annie D

We will be at SQLBits and want to see you there! You can save 10% by using code giac10. Join us to learn great stuff about Microsoft Fabric and Power BI!

SQLBits 2024
Farnborough, UK
March 19-23, 2024
https://sqlbits.com
Theme: Aviation
10% discount: giac10

📢 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/
— Continue reading “Join us at SQLBits 2024 and save 10%!” →

Don’t Use PivotTables. Use COUNTIFS or FREQUNCY Functions Instead. Excel Magic Trick 1849

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1847-1849.xlsx
Learn about how PivotTables cannot include upper limit when grouping number data with decimals. COUNTIFS and FREQUNCY Functions do include upper limits when grouping numbers into upper and lower limit categories.
Topics:
1. (00:00) Introduction
2. (00:06) PivotTable
3. (01:45) COUNTIFS
4. (02:49) Text Labels for Formula Report
5. (03:25) Find Feature to create labels for PivotTable
6. (03:56) FREQUENCY Array Function
7. (05:15) Summary
8. (05:30) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #xlookup