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.

Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia. Marguerita is a Certified Financial Planner (CFP), Chartered Retirement Planning Counselor ...