About Spreadsheet Tutorials

Spreadsheet-Tutorials.com is a reference and learning website for people who want to understand spreadsheet formulas rather than copy a mysterious expression and hope it works.

Our function guides cover LibreOffice Calc, Apache OpenOffice Calc, and Gnumeric. Each program has its own function set, argument conventions, version history and capabilities. The site organizes the material by software so you can start from the application you actually use.

Choose your starting point

• LibreOffice Calc: Common calculations, conditional functions, date formulas, lookups, statistics, text handling and newer array functions.
• Apache OpenOffice Calc: Calc formulas, everyday numeric and text functions, and compatibility considerations.
• Gnumeric: Everyday spreadsheet functions alongside specialized mathematical and statistical functions.

How the tutorials are organized

A guide aims to provide function syntax, an example you can reproduce, the expected result, and an explanation of why it works. The software versions tested and the limits of verification matter as much as the formula itself. Some material is still being researched and does not appear as a published tutorial.

If you’re comparing spreadsheet applications or troubleshooting a formula copied from somewhere else, check the guide for your specific software before changing your data.

Read our formula testing and editorial standards for more detail, or use the site search to find an individual function by name.