Spreadsheet

latest

Excel spreadsheet on a HP EliteBook.
6 Excel keyboard shortcuts I use every day that most people have never tried

You may be good at Excel, but you’re spending way too much time clicking around.

1
Data Bars in Excel
Your spreadsheets shouldn't look like a rainbow — use conditional formatting properly

If you need a legend longer than your data, you’ve gone too far.

1
Using xleak on Windows
This terminal tool is my favorite way to view spreadsheets on my computer

Inspect spreadsheets natively inside your CLI workflow.

Excel sheet with a cell in focus.
7 small Excel habits that make spreadsheets feel effortless

Stop creating Excel sheets that fight you!

2
A picture of a personal finance dashboard for 2026
I built a personal finance dashboard in Google Sheets that beats any app

Google Sheets is the best way to track personal finances.

2
A picture of the MAP function in Excel
5 real world examples where Excel's MAP function shines

Let's see how the MAP function works.

Cleaning up data in Excel using the TEXTAFTER function
5 Excel functions that make data cleanup feel unfairly easy

It's all about manipulating the text.

1
The Automate tab in Excel
This is the most useful tab in Excel and most people never click it

This tab will significantly speed up your workflows.

3
The Get Data button in Excel
I stopped copy-pasting data in Excel after I found this "Unpivot" button

Unpivoting data is so easy!

9
The Fill menu in Excel
You're wasting time in Excel if you aren’t using Flash Fill

Take advantage of Excel's ability to notice patterns!

1
File options in Excel
5 ways Excel tries to ruin my day (and how I fix them quickly)

Make Excel work for you!

A laptop with Excel open, a clock on the left, and the Excel logo on the right.
My formulas calculate faster than ever thanks to this unassuming Excel toggle

Don't let lengthy calculations slow you down!

A picture of the HYPERLINK function being used in Excel
This underrated Excel function does more for navigation than any shortcut you know

This could be the key to making your Excel sheets more useable.

The SUMPRODUCT function in Excel.
Excel's REDUCE is clever, but this old-school function is what I trust

Not every problem needs Excel’s newest trick.

1
Excel logo surronded by a swirl of Excel functions
The strangest Excel functions you'll never use

These formulas belong in a museum.

6
Laptop showing a functional Kanban board in Microsoft Excel
These Excel spill formulas make dynamic dashboards ridiculously easy

One formula, endless automation.

Picture of an Excel sheet with the Excel logo in the middle
Excel’s new group of functions will break your brain in a good way

Once you grasp these, spreadsheets feel alive.

2
A picture of an Excel with the Excel logo and screenshot of an formula in the middle
You’re not using Excel right until you master these error functions

These functions will make your Excel sheets resilient.

Excel Logo on a Laptop
I stopped consolidating sheets by hand because Excel’s INDIRECT function does all the work for me

Consolidating sheets has never been easier!

3
Excel spreadsheet on a Windows laptop.
They don't teach these mean Excel functions in school but they're super handy

These should really be part of the curriculum!

1
See More