Learn how to use Google Sheets Query() formula to pull rows of data that match your criteria from multiple sheets (when the data in all sheets has the same format).

In this session, you will

1. Write a basic Query formula
2. Write a Query formula that queries multiple sheets/tabs
3. Recognize data requirements when querying multiple tabs
4. Specify which columns to return
5. Specify criteria for which rows to return

Resources

Slides/Docs