Analytics & AI for Modern Excel
The Internal Rate of Return (IRR) is a financial metric used to evaluate the profitability of an investment by calculating the discount rate at which the net present value (NPV) of a series of cash …
Continue Reading about Python in Excel: How to simulate IRR with Copilot →
Excel offers a vast number of functions, and one category that usually requires me to double-check my notes is financial functions—things like calculating loan repayments, future values, and similar …
Continue Reading about Copilot in Excel: How to work with financial functions →
A dependent dropdown list updates its options based on the choice made in a previous dropdown. For instance, if a user picks a state like Ohio or Michigan in one dropdown, the next dropdown for …
Continue Reading about How to create dynamic dropdown lists with dynamic arrays in Excel →
In BI tools such as Tableau and Power BI, one of the most common milestones toward intermediate learner status creating a Top N parameter. This feature allows users to choose a value for N (e.g., 3, …
Continue Reading about How to build a top N parameter in Excel →
Data validation is a fantastic feature in Excel that makes your spreadsheets easy to use and hard to break by controlling what data can be entered—like limiting cells to numbers, dates, or dropdowns. …
Continue Reading about How to create radio buttons in Excel with checkboxes →
When introducing newcomers to Python in Excel, I typically recommend that they have some basic Python knowledge beforehand. This helps reduce the mental effort required to grasp the Python in Excel …
