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
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
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
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”
Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch06/ExcelShort43-49.xlsx
Create a table of Bond Values based on changing YTM and Years to Maturity. Then Create an Excel X-Y Scatter Chart to visualize: Longer The Maturity, More YTM Affects Bond Price.
Learn #excel #excelformulas #excelfunctions
Using Azure Databricks? Confused if you should just use a shortcut or mirror it? Perhaps the answer is YES! Patrick shows you the benefits of using the mirroring capability with Azure Databricks.
Mirroring Azure Databricks Unity Catalog (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-databricks
Tutorial: Configure Microsoft Fabric mirrored databases from Azure Databricks (Preview)
https://learn.microsoft.com/fabric/database/mirrored-database/azure-databricks-tutorial
📢 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
— <a Continue reading “Mirror or Shortcut with Azure Databricks in Microsoft Fabric? YES!!!”
Create an Excel X-Y Scatter Chart to show inverse relationship between Bone Value and YTM Rate (Discount Rate).
Learn #excel #excelformulas #excelfunctions
Microsoft Excel Tutorial: The Mysterious Chart Label That Wouldn’t Update – Solved!
A completely evil Excel problem! A chart label refuses to update, no matter what you do. My friend Kelly sent me this chart, and everything seemed fine—except for one stubborn label that always says “Test 1.” Even after checking that the labels are correctly linked to a range using “Value From Cells,” this one label remains broken. After trying everything, I had to reach out to someone on the Excel team, and they finally gave me the answer.
Turns out, the label became disconnected from the data, and there’s a Continue reading “Excel The Mysterious Chart Label That Wouldn’t Update – Solved! – Episode 2670”
Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch06/ExcelShort43-49.xlsx
Create an Excel X_ Scatter Chart to show inverse relationship between Bone Value and YTM Rate (Discount Rate).
Learn #excel #excelformulas #excelfunctions
Microsoft Excel Tutorial: Use 3D Maps to summarize city data at the state level.
Got sales data by city but need to display it by state in Excel’s 3D Maps? A.K. asked if there’s a way to sum sales at the state level instead of individual cities—yes, and it’s easy to do! In this tutorial, I’ll walk you through the steps to modify your 3D Map to show sales totals by state.
By default, Excel’s 3D Map plots data at the city level. If you want to switch to state-level mapping, simply adjust the location field to use State instead of Continue reading “Excel Change 3D Map From City To State – Episode 2669”
Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch06/ExcelShort43-49.xlsx
Use PV Function and spill a bond valuation formula across increasing YTM Rates to illustrate the inverse relationship between Bond Price and YTM Rate (Discount Rate).
Learn #excel #excelformulas #excelfunctions #npv #presentvalue #bonds #bondvaluation
Microsoft Excel Tutorial: Formula To Show Word Next To Discount Percentage. How to Show “Discount 10%” in Excel Using Formulas & Custom Formatting.
Today’s question comes from Roo: How can we modify a dropdown list of discount percentages (10%, 20%, 30%) to display as “Discount 10%” on an invoice? This video covers multiple ways to achieve this, whether your percentages are stored as text or numbers.
First, we look at a simple formula approach. By using a basic concatenation formula with an ampersand (`&`), we can combine the word “Discount” with the selected percentage. However, if your percentages are stored Continue reading “How to Show “Discount 10%” in Excel Using Formulas & Custom Formatting – Episode 2668″