Category: How-to

How to use conditional formatting formulas

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

How to Calculate Percentiles in Pivot Tables

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

How to create a pivot table from a pivot table

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

Connected Spreadsheets 101 - Working with Connected Tables

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

How to add chart slicers to filter charts

2025-08-05 // Mark Tressler

See how to filter charts with slicers and add slicers without pivot tables. Row Zero is a spreadsheet for big data that lets you add slicers to any chart.

Read more

How to open a parquet file online in a spreadsheet

2025-08-04 // Mark Tressler

Easily open parquet files online in a big spreadsheet. See how to open parquet files in Row Zero when you can't open a parquet file in Excel and Google Sheets.

Read more

How to open large CSV files too big for Excel

2025-08-02 // Nick End, Founder

Row Zero is a spreadsheet for big data that opens large CSV files online for free. Open big CSV files more than 1 million rows and any CSV too big for Excel.

Read more

How to replace SAP BO to Excel workflow in modern data stack

2025-07-21 // Mark Tressler

See how to replace SAP BusinessObjects to Excel workflow with Row Zero, a secure spreadsheet for big data that connects to your data warehouse.

Read more

Parquet File Format 101 + Opening Parquet Files

2025-07-11 // Mark Tressler

See how to open parquet files in a spreadsheet and explore the basics of the parquet file format. Compare parquet vs CSV and view parquet use cases.

Read more

How to build a waterfall chart

2025-07-07 // Mark Tressler

See how to create a dynamic waterfall chart in a big spreadsheet. Row Zero makes it easy to create auto-updating waterall charts connected to your data.

Read more