Blog

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

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

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

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

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”

Bond Rate Risk: Longer Maturity, More YTM Affects Bond Price. #Short 47. ACCTG 455 #54.1

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

Mirror or Shortcut with Azure Databricks in Microsoft Fabric? YES!!!

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!!!”

Excel The Mysterious Chart Label That Wouldn’t Update – Solved! – Episode 2670

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”

Visualize Inverse Relationship for Bond Price & YTM Rate. #Short Excel Trick 46. ACCTG 455 50.4

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

Excel Change 3D Map From City To State – Episode 2669

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”

Spill Bond Valuation PV Function Formula Across YTM Rates. #Short Excel Trick 45. ACCTG 455 #50.3

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

How to Show “Discount 10%” in Excel Using Formulas & Custom Formatting – Episode 2668

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″