Welcome to the Subset Blog

How to split a bill using a spreadsheet?

Step by step instructions on how to build a bill splitter in a spreadsheet

How to do an Index Match formula?

Index match formulas fully explained

The Problem with Loan Calculator Apps

CRUD App vs Spreadsheets when it comes to loan calculator apps

Spreadsheet Fundamentals

Lessons for spreadsheet beginners

Coinbase Cost Basis Excel Template

Coinbase Cost basis analysis in Excel

Time Series

How to work with time series in a spreadsheet

How cell reference locking works

What are the dollar signs you see in Excel formulas?

Where are all the (online) spreadsheets?

Show me the spreadsheets! How you can find spreadsheet templates online.

Excel 2.0

The spreadsheet of the future

How to use the OFFSET function

Level up your modeling skills by using the OFFSET function in your spreadsheets