Learn how to use the IFS function to add the words Par, Discount or Premium to the cell next to the bond value.
#excelformula #excelfunctions #exceltutorial #exceltricks #exceltips #ifs #iffunction #IF #IFS #Logicaltest
Category: Business
Conditional Formatting for Bond Sold at Discount or Premium. #Short Excel Trick 43. ACCTG 455 # 50.1
Learn how to conditionally format cells when bond sells at a discount or premium.
#conditionalformatting #logicaltest #excel #excelformulas #excelfunctions
Deep Discount Loan Amortization Table (Treasury Bonds) . #Short Excel Trick 42. ACCTG 455.
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/455/ch05/ExcelShort42.xlsx
Learn how to use Dynamic Spilled Array Formulas to build a deep discount amortization table for a loan.
Learn #excel #excelformulas #excelfunctions
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
All this Microsoft Fabric… What about Power BI?
Everyone is talking about Microsoft Fabric. What about Power BI? What if all you want to do is Power BI? BUT! Is it an OR or is it an AND? Adam digs into where Power BI is and how to think about it.
📢 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
— <a href="https://www.instagram.com/guyinacube/" Continue reading “All this Microsoft Fabric… What about Power BI?”
Excel Spilled Loan Amortization Table. #Short Excel Trick 40
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/455/ch05/ExcelShort40.xlsx
Learn how to use Dynamic Spilled Array Formulas to build an amortization table for a consumer loan.
Learn #excel #excelformulas #excelfunctions
Excel Kill The Annoying Copilot Floating Icon – Episode 2667
Microsoft Excel Tutorial: Microsoft has a new Copilot icon that follows the active cell around Excel. It is super annoying. Here is how to get rid of it!
In yesterday’s video, DR Steele asked a great question: How do we remove this annoying Copilot icon that won’t go away? Microsoft doesn’t give us a global setting to turn it off, and every time you open a new workbook, it comes right back. Frustrating, right? Well, I’ve got a workaround!
Thanks to John Acampora, we found a way to manually hide the icon using a keyboard shortcut. But that’s not a permanent fix. Continue reading “Excel Kill The Annoying Copilot Floating Icon – Episode 2667”
STOP Using Measures in Power BI Until You See This!
Dreading making that DAX Measure? Maybe Visual Calcs is a better way to go in Power BI! Does this mean you can throw out DAX Measures? Jeffrey Wang joins Patrick to explain the value prop of both and when to use them.
Using visual calculations (preview)
https://learn.microsoft.com/power-bi/transform-model/desktop-visual-calculations-overview
Jeffrey Wang
https://www.linkedin.com/in/jeffrey-y-wang/
https://pbidax.wordpress.com/
📢 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
— <a href="http://twitter.com/awsaxton" Continue reading “STOP Using Measures in Power BI Until You See This!”
Excel Split Date Time Into Columns For Date And Then Time Episode – 2666
Microsoft Excel Tutorial: Split Date Time into Columns for Date and then Time.
In this video, we tackle an intriguing Excel challenge from a real-world job interview scenario. Imagine being asked to split a column of date and time into separate date and time fields, build a pivot table, and create a report limited to certain conditions—class equals 1 and days are Tuesday or Thursday. Sounds tricky, right? Let’s break it down step by step and explore multiple approaches!
First, we’ll discuss how to split the date and time using simple formulas like =INT(A2) for the date and =A2-D2 for the time, Continue reading “Excel Split Date Time Into Columns For Date And Then Time Episode – 2666”
Collin shares how community helped him with Power BI! #microsoftfabric
Ask questions and engage in the Microsoft Fabric & Power BI Community over at https://aka.ms/fabriccommunity!
#MicrosoftFabric #PowerBI
What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39
Learn about the difference between these two similar charts that both work perfectly with cross tabulated reports such as PivotTables with Row and Column Variables.
CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38
If you do not have file extensions turned on on your computer, trouble can occur. See how to change the worst Microsoft Office Default Setting: Uncheck the Box for Hide Known File Extensions.
Learn #excel #excelformulas #excelfunctions
#office #microsoft #microsoftexcel #microsoftoffice