Every few months, someone discovers the Google Sheets QUERY function and has the same reaction: why did nobody tell me about this? Here is what it does and why it changes how you work with data.

Filters and slicers help you highlight key data in a spreadsheet by hiding less relevant data. Here’s how to make them work for you in Google Sheets. If you’re building a large spreadsheet in Google ...