I have missed this programming like feature a couple times when doing analysis stuff using Excel and ended up being forced to use SPSS just because of this.

We now have a LET function that allows you to assign names to calculations results.

Excel/heavy spreadsheet users like me will be pleased to know that a couple of new fuctions have been added:.

Some performance tweaks which are supposed to make it faster than earlier versions of Office.

Most of these are meant to make the Office suite look more at home in Windows 11 which as already pointed out is also coming out tomorrow. UI tweaks and other changesĪs expected the new version of Office comes with new UI changes and tweaks. You can save your files in this format instead of Microsoft’s own proprietary format instead when you want to share documents with others who use these office suites instead of Ms Office.

That is the latest version of ODF that is supported by WPS, Google Docs, LibreOffice and OpenOffice. Thankfully with Office 2021, you can now save documents in Open Document Format (ODF) 1.3. That is hardly ideal given how popular and widespread Windows is.Ī workaround has always been to use either Google Workspace or Microsoft 365 when you intend to collaborate although in a country like ours where data is expensive that might not be an option. A perfectly formatted document on LibreOffice could show up as a jumbled mess when emailed to someone on Office.

One pain point of using free Office software packages like LibreOffice and OpenOffice is that sometimes you hit unexpected issues when you share the document with Ms Office users. Office 2021 is coming out tomorrow and if you are a free software person like me you will love it as it comes with LibreOffice compatibility. They are also releasing the latest version of their popular Office suite. Everyone has been raving about Windows 11 and how it’s a game-changer but tomorrow is a special day at Redmont, not only is Microsoft releasing its latest version of Windows.

Libreoffice for windows 11