The First Rule of Microsoft Excel: Don’t Tell Anyone You’re Good at It

Re:The First Rule of Microsoft Excel: Don’t Tell Anyone You’... by sin7 on Friday October 05, 2018 @05:04PM (#18151744)

I use PostgreSQL, which is a real database. I use DBeaver as the database manager. It allows me to enter data by typing it in. For reports, I query the data. It has autocomplete. No forms.

For presentation, I toss the data on Excel. Bold the headers. Change the number type (pct, $, etc) to the correct one.

I would say that it has made my life a lot easier. There is one repository where the data is held. If I mess up, I go back to the master tables. In Excel, I would usually start over. Joins are easy. Excel can do some things better. When it can, then I use it. It's not a one or the other. It's ok to use both.

[ Parent | on HN ]

Re:The First Rule of Microsoft Excel: Don’t Tell Anyone You’... by gerdesj on Friday October 05, 2018 @05:24PM (#18151854)

Me too but throw in MariaDB as well (I'm not exactly bi-lingual but can speak both with a dodgy accent and know some words better in one and some in the other.) I use Libre Office because Excel doesn't work very well on Arch Linux out of the box.

[ Parent | on HN ]