Google sheets are now officially better spreadsheet than Microsoft excel!

I was sitting with Pierre Loquett, coach of the Israeli women windsurfing team, also known as the madam sailing team to analyze data he obtained from the sailors during the last year. Since I knew I will probably have to debug what I do, I decided to try and do it using google spreadsheet instead of downloading the data and using Microsoft excel.

Being a Microsoft excel teacher, I thought I was going to have a hard time doing it, but I was in for a big surprise, some little things (and very big things) google sheets does makes life much easier than possible with excel!

Befor I start presenting what I saw, let me first say I am not a google fan (not anymore, at least) and like the average Joe, I am very much afraid of their control of human knowledge, but this is an awesome tool!

First a screencast showing what I did and the benefits google sheets present

Detailes:
Big things
The filter function: This function is one of many google sheets functions that do not exist in excel and probably cannot be implemented there. These functions are typed in one cell and changes the value of a range of cells.
For instance, you can create an SQL like query returning records in a specific date range from your bank report.

Little things
Graphs: Although graphs still have a long way to go and usually I will still recommend plotting in excel (Or other software if you really want high quality) in this case my graph data range was dynamic since its based on the filtered data. I don't know how this was implemented, but when the filtered range size was changed, the plotted range changed with it leaving no blank data on the graph.

Date selection: Mistakingly I double clicked on a cell containing a date value which set of a date picker for my surprise.

I guess that as much as I will keep working with sheets I will come across more little things  that will make me ask "How didn,t anyone do that before"

Bottom line is:

"Time to migrate"