How do I derive statistical power value using Microsoft excel

How much of the question is specific to Excel and how much is a broader statistics question?

When I put "how to calculate statistical power" into my favorite search engine, it seems that most sites simple say, "it is complex enough that it is best to let your statistical software package do the calculation." Obviously assuming that you are using a statistical package that has a built in "statistical power" function/utility. I don't think Excel has such a built in function, so you would need to build your own formula for it that requires that you know the equations and formulas needed to calculate power before you can program those into Excel. Since I see no attempt to explain the statistical formulas needed to calculate power, I'm not sure how much help we can be (unless one of our users just happens to know those formulas).

For almost anything delving deep into statistics in Excel, I find Charles's website useful (link to his "statistical power" page): https://www.real-statistics.com/hypo...istical-power/. His real statistics add-in for Excel has several functions related to statistics (including, if I read the linked page right, functions for calculating power). If you are allowed to use third party add-ins, this might be a useful resource for this and other statistical functions you are trying to do in Excel.

Of course, there's also the old statistician's standby (posted on the door of a former coworker with significant education in statistics) -- Friends don't let friends use Excel for statistics. If you are not required to use Excel, there might be value in seeking out a more robust statistics package/application.