A:AnswerYes. There are a number of ways to do this, but the free Power BI add-on in Excel could do it on a spreadsheet for you. You can even automate it to update while you're looking at it or as you open the file.
A:AnswerMicrosoft Office 2021 Home & Home Office are both compatible with Big Sur. It can be purchased outright for use on one machine and Microsoft guarantees support (not necessarily updates) foir the latest three MacOS versions.
Microsoft Office 365 also works on Big Sur as it is a subscription service charged monthly or annually and allows installation on up to 5 machines.