latest
I connected Excel to a folder on my PC, and my weekly report now updates itself
A simple setup lets Excel combine recurring reports and refresh the results whenever new files arrive.
Your Excel file is secretly sharing more than you think. Here's how to check
Excel's Document Inspector reveals hidden and personal content, while a few manual checks can catch what it misses.
Excel tables do way more than format your data—7 things I actually use them for
Excel tables let you create consistent formulas, build smarter filters, create expanding drop-downs, and keep charts and totals up to date.
Stop clicking every cell to check formulas: This Excel shortcut shows them all instantly
Make editing formulas quick, accurate, and easy.
Someone else's Excel spreadsheet, my problem now—these 5 tools help me handle it
From missing entries to bloated formulas, these five Excel tools help me turn someone else's messy data into something usable.
I turned a boring task list into a mini Excel app in 10 minutes
Checkboxes, a few formulas, and a little formatting transform an ordinary task list into a useful, dynamic tool.
I stopped overrelying on Excel's filter buttons after learning how to build live lists
With the FILTER function, adding or changing criteria instantly updates my results, while the original data stays intact.
I stopped Googling unit conversions—Excel's CONVERT function does the work for me
From miles and inches to Fahrenheit and metric prefixes, CONVERT handles a surprisingly broad range of everyday conversions in one place.
These Windows apps required an online account, so I switched to offline versions that respect my privacy
Account fatigue drives a switch to offline apps for simpler local workflows and less data sharing.
I fixed my messy Excel dataset with a single formula
Reshaping wide data makes it easier to use familiar Excel tools like PivotTables and charts.
6 everyday Excel tricks I discovered too late (but learned in seconds)
From duplicating worksheets to selecting cells, these simple tricks made me realize I'd been doing things the hard way.
Excel Easter eggs ended 24 years ago—but this open-source Space Invaders project keeps the fun alive
The old Excel Easter-egg era may be gone, but this open-source project brings the arcade spirit back to our spreadsheets.
5 common Excel annoyances you can fix in 5 minutes this weekend (September 18-20)
Give yourself a cleaner start to next week by fixing five Excel frustrations you've probably learned to accept.
7 Excel functions you probably didn't know existed (and why they're surprisingly useful)
From step goals to savings trackers, these seven Excel functions solve everyday problems in unexpected ways.
I turned my giant Excel formula into something I can actually understand
My formula still does exactly the same job, but the LET function makes its logic clear.
I use Excel all day, every day—the simple Ctrl+Shift+V shortcut saves me the most time
This tiny shortcut lets me paste exactly what I need, avoid unnecessary cleanup, and keep my Excel workflow moving.
I made 5 games and tools in Excel that have nothing to do with crunching numbers
Excel's familiar grid can become almost anything when you add a little creativity.
I stopped using Word for simple notes after discovering this ridiculously capable text editor
Word was built for printing, not note-taking — Notion does that better.
1 cell, 1 formula: 5 Excel functions that replace repetitive calculations
Say goodbye to repetitive formulas and hello to MAP, BYROW, BYCOL, SCAN, and REDUCE.