ExcelHow to Use the PRICEDISC Function to Calculate Discounted Bond Prices in Excel
The Math of the Discounted Bond In the world of high-level finance, not all bonds...
ExcelHow to Use the ISPMT Function to Calculate Straight-Line Interest in Excel
The Illusion of Even Payments If you take out a standard $500,000 mortgage from a...
ExcelHow to Use the RRI Function to Calculate Interest Rates in Excel
The Hidden Math of Investments In the world of finance, calculating interest rates manually is...
ExcelHow to Use the PDURATION Function to Calculate Investment Time in Excel
The Uncertainty of Investing If you are a financial advisor managing a client’s retirement portfolio,...
ExcelHow to Use the VDB Function for Variable Declining Balance Depreciation in Excel
The Reality of Corporate Assets If a massive construction company buys a brand new bulldozer...
ExcelHow to Use the IRR Function to Calculate Internal Rate of Return in Excel
The Flaw in Net Present Value In corporate finance, determining if a multi-year project is...
ExcelHow to Use the ARABIC Function to Convert Roman Numerals in Excel
The Problem with Ancient Accounting In modern finance and data analysis, we exclusively use Arabic...
ExcelHow to Use the MODE.SNGL Function to Find the Most Frequent Number in Excel
The Search for the Most Common Item In Microsoft Excel, finding the arithmetic average of...
ExcelHow to Use the NPV Function to Calculate Net Present Value in Excel
The Time Value of Money If a business partner offers you a choice between receiving...
ExcelHow to Use the MINIFS Function to Find the Smallest Value with Criteria in Excel
The Need for Conditional Minimums If you are analyzing a massive spreadsheet containing thousands of...
ExcelHow to Use the ISNA Function to Handle N/A Errors in Excel
The Frustration of Missing Data One of the most powerful tools in Microsoft Excel is...
ExcelHow to Use the ISERROR Function to Handle Calculation Errors in Excel
The Cascade of Panic In Microsoft Excel, calculation errors are highly contagious. If you write...
ExcelHow to Use the TEXTAFTER Function to Extract Substrings in Excel
The Pain of Data Cleaning In Microsoft Excel, dealing with data exported from external systems...
ExcelHow to Use the TEXTBEFORE Function to Extract Substrings in Excel
The Nightmare of Unstructured Text In Microsoft Excel, data imported from external websites or legacy...
ExcelHow to Use the TOCOL Function to Convert Arrays to Columns in Excel
The Problem with Multi-Column Data In Microsoft Excel, data is often structured visually for humans...
ExcelHow to Use the DROP Function to Remove Rows from an Array in Excel
The Problem with Extraneous Data In Microsoft Excel, when you use a function like SORT...
ExcelHow to Use the CHOOSECOLS Function to Reorder Array Columns in Excel
The Problem with Static Data Grids In Microsoft Excel, when you import a massive dataset...