I always thought I was good at Excel. At work, I needed to make a formula that retrieves the last word. Can you do it without looking it up on Google?..
By the way, those who wrote Excel formulas really overcomplicated things. To begin with, they made formulas in native languages for many Excel language packs. Czechs, Germans, Russians, Finns, Hungarians, Poles, Turks, and many others must use their own set of formulas in their language. To figure out that RIGHT() is the same as ПРАВСИМВ() requires quite a bit of savvy. However, there is a translator (http://en.excel-translator.de/translator/)
Formula separators are used from the current locale of the operating system. So, on a Mac, I am used to separating parameters with a comma, while on Windows, it’s a semicolon. Of course, you can always adjust this, but why they even mess with the locale like this is unclear.
Moreover, there is an R1C1 reference style, which is often convenient, but it requires formulas to be entered differently. It is turned on/off from deep settings.
But so far, nobody has come up with anything better than Excel.
Hi, I'm Rauf Aliev. 