Blog

Bonbon's Guide To Data & Tech > Blog

Fast Keyboard to Create Excel PivotTable Excel Short Magic Trick 73

Posted on by Annie D

In this short, learn the fast keyboard to create a PivotTable: Alt, N, V, T. This is an outtake from Excel Basics Data 08, Introduction to Data Analysis:
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics08.xlsx
Pdf notes (free book): https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics08.pdf
Link to full Excel Basics Class: https://www.youtube.com/watch?v=rXwZITn70Xo&list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo&index=9
Link to full Data Analysis Class: https://www.youtube.com/watch?v=rXwZITn70Xo&list=PLrRPvpgDmw0kCv2ulsHk4uitL9meshr_k&index=1

Video has subtitles in these languages: Afrikaans, Arabic, Bangla, Bangla (India), Dutch, Filipino, Hindi, Indonesian, Khmer, Malay, Swahili, Thai, Urdu, Vietnamese

#dataanalysis #excel #excel365 #office365 #office365training #excelisfun #pivot_table #pivot #pivottable #pivottables #keyboards #keybaord #keyboardshortcuts #excelbasics #excelbasicsforbeginners

MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!

Posted on by Annie D

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics08.xlsx
Pdf notes (free book): https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics08.pdf
Link to full Excel Basics Class: https://www.youtube.com/watch?v=rXwZITn70Xo&list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo&index=9
Link to full Data Analysis Class: https://www.youtube.com/watch?v=rXwZITn70Xo&list=PLrRPvpgDmw0kCv2ulsHk4uitL9meshr_k&index=1

In this video get an introduction to data analysis, data, information, and the Excel features: Excel Tables, PivotTables, Slicers, Excel Charts and Conditional Formatting.

Video has subtitles in these languages: Afrikaans, Arabic, Bangla, Bangla (India), Dutch, Filipino, Hindi, Indonesian, Khmer, Malay, Swahili, Thai, Urdu, Vietnamese

Topics:
1. (00:00) Introduction
2. (00:29) Topics in Video
3. (01:13) Define Data Analysis, data and information
4. (03:38) What is Raw Data?
5. (04:13) What is a table?
6. (06:12) List Continue reading “MS 365 Excel Basics 08: PivotTables, Slicers, Charts, Conditional Formatting, Data Analysis Tips!” →

🔴 Microsoft Power BI / Fabric Q&A – LIVE (March 22, 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 22, 2025) (Member Chat 2nd Half)” →

Watch Me Build Microsoft Purview From SCRATCH

Posted on by Annie D

Need governance? Of course you do! Marthe is pumped to show you how to spin up Microsoft Purview in just a few clicks. This is your ticket to data governance that cuts through chaos and puts you in the driver’s seat. Strap in, and let’s transform your data estate together!

Create a Microsoft Purview account
https://learn.microsoft.com/purview/legacy/create-microsoft-purview-portal

📢 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!
*******************

— https://bsky.app/profile/guyinacube.bsky.social
— Continue reading “Watch Me Build Microsoft Purview From SCRATCH” →

Harvesting Insights, Block by Block (Minecraft + Microsoft Fabric)

Posted on by Annie D

Join Simon Nuss on a thrilling Minecraft adventure where a Microsoft Fabric telemetry block breathes new life into every harvested pixel. Watch as your farm data is instantly streamed and visualized in Power BI, showcasing the raw power of real-time intelligence. Brace yourself for an unforgettable glimpse into the magic of Microsoft Fabric.

Simon Nuss:
https://www.linkedin.com/in/simon-nuss/

Subreddits
https://www.reddit.com/r/MicrosoftFabric/
https://www.reddit.com/r/PowerBI/

📢 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: <a href="https://guyinacu.be/courses" target="_blank" Continue reading “Harvesting Insights, Block by Block (Minecraft + Microsoft Fabric)” →

Why Supabase Is the Ultimate Tool for Databases, Back End Tasks, and Authentication

Posted on by Annie D

***** Video Details *****
Looking for a powerful all-in-one solution for your app development? Supabase has got you covered! From managing databases to handling back-end tasks and setting up authentication, Supabase makes it easy to get started. Whether you’re a beginner or a pro, streamline your development process with this versatile tool.

