> Perhaps instead of filtering, you'd like to see outliers or the range of values? Though I'm not super happy with the way Excel does that, surely some room for improvement. I've also used lookups, ie find the row matching this and extract the value from the given column in that row. Also string formatting of numbers and dates (for concatenating with text). I mostly use SUM, COUNT and IF (if-then), along with functions to check if a string value is a valid number. > What are the other most common formulae that you use? > Formulae are supported, but the cell (not column) must be set as the Formulae datatypeĪs long as it's not tedious to set a few thousand that sounds great. tons of other GUI features like formulas, spell check, etc Excel has user specified row ordering as default out-of-the-box behavior. That type of behavior is not easy in generic database viewers because most tables - by typical design of RDBMS table row ids - do not consider the visible spatial ordering of rows the way the end user wants to see them on the screen unless one adds an extra column to the table such as "gui_view_order_id". cut rows 37 to 52 and paste them above row 5. hide rows or collapse rows into outlines pivot the data via drag & drop UI (instead of manually writing a SQL cross-tab query) formatting any arbitrary row or column with bold/italics and change the font color or background cell color. They are often missing features that are taken for granted by Excel users: Millions are already familiar with the GUI of Excel.Ģ) The datagrid viewers in those tools are not powerful and feature-rich like Excel. >What'd be wrong with using something like DBeaver, SqliteStudio, or PG-Admin? Or buying a tool like DataGrip? Microsoft Accessġ) Those utilities are not typically included in the workstation image of laptops/desktops unlike MS Excel which is already part of Office 365.
0 Comments
Leave a Reply. |