Month: February 2025

Your Connections are a MESS! Let’s clean it up…

Posted on by Annie D

Have you ever looked at the Connections area in Microsoft Fabric? Even all the Power BI folks should look at this! It can get out of control. Patrick shows how he approaches the chaos of connections.

Data source management
https://learn.microsoft.com/fabric/data-factory/data-source-management

📢 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 “Your Connections are a MESS! Let’s clean it up…” →

Exploring AI in Application Development

Posted on by Annie D

***** Video Details *****
Discover how AI is revolutionizing application development, enabling you to build apps 10x faster and at a fraction of the cost. This video explores AI-powered tools, automation strategies, and best practices to streamline your development process and maximize efficiency. Whether you’re a beginner or an experienced developer, you’ll gain insights into leveraging AI for smarter, more cost-effective app creation.

***** Related Links *****
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 – Continue reading “Exploring AI in Application Development” →

Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53. ACCTG 455 #68.3

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch08/ExcelShort51-54.xlsx

Learn how to calculate the Internal Rate of Return for a set of cash flows, including the cash flow at time zero. Learn about the IRR Excel function.

Learn #excel #excelformulas #excelfunctions #text
#npv #irr #netpresentvalue #internalrateofreturn

Upgrade to a free Microsoft Fabric Trial? I already have capacity!

Posted on by Annie D

I wanted to start using some of the new Preview features in Microsoft Fabric when I got a message saying I needed to “Upgrade to a free Microsoft Fabric Trial”. Huh??? I already have the workspace in a Capacity! Adam explains what might be happening.

Create a SQL database in the Fabric portal
https://learn.microsoft.com/fabric/database/sql/create

Create an AI skill (preview)
https://learn.microsoft.com/fabric/data-science/how-to-create-ai-skill

📢 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 “Upgrade to a free Microsoft Fabric Trial? I already have capacity!” →

Net Present Value: Do We Buy Asset? PV or NPV Function? #Short 52. ACCTG 455 #68.2

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch08/ExcelShort51-54.xlsx
Learn how to calculate the Net Present Value to determine if you should buy and asset. Learn the PV and NPV Excel Financial Functions.

Learn #excel #excelformulas #excelfunctions #text #npv #pv
#capitalbudgeting #netpresentvalue

Excel Three Bots Versus Three Gurus Episode 2672

Posted on by Annie D

Microsoft Excel Tutorial: Solving a Text Comparison Problem: 3 AI Bots versus 3 Humans.

To download the workbook from today: https://www.mrexcel.com/youtube/GPLLrcq3D3A/

The battle is on! In Episode 2672, we’re pitting three AI bots (Deep Seek, Copilot, and Beta Copilot with Python) against three (and a half) human Excel gurus (Rico, XLLambda, and Geert). Who will come up with the best solution for an Excel text comparison problem?

This challenge comes from Brian, who wanted to compare two text strings and extract the differences. Seems simple, right? Well, not quite! My initial formula had some issues, so I turned to Continue reading “Excel Three Bots Versus Three Gurus Episode 2672” →

Build Text Formula for Dynamic Label For Financial Model. #Short 51. ACCTG 455 #68.1

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch08/ExcelShort51-54.xlsx
Learn how to build a dynamic text formula using:
1. “Text is Quotes”
2. Join Operator = & (Shift 7)
3. Text Functions like:
• DOLLAR = Currency Number Format to Number
• TEXT = Any Number Format to Number
• FIXED Number Format to Number
• TEXTJOIN = Joins Text with Delimiter

Learn #excel #excelformulas #excelfunctions #text
#textformatting

Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50. ACCTG 455 #63.2

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch07/ExcelShort49-50.xlsx
Learn how to spill the constant dividend stock price model formula as the required rate of return changes and then plot the results using an X-Y Scatter Chart.
Learn #excel #excelformulas #excelfunctions #Chart #Excelchart #XYSCATTER

Visualize How Stock Values Changes as Dividend Growth Rate Changes. #Short 49. ACCTG 455 #63.1

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch07/ExcelShort49-50.xlsx
Learn how to spill the constant dividend stock price model formula as the constant growth rate changes and then plot the results using an X-Y Scatter Chart.
Learn #excel #excelformulas #excelfunctions #Chart #Excelchart #XYSCATTER

Bond Rate Risk: Lower Coupon Rate, The More YTM Affects Bond Price. #Short 48. ACCTG 455 #54.2

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch06/ExcelShort43-49.xlsx
Create table of bond values with PV Function and see that lower coupon bonds will have bond price more affected by changes in Yield To Maturity (YTM) than higher coupon bonds.
Learn #excel #excelformulas #excelfunctions
#bondvaluation #pvfunction #presentvalue

Excelisfun Needs Your Help in Solving A Formula Number Formatting Mystery. #Short 52 Part 02

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch08/ExcelShort51-54.xlsx
I need help solving a Number Formatting Formula Problem: 1) No cells have been pre=formatted with Currency Number Formatting, 2) Cell with formula has no Number Formatting, 3) But if you create a formula in a cell Currency Number Formatting Appears?!!?!?!?!?!?
Learn #excel #excelformulas #excelfunctions #text #numberformat

Excel Copilot Versus Deep Seek Head to Head – Episode 2671

Posted on by Annie D

Microsoft Excel Tutorial: Deep Seek vs. Copilot: Head-to-Head Excel Formula Challenge!

Welcome to Learn Excel from MrExcel Podcast, Episode 2671! Today, we’re putting two AI-powered assistants to the test—Deep Seek vs. Copilot—to see which one performs better in Excel formula creation and formula explanation. Who will come out on top? Stick around to find out!

Test #1: Formula Creation

I started with a simple yet classic Excel challenge: detecting prime numbers in a column of integers. Deep Seek provided both a helper column approach and a single-cell array formula, while Copilot struggled due to the requirement for Auto Save to be turned on. Continue reading “Excel Copilot Versus Deep Seek Head to Head – Episode 2671” →