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.
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
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
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