Category: Power Query


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Mar 2, 2024) (Member Chat 2nd Half)

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


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric

Posted on by Annie D

Who needs NOCODE? Patrick takes you on a journey where you can extract ZIP files within a Notebook in Microsoft Fabric. Also found a very cool feature in Notebooks!

📢 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 href="https://guyinacube.com/tools/" Continue reading “All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

NO CODE extract ZIP files with Pipelines in Microsoft Fabric

Posted on by Annie D

Need to extract ZIP files and don’t want to write code? Adam walks you through how you can do this with Pipelines and dataflows within Microsoft Fabric. A NO CODE approach!

📢 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 – Continue reading “NO CODE extract ZIP files with Pipelines in Microsoft Fabric” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Formulas to convert to Upper, Lower, or Proper Case #excel

Posted on by Annie D

Microsoft Excel Tutorial: Upper, Lower, Proper Case with a Formula in Excel.

In this tutorial, learn how to effortlessly convert text to upper, lower, or proper case using Excel formulas. Discover three essential functions that streamline the case conversion process. Whether you’re transforming text to lowercase with LOWER(A2), uppercase with UPPER(B2), or proper case with PROPER(C2), these functions have you covered. But beware of nuances – even PROPER doesn’t always nail the interior ‘C’ in McCartney, necessitating manual adjustments.
But what about real-world scenarios where your data extends beyond the conversion zone? Fear not! We’ll guide you through inserting a temporary column Continue reading “Excel Formulas to convert to Upper, Lower, or Proper Case #excel” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Number of Days To End of Year for Reaching a Goal

Posted on by Annie D

Microsoft Excel Tutorial: Calculate Number of Days to End of Year for Reaching a Goal.

Thanks to Kikas for this idea!

Unlock the secrets of Excel productivity with our latest tutorial! In this comprehensive guide, we unravel the complexities of Excel calculations to streamline your task management process. Are you struggling to determine the number of items you need to complete daily to meet your year-end goals? Look no further! Speaker 1 expertly guides you through the process, breaking down intricate formulas into simple, actionable steps.

Discover how to calculate the precise number of items you need to tackle each day to ensure Continue reading “Excel Number of Days To End of Year for Reaching a Goal” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Join First Name and Last Name as Proper Case

Posted on by Annie D

Microsoft Excel Tutorial: Join First Name and Last Name as Proper Case in Excel.

Buy my new book here: https://www.mrexcel.com/products/latest/

Welcome back to another Excel tutorial! Today, we’re diving into the efficient method of joining first names and last names in your spreadsheet while ensuring they are displayed in proper case. Join MrExcel as he walks you through the simple yet powerful techniques to achieve this task seamlessly.

Key Points Covered:
• Learn the fundamental formula using the CONCATENATE operator to merge first names and last names from different cells.
• Discover how to convert the combined text into proper case using Continue reading “Excel Join First Name and Last Name as Proper Case” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Feb 24, 2023) (Member Chat 2nd Half)

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


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Fast Way to Copy Formula to Bottom of Data in Five Keystrokes #excel

Posted on by Annie D

Microsoft Excel Tutorial: Fast Way to Copy Formula to Bottom of Data in Five Keystrokes.

This tip is from the book MrExcel 2024 – Igniting Excel. Buy the book here: https://www.mrexcel.com/products/latest/

Check out this video to learn how to copy formulas to the bottom of your data in Excel using just five keystrokes! 🚀
If you’re a fan of keyboard shortcuts, this trick will save you tons of time. Here’s a quick rundown:
1. Left arrow to B2.
2. Ctrl + down arrow.
3. Right arrow.
4. Ctrl + Shift + up arrow to select to the top.
5. And the magic: Ctrl + D Continue reading “Excel Fast Way to Copy Formula to Bottom of Data in Five Keystrokes #excel” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Creating your first EVENTSTREAM in Microsoft Fabric

Posted on by Annie D

Join Patrick as he explores Real-Time Analytics (RTA) in Microsoft Fabric by creating an event stream into a KQL Database. It only takes a few clicks!

What is RTA:
https://learn.microsoft.com/en-us/fabric/real-time-analytics/overview

Event Streams overview:
https://learn.microsoft.com/en-us/fabric/real-time-analytics/event-streams/overview

📢 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 Continue reading “Creating your first EVENTSTREAM in Microsoft Fabric” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Fastest Way to Copy Formula to All Rows #excel

Posted on by Annie D

Microsoft Excel Tutorial: Fastest Way to Copy Formula to All Rows.

Check out this tutorial on Excel’s Fast Way to Copy Formula to All Rows!

Are you tired of dragging your formulas down to thousands of rows? Say goodbye to that tedious process! In this video, we’ll show you a quick and efficient method to copy your formulas across multiple rows without the hassle.

Most people start by creating their formula in the first row, then painstakingly drag it down, row by row. It’s slow, it’s frustrating, and it’s not efficient. But fear not! We have a solution that will save you time Continue reading “Excel Fastest Way to Copy Formula to All Rows #excel” →


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

🔴 Microsoft Fabric / Power BI Q&A – LIVE (Feb 17, 2023) (Member Chat 2nd Half)

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


Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Keeps Inserting Old Formula – How to Fix It! – Episode 2640

Posted on by Annie D

Microsoft Excel Tutorial: Excel Keeps Inserting Old Formula – How to Fix It!

Every time that Tori adds a new row to her Excel table, four columns auto-fill formulas from years ago.

Oh my gosh. Ever had a crazy frustrating problem with Excel? In this video, we tackle Tori’s Excel nightmare head-on. Tori’s adding new rows to her table, only to find four columns haunted by formulas from three years ago! What gives?

Hey there! If you’re facing Excel woes like Tori, hit that Like button below to help more folks find this solution-packed video – thanks for the support!

Picture this: Tori’s table Continue reading “Excel Keeps Inserting Old Formula – How to Fix It! – Episode 2640” →