Browse categories:
2026-02-11 // Mark Tressler
See how to do two-way lookups in a spreadsheet using MULTILOOKUP. Lookup values by row and columns based on multiple criteria for two-dimensional lookups.
Read more →2026-02-05 // Mark Tressler
See how to use rounding functions in a spreadsheet including ROUND, MROUND, CEILING.PRECISE, FLOOR.PRECISE, etc. and view examples of rounding functions.
Read more →2025-12-06 // Mark Tressler
Row Zero is a connected spreadsheet that automatically updates with the latest data. Connect to your data warehouse and build updating spreadsheets on big data.
Read more →2025-10-28 // Mark Tressler
See how to filter formulas in sync with source data. The ~ operator lets you SUBTOTAL any function to dynamicaly filter any formula.
Read more →2025-10-19 // Mark Tressler
Connected spreadsheets make it easy to write-back spreadsheet data to your data warehouse. See how to export spreadsheet data to a database or data warehouse.
Read more →2025-10-09 // Mark Tressler
Row Zero is a spreadsheet for big data that opens large BLS data files too big for Excel or Google Sheets. Open any U.S. Bureau of Labor Statistics dataset.
Read more →2025-10-03 // Mark Tressler
See how to apply conditional formatting based on another cell, use functions in conditional format formulas, and apply complex conditional formatting on big data.
Read more →2025-09-12 // Mark Tressler
See how to add percentiles to pivot tables in a spreadsheet. Calculate pivot table percentiles in Row Zero, a powerful alternative to Excel and Google Sheets.
Read more →2025-08-24 // Mark Tressler
See how to pivot a pivot table in your spreadsheet to analyze data at a deeper layer. Row Zero makes it easy to create pivot tables from pivot tables.
Read more →2025-08-07 // Mark Tressler
See how to create connected spreadsheets that auto-update with new data and view tips for working with connected tables in Row Zero.
Read more →