Microsoft Excel

Microsoft Excel is the essential office productivity app but its roots go so deep that you can find it in every corner of the world running the biggest companies. Whether you're a novice or a pro, we have all of the Excel news and information you need right here.

+ See More
Readers like you help support How-To Geek. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.

latest

Laptop screen showing VBA macro code open in Microsoft Visual Basic for Applications beside a wall calendar.
Microsoft keeps removing or abandoning the Excel features that made it so useful

Excel has changed dramatically over the years—and not necessarily for the better.

2
Laptop showing an Excel spreadsheet and an open File Explorer folder overlay with weekly sales report files.
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.

Laptop screen showing Microsoft Excel with a Document Inspector window, next to a potted plant.
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.

Laptop showing LibreOffice Calc open with a revenue pivot table displaying sales figures across regions and products.
6 LibreOffice Calc features that handle jobs you'd normally use Excel for

Calc handled six jobs I normally associate with Excel, including statistical analysis, array formulas, automation, and data cleanup.

2
Laptop screen with Microsoft Excel displaying a travel data table with slicers and a Trip Costs bar chart.
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.

Photo of a computer monitor displaying a set of formulas in different columns and rows
Stop clicking every cell to check formulas: This Excel shortcut shows them all instantly

Make editing formulas quick, accurate, and easy.

Laptop screen displaying a messy Excel dataset with gaps and inconsistencies.
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.

3
A laptop screen showing two Excel windows comparing a basic task list to a finished task tracker dashboard.
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.

5
Laptop screen showing the FILTER function used in Microsoft Excel to filter golf scores.
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.

1
Laptop screen showing the Excel Quick Access Toolbar with custom command icons.
3 real programs you can build entirely within Excel

And at least one of these is something you can put together in an afternoon.

2
Laptop screen displaying a unit conversion table that uses IFERROR and CONVERT in Excel to convert six different units.
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.

Laptop screen showing Microsoft Excel displaying wide data transformed into a long dataset using Python.
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.

1
Microsoft Excel on a laptop with the Home tab selected and a table displaying columns such as Product, Category, and Salesperson.
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.

A collision pop-up message appears over the Space Defenders game window in Microsoft Excel on a laptop screen.
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.

1
A man looking frustrated while holding a laptop running Excel.
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.

An ASUS laptop displays Excel's Insert Function dialog with ABS selected from the list of available functions.
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.

1
Laptop screen displaying a complex nested formula in a Microsoft Excel spreadsheet.
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.

Laptop screen showing names pasted into a formatted range using Ctrl+Shift+V in Microsoft Excel.
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.

3
A computer screen displaying pixel art of a launching rocket open in Microsoft Excel.
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.

Top view of a notebook with a Microsoft Excel spreadsheet, a calculator, dollar bills, and glasses beside it, with the Excel logo in the center.
6 Excel hacks to elevate your spreadsheet game

Excel is a never-ending learning curve.

See More