Likelihood to Recommend In my opinion, Apache OpenOffice is best suited for writing, editing and proofreading texts in any language. You can also download additional language packages that really take up little space in your PC's storage. Of course, Apache OpenOffice is comprehensive of spreadsheet-/drawing-/database-related softwares and so on, but I primarily use it for writing and editing my own texts. I don't see any scenarios where it is less appropriate, at least so far.
Read full review For tasks like financial analysis, budgeting, forecasting, and data visualization, I frequently use Microsoft Excel. I can develop financial models, use pivot tables to examine enormous datasets, and produce eye-catching visualizations thanks to its comprehensive features. I have, however, also come across circumstances in which Excel isn't the best tool.Excel falls short of alternatives like
Google Sheets when I need to collaborate with my team in real-time. I favor employing robust database management systems or data analysis tools like SQL, Python, or R for managing very big data sets or sophisticated calculations. I use specialized tools like SPSS, SAS, or programming languages for better outcomes when complex statistical analysis or machine learning are necessary. And finally, for formatting elaborate reports, In conclusion, even though I consider Excel to be a great tool for many finance jobs, there are some limits in collaborating, processing big amounts of data, performing complex analysis, and creating documents that I take into account when choosing the best tool for the job.
Read full review Pros The number one strength of OpenOffice is the flexibility it gives. We can open any file type, save any file type - it's pretty much invincible. Even if we're going to work on this in a different program, just being able to open some of these ancient files that we get from local city governments is a huge win for us. It's also administrator friendly - I'll use it a lot on the road because the licensing is so much easier to deal with than trying to check out a license from a server or make sure that everybody has internet connectivity. It just looks pretty! It's legitimately a quality product, the layout looks good, it's not nearly as pushy as "other suites," and for the money it's the best! Read full review It is very good at embedded formulas and tying cells to one another It allows me to compare deals terms on a side-by-side basis and talk my clients through it easily. It is very helpful as well in terms of allowing me to filter/sort results in many different ways depending on what specific information I am most interested in prioritizing. Gary Ceder Managing Director - Transaction Advisory
Read full review Cons There seem to be issues using this app in Windows 10. It worked fine when we used it on Windows 7, but after we upgraded the network with NEW Win 10 computers, it takes a very long time to process commands. It will not allow any upgrades. Read full review Counting conditionally formatted cells (e.g., you have 5 green cells, 10 red ones, and 3 orange ones in a row). Merging cells in a table; I have to remove the table first and then re-add the table to merge cells together. Offering more preset colour categories for formatting graphs. Built-in functions to run ANOVAs, Multiple Linear Regression, Factor Analysis, etc. Read full review Likelihood to Renew It is a cheap alternative; however, with
Microsoft 365 licenses also dropping significantly, we might opt to go in that direction to maintain uniformity.
Read full review It comes with MS Office. Unless we stop using PCs or Microsoft Office, it's highly unlikely, even imperceivable to not continue to use Excel. It would be nice to see more Excel functions used, though, beside basic tables and calculations.
Read full review Usability It is so easy to use and produces quality work comparable to its paid competitor, Microsoft Office. I highly recommend this free software to any who need to make the switch to powerful and free Office software.
Read full review Microsoft excel stands out in its User Interface as compared to any other software which offers same functionality. It can be used by a beginner as well as the expert in the same field. It is having many features as we dig deep in it like advance functions, dynamic arrays, pivot, VBA and Macros.
Read full review Reliability and Availability I have rarely, if ever, had issues with its availability.
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Performance Again it does what I need it to do with little to no issues.
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Support Rating Is there really support? There is a user forum but I do not see much developer input. Support options are limited. The most recent (Sept 2019) version of the product seems to have issues operating under Windows 10, yet there are few recent comments in the community forum, most comments are regarding older versions.
Read full review I have not had to use it often, but it is good.
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Implementation Rating We found that it is possible to use Open Office to accomplish everything we need. Some tasks required searching for steps on Google.
Read full review Alternatives Considered Apache OpenOffice is less intense on our computer systems and saves us a ton of financial resources. Since our document creation and editing needs are typical of a small business and not very complex, Apache OpenOffice is sufficient for us. We think that almost any smaller to medium sized business would feel the same way if they don't have a need to make or edit complex documents.
Read full review We utilize
Tableau and
Alteryx in addition to Excel. We use Excel since we have a data dump that could be utilized in feeding for these two solutions. We select Excel for some manual work then plug the data into the other two tools for further analysis around text analytics like word clouds in
Tableau , or text mining in
Alteryx . Excel is an input data source that we use in conjunction with these two.
Read full review Contract Terms and Pricing Model N/A I was not involved in this process.
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Scalability It integrates well with all cross functional teams
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Return on Investment Moving to OpenOffice will save the company the cost of 500+ of Microsoft Office licenses in our company. Because it is cross-platform, we could also save 500+ of Microsoft Windows licenses if we move everyone to Linux. On the negative side, the lack of online collaboration and browser support may be an issue when you use clouds like Box, Workboard etc. Read full review Excel has positively impacted the business as it has increased our efficiency. It also saves us the time that we would have spent on making the calculations that it does for us. Since it works on all devices and is compatible with both Windows and Mac, we do not have to invest in any other alternative. Read full review ScreenShots