Re: functionality
In these cases, the university should provide the necessary software. I've just completed a degree and an Office 365 account was provided by the university for the duration of the course, as was access to the other required specialist software (in my case, the Esri GIS stuff), plus the Adobe suite (Photoshop etc). I've never heard of a case of a university requiring students to go out and purchase essential software needed to complete their course.