Spreadsheets & Data
Excel, Google Sheets and SQL patterns for reports that have to be right the first time.
| Row | Problem | Tool | You get a |
|---|---|---|---|
| Calculate a Dashboard Completion Rate Without Averaging Percentages | SQL | Query | |
| Count Open Tasks by Owner with Google Sheets QUERY | Google Sheets | Formula | |
| Fill Missing Days with Zero in a SQL Task-Completion Report | SQL | Query | |
| Find Projects with No Tasks Using a SQL LEFT JOIN | SQL | Query | |
| Keep the Latest Status Row per Task with SQL ROW_NUMBER | SQL | Query | |
| Look Up a Project Owner by ID in Excel Without Approximate Matches | Excel | Formula | |
| Sum Only Visible Task Counts After Filtering in Excel | Excel | Formula | |
| Unpivot a Small Monthly Table in Google Sheets Without Add-ons | Google Sheets | Formula |