Model Structure

3 Ways to Safeguard Your Google Sheet

If you are building tools for use by an organization or online audience, you need to know how to 1) protect tabs; 2) auto-copy; and 3)...

2 Tips for Using IMPORTRANGE

IMPORTRANGE is what allows your Google Sheets files to talk to each other. Here are two tips to improve that talk.

How to Flatten Survey Data in Google Sheets

This sequence of steps lets you easily “flatten” a data set in Google Sheets, by organizing matrixed data into simple objects and fields

When Structuring Your Model, Think "ETL"

Use "ETL - Extract, Transform, Load" as a framework for structuring your next model or Sheets-based tool