Category: Business

Discover the Untapped Settings in Power BI Desktop

Posted on by Annie D

There are a lot of settings within Power BI Desktop! Adam looks at a few you may not know about and should be aware of. Definitely review these!

📢 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 – rel=”nofollow”>https://guyinacube.com/tools/

#PowerBI #MicrosoftFabric #GuyInACube

Excel – Better Checkbox Style in Excel – Quick Tips #shorts #excelhacks

Posted on by Annie D

Microsoft Excel Tutorial: Better looking checkboxes in Excel.

📊 Want to upgrade the look of your Excel checkboxes? In October 2023, a new Checkbox icon was introduced on the Insert tab. While it offers a convenient way to toggle checkboxes using your mouse or the spacebar, it can feel a bit cluttered.

👉 In this quick tip, discover a sleeker alternative! Learn how to add checkboxes and then make them disappear with a simple press of the Delete key. They’ll reappear when you hover over the cells, and with a click or spacebar press, you can easily turn them on.

🔘 However, keep Continue reading “Excel – Better Checkbox Style in Excel – Quick Tips #shorts #excelhacks” →

Excel Formula: Extract City Name from Description. Excel Magic Trick 1839

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1839.xlsx
Learn about how to extract the city name from a description using the SEARCH and LOOKUP functions. Then see how to spill the formula with BYROW and LAMBDA functions.
Buy excelisfun’s book: The Only App That Matters:
Amazon: https://www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700
Mr Excel Web Site: https://www.mrexcel.com/products/microsoft-365-excel-the-only-app-that-matters/

Topics:
1. (00:00) Introduction
2. (00:05) SEARCH and LOOKUP functions
3. (02:39) BYROW and LAMBDA functions
4. (03:43) Summary
5. (03:52) Closing, Video Links

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

Excel – Exciting! Checkboxes Arrive In Excel – Episode 2628

Posted on by Annie D

Microsoft Excel Tutorial: Checkboxes arrive in Microsoft Excel

To download the workbook from today: https://www.mrexcel.com/youtube/kunbe45v7-E/

In this YouTube video, Bill Jelen enthusiastically announces the arrival of checkboxes in Microsoft Excel. They reminisce about the challenges they faced with checkboxes in the past, particularly when working on a report card system for a school district.

Jelen demonstrates how to use the new checkbox feature, emphasizing its location on the “Insert” tab. They show how to insert checkboxes into cells, toggle them on and off, and even use the space bar for quick toggling. The video also explores the underlying true Continue reading “Excel – Exciting! Checkboxes Arrive In Excel – Episode 2628” →

Endless Demo Data – GPT4’s Advanced Data Extraction Capabilities

Posted on by Annie D

Join me as I take you through an incredible discovery with ChatGPT 4’s Advanced Data Analysis plugin. From generating datasets tailored to specific industries to understanding the power of this tool, we’ll uncover the potential for data analysis and science in real-time.

🔍 What to Expect:
– An introduction to ChatGPT 4 and its Advanced Data Analysis capabilities.
– Generation of specific datasets across varied industries.
– Real-time creation and download of large datasets.
– Exploration of data analysis suggestions using AI.

🔧 Tools & Tech:
Discover the speed and versatility of ChatGPT 4 in generating datasets and providing actionable insights.

🚀 Real-time Results:
See firsthand the extraction of Continue reading “Endless Demo Data – GPT4’s Advanced Data Extraction Capabilities” →

Excel – Uncover Vehicle Repair Cost Secrets – Episode 2627

Posted on by Annie D

Microsoft Excel Tutorial: Calculate Average Cost per Year in Excel.

Derek has a fleet of vehicles and a list of all repairs made in the last 20 years. He wants to figure out how the annual repair and maintenance costs change as the vehicle ages.

In this video, MrExcel discusses how to calculate annual repair costs based on the age of a vehicle. He provides a data set of repairs made on a fleet of vehicles and explains how to determine the first date each vehicle was placed in service. He suggests using an approximation for vehicles without records by subtracting Continue reading “Excel – Uncover Vehicle Repair Cost Secrets – Episode 2627” →

Mastering Power BI Desktop: A Deep Dive into the Pane Switcher

Posted on by Annie D

On-Object Editing has been out for a bit in Power BI Desktop, and it came with a cool pane switcher! Adam walks through how to use the pane switcher and talks about some recent updates.

Use on-object interaction with visuals in your report (preview)
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #GuyInACube

Using ChatGPT To Supercharge Power BI Development

Posted on by Annie D

Leverage the power of ChatGPT to enhance your Power BI development process.

Details of what you will learn in this event series:

– Understand the potential of ChatGPT in enhancing Power BI development
– Learn how to integrate ChatGPT into your Power BI workflow
– Discover real-life examples of how ChatGPT can automate and streamline data analysis tasks
– Gain insights into best practices and tips for effective usage

How AI Is Changing Everything For Data Professionals

Posted on by Annie D

An outline of this event:

AI has emerged as a game-changer, transforming the way organizations analyze, interpret, and leverage data to drive insights, make informed decisions, and gain a competitive edge. Join us as we delve into the various aspects of AI and its profound implications for data professionals.

Whether you’re a data scientist, data analyst, or data engineer, this webinar will provide valuable insights and practical examples of how AI is changing the landscape for data professionals.

Details of what you will learn in this event:
– Highlighting the benefits and challenges of AI adoption in data-related work
– Understanding the role of AI Continue reading “How AI Is Changing Everything For Data Professionals” →

Using WORKOUTS to Master Data Skills

Posted on by Annie D

An outline of this event:

In the rapidly evolving field of data analytics, it is crucial for professionals to continuously upgrade their data skills to stay relevant and competitive. WORKOUTS is an innovative approach that combines hands-on exercises, practical applications, and collaborative learning to help data practitioners master data skills effectively.

In this virtual event, participants will engage in interactive and immersive learning experiences through a series of WORKOUTS sessions designed to enhance their data skills in a practical and engaging manner. The event will cover various data-related topics, tools, and techniques, and provide participants with opportunities to apply their learning in Continue reading “Using WORKOUTS to Master Data Skills” →