Microsoft Excel

Vorteile

I liked Excel for the longest time since there are a lot of useful tools available for use but I loved it better with the smooth transition after the updates. I'm using the 2019 version and the transitioning became smoother. Working online is also available and I am no longer afraid to lose any document I worked on. The ability to import the excel document to other formats especially PDF is a life-saver!

Nachteile

There's nothing much I hate about Excel since it helps me with all the reports I do. I'm just a little bothered with the CSV import after some updates were done. I noticed in the 2019 version, whenever you import a Data from text/CSV, it automatically goes to a new tab and the design has Header Rows, Banded Rows, and Filter Button. For me, it's more time consuming to remove those every time I import a CSV.

Vorteile

This software is a company standard use for a lot of other programs. It can filter data, create .csv files for upload and download of data, and handles equations to help with data analytics. There are a lot of guides on this program online if you are struggling with a problem and there are plugins that you can use to help make your job faster. Many companies have this as a standard so sending files to others is usually not a problem.

Nachteile

It is not meant to be used as a database for large data. It can lag out after you get to 60K lines of data. The biggest issue I have with this program is that it likes to convert large number text to scientific notation and you have to constantly do workarounds to prevent it from happening. It has some minor glitches if you have too many different files open at the same time. It is not the greatest with group collaboration because the files are meant to be used as one user at a time. You have to also manually save your files from time to time as you are working. Although you can often times get your file back if it wasn't saved and the program shuts off, it still is a practice you have to get into a habit of doing.

Vorteile

I love the versatility, look and ergonomics of Excel. The wide formulas and small assistance tools, which make it unnecessary to do certain things manually. Example, if you copy / paste / move formulas and references, it almost always manages to adjust and correct.

Nachteile

In years of excel the most terrible thing that ever and continues to have is poor support for CSV files. In LibreOffice, for example, when opening a CSV, it tries to detect the conventions and display for you to confirm. Excel has a persistent bug with this, and it almost never manages to open CSV correctly (regardless of whether you use a semicolon, comma or other), the best way to use this is to open CSV in LibreOffice, copy and paste in Excel , which is very annoying. At the office level, it is also bad to be forced to install all the applications in the package, even if you only want excel and a few others.

Vorteile

The pros are thin on this software. I'll list them by number.

1. The software is over 20 years old and has been refined and recreated numerous times over that period.
2. It makes creating lists very easy when copying and pasting information from tables on web forms. It intuitively pastes tables by column and row quite accurately 99% of the time and enables you to take one column as a list and paste it anywhere else. This utility reduces the tedium of quickly conveying information to co-workers considerably.
3. The ability to import data by comma or tab delimited text files is also exceedingly powerful in reducing time spent listing or reporting on specific items in a format that is not conducive to pasting into a table, or perhaps powershell script derived data outputted to a comma delimited text file. As a computer engineer, this takes hours and hours of time and compresses it into minutes.
4. The formulas, while available on Google or other spreadsheets, are also good pros and help with calculating anything you need to do in terms of math from other columns, in my case and in short, capacity and utilization percentages of storage devices on hand.

Nachteile

What I like least are the frustrating things, and while few, these really irk me and stand out as a problem, especially in creating reports for people using the formulas, math and functions that spreadsheets are best known for. Case in point: The ability to copy and paste just the function into another spreadsheet that is open. It simply does not work unless you tab out of the existing cell and this is because, annoyingly, separate files, completely separate Excel spreadsheets, all act as if they're part of the same file. If I have one spreadsheet xlsx file open and a separate one open where I'm copying and pasting pertinent data from one to the other, it acts as if I'm in the same spreadsheet and the behavior is inexplicably wonky and unusable. I just want to copy the formula plain text as is into the cell of another spreadsheet because I want to use that same math for data related to other irrelevant items. Google Sheets does not do this at all. Maybe this was something Accountants wanted for some crazy reason that I'll never encounter as an engineer. But this is obnoxious and makes me scream at the computer often.

The other con is that I do not like the non-intuitive UI and clunky way to simply save files. It pushes One Drive, and pushes it hard like non stop telemarketing calls. Also, I just prefer the old way to save files. Call me old fashioned but it was simple. I don't need the whole screen to change when cling the file tab.

Vorteile

There is nothing to dislike about Excel - it is the standard for data creation and manipulation. The best features are its easy functionalities via simply clicking on icons in the header (ribbon display) and efficiently creating equations in the cells/rows. Copy/paste, insert columns and automatic population of rows with either mathematical formulas or counts is so helpful and efficient.

Nachteile

Sometimes the Search function doesn't return the best results. I'd also like to see a function where right-clicking on the workbook name (located at the top of the display header while the workbook is open) enables copying the filename with its file path so as to send a link to someone wither in an email or other method.