Your presentation is good, however honestly, I am not sure how Copilot is going to simplify my life. All that you demonstrated can be done in a traditional way, much faster! Why so much hype on Copilot?
I can forgive you for the error since you're clearly not an accounting professional. But, I would expect Copilot/Excel to understand basic financial calculations. Your table doesn't provide data needed to calculate profit. The total generated is Total Sales. And the profit margin is meaningless, because you can't get profit margin if you don't have both total sales and total profit.