Thanks for the response. I guess you are right, the combination of non-native apps (MS Teams mainly) and using an external monitor (at default resolution) seems to have such a massive RAM hit that I don't think this machine is for me. Its a shame really as I'm a research student and we communicate via face time and iMessage so I had been balancing an iPad and a windows machine and was hoping to have one machine to do it all. It also appears to suggest that most students that are using office etc are going to run into the same issue. I am surprised that no one is mentioning this and al the focus is on benchmarks and video editing etc - all I want to do is have Word and safari with more than a few tabs, and then the usual stuff like mail, calendar etc. Guess I'll have to wait for some optimisation or a few more months until I can afford a 16gb machine.
Try the beta of Office for M1 native. And note this:
"According to Erik Schwiebert, Principal Software Engineer for Apple products in the Office Experiences group at Microsoft, Office is already available for M1 MacBook laptops and M1 Mac mini via the beta channel. The public release date has not been set, but beta is usually the last stage of testing before updates become available to the public. Schwiebert adds that Visual Basic is fully functional in the beta and compiles to native M1 code. Visual Basic is used for the most powerful macros in Microsoft Office, so this is an important milestone. Microsoft Teams is not yet working but is in progress."