Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch10/ExcelShort55-56.xlsx
Learn how to create text formula labels from a rectangualr range with elements that the formula needs from the column headers and row headers. Amazing Dynamic Spilled Array Formula. See the TEXT, FOMULATEXT and TOCOL functions as well as the Ampersand, the Join Operator.
Learn #excel #excelformulas #excelfunctions #Short #textformatting #ampersand #formulatext #excelisfun
Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch10/ExcelShort55-56.xlsx
Learn how to spill an array of estimated stock values based on an initial stock value and an array of various changing return % values. See the functions SCAN, REDUCE and PRODUCT.
Learn #excel #excelformulas #excelfunctions #Short #lambda #lambdaexpression #scan #reduce #scanfunction #excelscan
Download Excel file: https://people.highline.edu/mgirvin/AllClasses/excelisfun/YourNameBusn218Test01.xlsm
Learn how to create PivotTable To Count SalesRep Monthly Sales, and Visualize Trend in Monthly Sales.
Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch08/ExcelShort51-54.xlsx
Learn how to create a dynamic spilled array formula to build a Net Present Value Profile Table based on varying Required Rate of Return values and then build a chat to visualize the relationship between RRR and NPV. See how to visualize with an X-Y Scatter Chart.
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…”
***** 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”
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
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!”
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
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”
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
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