Category: How-to

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 and edit parquet files online for free in a big spreadsheet. See how to open parquet files up to 1 billion rows.

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

How to automatically remove duplicates in connected spreadsheets

2025-07-01 // Mark Tressler

See how to automatically remove duplicates in spreadsheets. You can delete duplicates from massive files or automate removing duplicates as new data updates.

Read more

10 Tips for Cleaning Big Data in Spreadsheets

2025-06-25 // Mark Tressler

Row Zero makes it easy to clean big data in spreadsheets. Connect to your data source to clean database tables, preprocess data, and automate big data cleaning

Read more

Best Keyboard Shortcuts for Spreadsheet Power Users

2025-05-20 // Mark Tressler

Top 10 spreadsheet keyboard shortcuts and advanced hot keys for power users including Alt shortcuts on Windows and Mac Opt key shortcuts in Excel and Row Zero.

Read more