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

Discover two powerful Excel formula methods to unpivot data. Transform cross-tab layouts into analysis-ready formats without Power Query.

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

Learn how to use the secret hidden Excel FILES function in your Microsoft spreadsheets to easily retrieve file names and metadata ...

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.

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.

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