[harryh]

4. All the stuff he starts describing at 18:40 Google Sheets will actually do just fine except the Growth Trend bit on the heights.

5. 33:25 - Nope, that works in Google Sheets too. Just like Excel.

6. OK that table shit was cool though. Sheets can't do that.

[r00fus]

This video is a year old; Google sheets has notably improved in that time.

[harryh]

I'm fairly confident that points #4 and #5 both worked a year ago. I guess I can't be 100% sure, but I'm preeeeety sure.

[spydum]

tables is one of my most sorely missed features from excel. I'm really surprised it's still lacking in sheets

[viraptor]

It's missing everywhere. Sheets, libreoffice, office for Mac, anything... Ok, office for Mac does have tables, but I keep running into issues when referencing them - some values just end up as error until you change the source (even to the same value)

[shostack]

Google Sheets is still painful in many areas. Cell/chart/pivot formatting is a big one.then there are little things like the pivot table interface. Sheets has come a long way but when I need to be efficient and effective, I roll up my sleeves and dive into Excel.

[blahi]

I remember watching this video a while ago and it is super basic. I can assure you that there are great many things that google sheet lacks.

[harryh]

Ya I know. Was just pointing out that Google Sheets isn't quite as basic as people think.

It really should be better though. I wish Google would commit to it more.

[cm2187]

Does it have array formulas now?