If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.

If your Excel spreadsheet always opens in a small window and not a maximized one, follow these steps to resolve the issue.

The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types are select, where, group by, pivot, order by, limit, offset, label, format, ...

For years, one of the key areas where Google Sheets has lagged behind Microsoft Excel has been its native table functionality ...