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

Microsoft has announced a beta version of Excel that allows pivot tables to automatically update themselves when data is changed.