Save time with data tables

Quickly organize your data into tables for faster updating, while keeping references, totals and formats updated automatically.

How to fix circular references

About circular reference errors, circular reference warnings, how to find and correct them... and when to embrace circular references!

Save time with subtotal formulas

Subtotals save time, reduce errors and provide confidence. Learn how to use subtotal formulas to speed up your spreadsheets and cut down editing time. Know your way around subtotals already? Check out this tip to see if you're getting the most out of them.