LibreOffice is a free and open-source Office Suite from The Document Foundation, presented as the successor to OpenOffice.org. The suite includes Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector graphics and flowcharts), Base (databases), and Math (formula editing).
N/A
Microsoft Excel
Score 8.7 out of 10
N/A
Microsoft Excel is a spreadsheet application available as part of Microsoft 365 (Office 365), or standalone, in cloud-based and on-premise editions.
The fact that it is free of charge for desktop use sets LibreOffice at the top of my list. Given our low software budget, and its feature set which is for all intents and purposes equivalent to big name brands, it is more than appropriate for our needs. I have noticed in some situations that exporting a spreadsheet in a particular format on my machine and then sharing it with someone who is using say Microsoft Excel results in unexpected behavior (i.e., formatting issues or unreadable data).
I find it easier to use than Google Sheets , though it's easier to collaborate with other teams using Google Sheets. I also feel like Microsoft Excel is more suited to deal with complex formulas. The best way to put it, if I have a project that I'm solely working on, I'm going to use Microsoft Excel. If it's going to be shared, then I'm using Google Sheets.
It's free, which is the biggest difference between Office. It definitely feels like a full-fledged office suite of software for no more than the cost of an optional donation.
Lots of templates exist out on the internet for Writer and Impress (the Word and PowerPoint equivalents in LibreOffice). The open source community really likes to support one another in their usage of each other's software.
It works smoothly on almost every OS out there, including Windows, MacOS, and Linux.
Excel offers collaboration features that allow multiple users to work on the same spreadsheet, but managing changes made by different users can be challenging. Excel could improve its features by offering more granular control, better tracking of changes, and more robust conflict resolution tools.
Itcan be a barrier to productivity when importing and exporting data from other applications or file formats. To improve its features, it should offer better support for standard file formats and more robust error handling and reporting tools.
Excel can be challenging for finance students and working professionals, but it can be improved by offering more robust tutorials, better documentation, and more user communities and support forums.
We use it consistently and have a lot of documents in the OpenDocument format so it will be necessary to use LibreOffice or a compatible product such as Openoffice in the future to be able to open these files. Because the license fee for Libreoffice is zero it is not very costly to keep using it - the costs are mostly for keeping it installed on the office PCs and regularly updated, and solving employee issues with the user support.
Excel remains the industry standard for spreadsheets and has maintained simple and straight-forward formula writing methods. Although there is a learning curve to do more complex calculations, there are countless help sites and videos on the Internet for almost any need.
Most people can quickly start using Writer or Calc or Impress for basic tasks even if they see Libreoffice for the first time, because the interface is similar to older (97-2003) MS Office or other software. Some features are less intuitive than in recent MS Office and some power users of MS Office need to re-learn some things before being proficient in Libreoffice.
Overall I think the usuability is great and offers everything it should. I have never not be able to use it for what I wanted it for. However, it is so detailed and offers so much it can be difficult to use. Better descriptions or explanation to all the information could be helpful
Libreoffice is a desktop app not requiring any server part so it is always available when the PC is working normally. Installing it on another machine if one PC fails is very quick and easy. This is a non-issue.
For big/imported tables or text documents with images loaded from the internet it is sometimes getting very slow, RAM and CPU intensive, and sometimes even hangs due to some memory leaks or other bugs. This is a long-term problem and is still not resolved perfectly.
Support is not officially offered. However, you can find answers to any usage questions or trouble-shooting online easily, typically starting with a Google search. (I believe that all forums / tips for OpenOffice apply equally to LibreOffice, and vice versa.) While Microsoft Office, for example, officially includes support, I find that typically you end up going to a Google search in any case. So, this is not really a downside. However, in all these cases, you end up doing a lot of figuring things out for yourself.
Generally easy to perform, issues are how to ensure regular automatic updates on Mac OS X. Fortunatly we have only a few machines with OS X run by management and we can do these updates manually occasionally. Windows updates are quite easy with the support of third party software such as Ninite or Chocolatey, and Linux updates are super-easy thanks to the package manager (apt-get).
I have used MS Office, Google Docs as other comparable products. I like MS Office best of all. I like LibreOffice better than Google Docs; however, I believe that if Google Docs wasn't so limited in many of its features and web-based only, I think it has the potential to surpass LibreOffice if they don't fix the problems between full functionalities.
Excel is one of the tools I use for everyday work but fits alongside all the other programs I use. I keep Excel as a way of tracking projects from start to finish as well as document content strategy and audits. There are not many programs like Excel that I can think of other than Google Sheets and I find Excel is far better.
With more users using it in the company there are more cases when a simultaneous editing of the same document is needed and this feature is lacking in Libreoffice even though the files concerned are shared and synced by some solution (we use ownCloud). Google Docs or MS Office365 via Sharepoint/Onedrive offer a better function for this.
Each user can use it to whatever level of expertise they have. It remains the same so users can contribute to another's work regardless of whether they have more or less expertise
Being a free GNU-based software, it is ideal for computers used outside the company's network or for users which do not require online collaboration tools.
Importing and exporting word processing documents is easy. PDF functionality is adequate and works very well.
You will probably need to invest in fonts if, for example, most of your company is using Microsoft Word fonts, which may be proprietary. In our case, we paid for a few key fonts; installation in the system was simple but done through IT, not the user.
For complex graphs and presentations, LibreOffice may not be the best alternative.
It helps to me gather my thoughts, organize my research, and most importantly prioritize information in an easy to digest manner depending on what I am most interested to see at that time.
It helps me quite a bit to talk my clients through the financial implications of various office leasing transactions under consideration and coach them in a way that is very unbiased and fact-driven which I like.
It helps me to be more thoughtful as well when thinking about the various different situations in which I use Excel. And because it ultimately results in my clients getting comfortable ultimately pulling the trigger on a given deal, it directly leads to more commission in my pocket which I love!
