Blog | Updates from the Subset team
The First Real Estate Analysis You Should Run
Figuring out if a real estate deal is worth it or not is the first step in investing. Here's a simple model for analyzing real estate investments.
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
OpenAI Pricing Calculator
Free calculator to compare pricing between different LLMs based on prompt size
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Are spreadsheets a true programming language?
Are spreadsheets a programming language if they often need low code solutions to fill the gap between it and software? If spreadsheets are considered a programming language, then it’s the most unique one of them all.
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
How to use spreadsheets for budgeting and financial planning
A walkthrough of how to create an easy budget
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
5 Spreadsheets Students Need to Succeed
The most important metrics for students
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Building abstractions on spreadsheets
The cost of flexibility and potential solutions
![Avatar image for AJ Nandi](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2Fbfea72c8294f19e4a9cae4ef5f4671918a3951f3-257x257.jpg%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
The Only Spreadsheet to Evaluate a Real Estate Investment
Cap Rate and Cash on Cash Yield
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Real Estate Cost Basis Spreadsheet
Keep track of your home improvements in a spreadsheet
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
How to use the OFFSET function
Level up your modeling skills by using the OFFSET function in your spreadsheets
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Avoid hiding columns and rows in a spreadsheet
Hidden rows and columns add confusion
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
How to extract a word in Excel using a formula?
Splitting a text string at a specific character
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Spreadsheet Fundamentals 5: Number Formatting Shortcuts
Number formats for 90% of your work
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Real Estate Monthly Payment Calculator
Free template to calculate how much your monthly home payments are
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Real Estate Loan Calculator with Amortization (free template)
How to calculate total interest payment for a loan
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
How we realized we were overspending on software
Quickbooks analysis to manage software spend
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Why you should never merge cells in spreadsheets
Never merge cells in spreadsheets
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
How to split a bill using a spreadsheet
Step by step instructions on how to build a bill splitter in a spreadsheet
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Spreadsheet Fundamentals 4: Writing Formulas
Writing more advanced spreadsheet formulas
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
The Problem With Most Apps
CRUD App vs Spreadsheets when it comes to loan calculator apps
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Spreadsheet Fundamentals 3: Formatting
Formatting a Spreadsheet 100x Faster with formatting skills
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Spreadsheet Fundamentals 2: Auditing Cells
Auditing and Editing Cells with shortcuts in a Spreadsheet
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Spreadsheet Fundamentals 1:
Universal shortcuts, navigation shortcuts, and accelerator keys in Excel
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Where are all the (online) spreadsheets?
Show me the spreadsheets! How you can find spreadsheet templates online
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2F5t7ll6za%2Fproduction%2F73970727a0e3ef50d872423bbbda7aa081eeda89-256x256.png%3Fw%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)