Copilot Studio provides business professionals an exciting opportunity to create custom chatbots and virtual agents in a low/no-code environment. However, even though you don’t need to write the code …
How to understand actions in Copilot Studio
Large Language Models (LLMs) are celebrated for their ability to produce seemingly intelligent, well-reasoned responses on a wide range of topics. Increasingly, they can even browse the web …
Continue Reading about How to understand actions in Copilot Studio →
Python in Excel: How to simulate IRR with Copilot
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 →
Copilot in Excel: How to work with financial functions
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 →
How to create dynamic dropdown lists with dynamic arrays in Excel
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 →
How to build a top N parameter 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 →