Blog | Updates from the Subset team
Company![Avatar image for AJ Nandi](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2F73109f7f1c8126b6f9decad1a513e9f8c4d8cc09-4000x6000.jpg%3Frect%3D1586%2C3658%2C2342%2C2342%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
A new direction for Subset
We’re shifting our efforts to building a no-frills, desktop-based, local-first spreadsheet
![Avatar image for AJ Nandi](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2F73109f7f1c8126b6f9decad1a513e9f8c4d8cc09-4000x6000.jpg%3Frect%3D1586%2C3658%2C2342%2C2342%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
AJ Nandi
|
Commentary![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
How to use the OFFSET function
Bring your analysis to the next level with scenario analysis
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Jason Chan
|
Company![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
How to Format Cells in Excel (if only Mac had this feature...)
Speed up your spreadsheet formatting process
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Jason Chan
|
Commentary![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Shortcuts and Navigation for Excel on Mac
Understanding spreadsheet basics on a Mac
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Jason Chan
|
Commentary![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
5 Essential Tips for Designing an Effective Spreadsheet
Designing an effective spreadsheet doesn't have to be so hard
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Jason Chan
|
Commentary![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
What's the Difference Between XLOOKUP and VLOOKUP in Excel?
A new more powerful alternative has dropped
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Jason Chan
|
Commentary![Avatar image for AJ Nandi](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2F73109f7f1c8126b6f9decad1a513e9f8c4d8cc09-4000x6000.jpg%3Frect%3D1586%2C3658%2C2342%2C2342%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Are spreadsheets a true programming language?
The most widely used programming language
![Avatar image for AJ Nandi](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2F73109f7f1c8126b6f9decad1a513e9f8c4d8cc09-4000x6000.jpg%3Frect%3D1586%2C3658%2C2342%2C2342%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
AJ Nandi
|
Company![Avatar image for AJ Nandi](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2F73109f7f1c8126b6f9decad1a513e9f8c4d8cc09-4000x6000.jpg%3Frect%3D1586%2C3658%2C2342%2C2342%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Building abstractions on spreadsheets
A deep dive into the power of a flexible medium for analysis
![Avatar image for AJ Nandi](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2F73109f7f1c8126b6f9decad1a513e9f8c4d8cc09-4000x6000.jpg%3Frect%3D1586%2C3658%2C2342%2C2342%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
AJ Nandi
|
Commentary![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
How we realized we were overspending on software
Spreadsheets to help track software spend
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Jason Chan
|
Commentary![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Avoid hiding columns and rows in a spreadsheet
What seems like a helpful feature may actually hurt your spreadsheets
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Jason Chan
|
Commentary![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
How cell reference locking works
The difference between =A1, =$A$1, =A$1, and =$A1
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Jason Chan
|
Commentary![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Where are all the (online) spreadsheets?
Where is our central online repository of spreadsheets?
![Avatar image for Jason Chan](/_next/image?url=https%3A%2F%2Fcdn.sanity.io%2Fimages%2Fi8y8auwr%2Fproduction%2Fe12811aeb3a0f76cf5f8af55f716afd98aaa0b60-2084x1708.png%3Frect%3D188%2C0%2C1708%2C1708%26w%3D96%26h%3D96%26fit%3Dcrop%26auto%3Dformat%26dpr%3D2&w=256&q=75)
Jason Chan
|