ExcelHow to Use Power Pivot in Excel to Build a Relational Data Model from Multiple Tables
Standard Excel Pivot Tables are excellent for summarising data from a single table, but they...
ExcelHow to Protect Excel VBA Macros with a Password to Prevent Unauthorized Access
Introduction Microsoft Excel’s Visual Basic for Applications (VBA) allows users to build incredibly powerful macros...
ExcelHow to Use Mail Merge in Microsoft Word with an Excel Data Source
Introduction When you need to send personalized letters, print custom envelopes, or generate hundreds of...
ExcelHow to Create Dynamic Named Ranges in Microsoft Excel using the OFFSET and COUNTA Functions
Introduction A standard Named Range in Excel is static; if you define a range as...
ExcelHow to Use Power Query in Microsoft Excel to Automate Data Cleaning
Introduction Data analysts often spend a significant amount of time manually cleaning and formatting raw...
ExcelHow to Use the YIELDMAT Function to Calculate Yield at Maturity in Excel
The Anomaly of the Final Payout If you purchase a standard corporate bond, calculating your...
ExcelHow to Use the COUPNCD Function to Calculate the Next Coupon Date in Excel
The Calendar Crisis In the world of corporate finance, missing an interest payment (a “coupon”...
ExcelHow to Use the PRICEMAT Function to Calculate Bond Prices at Maturity in Excel
The Mathematical Exception In standard bond finance, when you purchase a corporate bond, the corporation...
ExcelHow to Use the TBILLPRICE Function to Calculate Treasury Bill Prices in Excel
The Price of Government Debt Unlike standard corporate bonds, United States Treasury Bills (T-Bills) do...
ExcelHow to Use the TBILLEQ Function to Calculate Treasury Bill Equivalent Yields in Excel
The Incomparable Treasury Bill If you are an investor analyzing corporate bonds, comparing two different...
ExcelHow to Use the ODDLYIELD Function to Calculate Odd Last Period Bond Yields in Excel
The Mathematical Distortion In standard bond finance, consistency is the foundation of every single formula....
ExcelHow to Use the ODDLPRICE Function to Calculate Odd Last Period Bond Prices in Excel
The Odd Last Period Problem In standard bond finance, a corporate bond is mathematically symmetrical....
ExcelHow to Use the ODDFYIELD Function to Calculate Odd First Period Bond Yields in Excel
The Mathematical Anomaly In the world of corporate finance, a standard bond is perfectly symmetrical....
ExcelHow to Use the ODDFPRICE Function to Calculate Odd First Period Bond Prices in Excel
The Broken Bond Calendar In standard bond finance, everything is perfectly symmetrical. If a corporation...
ExcelHow to Use the YIELDDISC Function to Calculate Discounted Bond Yields in Excel
The Math of the Zero-Coupon Return If you purchase a standard corporate bond, calculating your...
ExcelHow to Use the DISC Function to Calculate Bond Discount Rates in Excel
The Mystery of the Discounted Bond Unlike standard corporate bonds that pay you interest every...
ExcelHow to Use the RECEIVED Function to Calculate Bond Receipts in Excel
The Confusion of Fully Invested Bonds In standard fixed-income finance, calculating the value of a...