The help for Google Spreadsheet functions is excellent.

02.IT relatedgoogle

The recent, I think it was months ago, upgrade has had a big impact. I don’t need Excel in my personal life anymore. That means I don’t need Windows at home.

Excelで使える関数はだいたい網羅できてそうなのは以前からでしたが、なんといっても関数のヘルプが素晴らしく進化しましたよね!

A simple help screen appears to the extent that it does not interfere during input.

もっと調べたいとき、下の“Learn more about LINEST”を押すとこのような画面に。

It’s very convenient to have an example. Moreover, it is easy to see.

Excelなんかより全然いいじゃん!(Excelのヘルプはほんとわからづらい)

By the way, if you want to do something a little more elaborate, Google Apps Script is enough to do what Excel calls macros and VBA.

However, it is difficult to handle a large amount of data. It becomes heavy, right? I wonder if the only way to improve this is to upgrade Google Apps to the business version.

If you want to use large amount of data, you can use Google Cloud SQL. Well, there’s not much to do here for private use (laughs).

タイトルとURLをコピーしました