About

sheets.org is a practical guide to getting more out of spreadsheets — Google Sheets and Microsoft Excel alike.

Spreadsheets are the most widely used programming environment on the planet, and most of us were never actually taught how to use them. This site exists to close that gap with clear, practical tutorials: no fluff, real examples, and formulas you can copy straight into your own sheets.

What you’ll find here

• Google Sheets — from everyday features to the functions that make Sheets unique, like QUERY and ARRAYFORMULA.
• Excel — shortcuts, pivot tables, Power Query, and the modern function library.
• Formulas & Functions — deep dives into the lookup, logic, and aggregation functions that work in both tools.
• Macros & Automation — when clicking is no longer enough: Google Apps Script, Excel VBA, and scheduled automations that do the work for you.

Where to start

New to lookups? Start with the XLOOKUP vs VLOOKUP vs INDEX/MATCH comparison. Drowning in repetitive work? The first Apps Script macro guide will change how you think about spreadsheets.

Questions or topic requests? Head over to the contact page — reader questions regularly become future tutorials.