SheetsBat guides and articles
Practical guides for SheetsBat: spreadsheets with every formula, step by step.
How to co-edit a spreadsheet in real time, for free
Share a spreadsheet, edit it together live, see who is where, comment on cells and roll back mistakes. A step by step guide on the free SheetsBat plan.
Read the guide
Make a loan amortization schedule with the PMT function
Build a month by month loan schedule with PMT, IPMT and PPMT, then see how extra payments change your payoff date and interest. Free template included.
How to make a pivot table, step by step
Turn a long list of sales into a clear summary by region and quarter. A beginner friendly pivot table walkthrough with grouping, totals and percentages.
XLOOKUP vs VLOOKUP, explained with real examples
XLOOKUP vs VLOOKUP side by side on one sales sheet: exact matches, looking left, missing values and the latest match, with formulas you can copy.