People working on laptops

Welcome to the Subset Blog

Thoughts, ideas, deep dives and more

Jason Chan | October 5, 2022

Avoid hiding columns and rows in a spreadsheet

Hidden rows and columns add confusion

Jason Chan | September 27, 2022

How to Build a GPA Calculator

Stay on top of GPA with a spreadsheet

Jason Chan | September 14, 2022

Should you buy or lease a car based on math

How to build a spreadsheet calculator?

Jason Chan | September 10, 2022

How to extract a word in Excel using a formula?

Splitting a text string at a specific character

Jason Chan | September 7, 2022

Real Estate Monthly Payment Calculator

Free template to calculate how much your monthly home payments are

Jason Chan | September 1, 2022

Real Estate Loan Calculator with Amortization (free template)

How to calculate total interest payment for a loan?

Jason Chan | August 23, 2022

How we realized we were overspending on software

Quickbooks analysis to manage software spend

Jason Chan | August 22, 2022

Why you should never merge cells in spreadsheets

Never merge cells in spreadsheets

Jason Chan | August 10, 2022

How to split a bill using a spreadsheet?

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

Jason Chan | August 10, 2022

How to do an Index Match formula?

Index match formulas fully explained

Jason Chan | May 17, 2022

The Problem with Loan Calculator Apps

CRUD App vs Spreadsheets when it comes to loan calculator apps

Jason Chan | April 6, 2022

Spreadsheet Fundamentals

Lessons for spreadsheet beginners

Jason Chan | March 29, 2022

Coinbase Cost Basis Excel Template

Coinbase Cost basis analysis in Excel

Jason Chan | March 13, 2022

Time Series

How to work with time series in a spreadsheet

Jason Chan | March 1, 2022

How cell reference locking works

What are the dollar signs you see in Excel formulas?

Jason Chan | March 1, 2022

Where are all the (online) spreadsheets?

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

AJ Nandi | February 28, 2022

Excel 2.0

The spreadsheet of the future

Jason Chan | February 28, 2022

How to use the OFFSET function

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

We’re building a better spreadsheet
Get your spot on the waitlist

Sign up for email updates