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

If you get the Download did not complete error message when using Power Query in Microsoft Excel, use these fixes.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

Not all sort tasks in Microsoft Excel begin with the characters to the left, but getting around that issue is easier than you think. Susan Harkins shows you how.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.