***** Related Links *****
https://supabase.com/
https://lovable.dev/

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
EDNA Learn – https://app.enterprisedna.co/app
Data Mentor – https://mentor.enterprisedna.co/
EDNA Chat – https://mentor.enterprisedna.co/chat
Enterprise DNA Subscriptions – <a Continue reading “Why Supabase Is the Ultimate Tool for Databases, Back End Tasks, and Authentication” →

Skip Coding! Lovable Enables You To Create Apps with Simple Commands

Posted on by Annie D

***** Video Details *****
No coding experience? No problem! With Lovable, you can build powerful apps just by describing what you want in plain English. It handles everything — front-end, back-end, databases, and even authentication using Superbase. No more struggling with GitHub or writing complex code. Just talk or type, and Lovable brings your vision to life.

***** Related Links *****
https://lovable.dev/
https://supabase.com/

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
EDNA Learn – https://app.enterprisedna.co/app
Data Mentor – https://mentor.enterprisedna.co/
EDNA Chat – <a href="https://mentor.enterprisedna.co/chat" Continue reading “Skip Coding! Lovable Enables You To Create Apps with Simple Commands” →

Effortlessly Sync Your Projects to GitHub with This Powerful Tool!

Posted on by Annie D

***** Video Details *****
Managing your code has never been easier! Lovable streamlines best-practice coding and now automates GitHub repository creation—no more manual setup. Traditionally, you’d have to handle pull and push requests manually, but Lovable gets you started instantly.

If you’re serious about development, having a GitHub account is non-negotiable—it’s your central hub for all projects. Haven’t set one up yet? Now’s the time!

***** Related Links *****
https://lovable.dev/
https://github.com/

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
EDNA Learn – https://app.enterprisedna.co/app
Data Mentor – <a Continue reading “Effortlessly Sync Your Projects to GitHub with This Powerful Tool!” →

PivotTable Automatically Pulls Number Formatting From Data Source: Finally!!! Excel Magic Trick 1879

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1879.xlsx
Learn about the automatic number formatting that a PivotTable applies to calculations based on the source data number formatting
Topics:
1. (00:00) Introduction.
2. (00:12) PivotTable with Automatic Number Formatting
3. (01:16) Closing

#excel #microsoft #excelisfun #excelcourse #pivottable #pivot_table #pivots

🔴 Microsoft Power BI / Fabric Q&A – LIVE (March 15, 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 15, 2025) (Member Chat 2nd Half)” →

Data Validation List Remove Duplicates, Not Past 33,000? TRUE: Then Go Old School! EMT 1878

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1878.xlsx
See that the Data Validation List feature removes duplicates up to 33,000 rows. After that, we must do old school methods: SORT and UNIQUE functions, or even older school methods from the 2012 Ctrl Shift Enter Mastering Excel Array Formulas Book.
ExcelLambda from YouTube supplies awesome solution!
Topics:
1. (00:00) Introduction
2. (00:03) New Ability of Data Validation List to Remove Duplicates
3. (01:06) Example of New Feature When It Does Not Work Poast Rows 33,000
4. (01:27) Old Fashion Way to Overcome New Feature Limited Row Ability
5. (02:20) Summary
6. (02:29) Closing

#excel #microsoft #excelisfun #excelcourse #datavalidation #excelfail

Connection woes using Power BI Direct Lake and an App???

Posted on by Annie D

Stop the hassle of interrupted connections in Power BI when using Direct Lake. Marthe guides you through setting up a fixed identity so your published apps can be leveraged without giving direct access to OneLake.

Specify a fixed identity for a Direct Lake semantic model
https://learn.microsoft.com/fabric/fundamentals/direct-lake-fixed-identity

Setting up RLS on a Direct Lake semantic model
https://www.datazoe.blog/post/setting-up-rls-on-a-direct-lake-semantic-model

📢 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!
*******************

— <a href="http://twitter.com/guyinacube" target="_blank" Continue reading “Connection woes using Power BI Direct Lake and an App???” →