Hello,



I am an intermediate user of Google Sheets trying to get a basic understanding of how Excel is different.

Every time I try to do a function in Excel it seems to not like what I write. There is plenty of posting out there about which is better. I am not interested in what is better rather what are the fundamental differences in formula syntax etc, that I need to know in order to use excel.

Examples. In google sheets i use the FILTER function regularly. In excel i can get it to filter data on the same sheet or tab but once I move to a different tab i cannot seem to figure out how excel wants the other sheet/tab referenced in the formula?

I have tried multiple times to get to know excel and every time end up feeling frustrated. If someone out there with a lot knowledge of both platforms could provide a video detailing the fundamental differences it would make a world of difference to those of us who are interested in learning and using excel more.