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

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″

Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41. ACCTG 455.

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/455/ch05/ExcelShort41.xlsx
Learn how to use Dynamic Spilled Array Formulas to build an equal principal payment amortization table for a loan.
Learn #excel #excelformulas #excelfunctions