The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types ...

We’ll also review how to import Microsoft Excel data into Google Sheets and vice versa. I’m using Google Sheets in Microsoft Edge and Microsoft Power BI on a Windows 10 64-bit system.

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.