Welcome to the Subset Blog

Avoid hiding columns and rows in a spreadsheet

Hidden rows and columns add confusion

How to Build a GPA Calculator

Stay on top of GPA with a spreadsheet

Should you buy or lease a car based on math

How to build a spreadsheet calculator?

How to extract a word in Excel using a formula?

Splitting a text string at a specific character

Real Estate Monthly Payment Calculator

Free template to calculate how much your monthly home payments are

Real Estate Loan Calculator with Amortization (free template)

How to calculate total interest payment for a loan?

How we realized we were overspending on software

Quickbooks analysis to manage software spend

Why you should never merge cells in spreadsheets

Never merge cells in spreadsheets

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