How-To Geek

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

An Excel spreadsheet comparing the XMATCH and MATCH functions, with the Excel logo on the right.
Don’t Use MATCH in Microsoft Excel: Use XMATCH Instead

Out with old, and in with the new!

Excel notes attached to cells of different sizes.
How to Make Notes Adapt to Your Excel Spreadsheet Layout

Excel notes are more adaptable than you might think.

Illustration of an Excel file with a formula and some alerts around it.
Why You Should Avoid Hard-Coding Values in Microsoft Excel Formulas

Referencing cells or named ranges is the way forward.

1
Excel Find and Replace dialog with some wildcards around it.
How You Can Use Wildcards in Microsoft Excel to Refine Your Search

Find partial matches in an instant.

Some Excel screens open showing different types of spreadsheets.
Comments vs. Notes in Microsoft Excel: What's the Difference?

Don't get overwhelmed by annotations in Excel.

2
A column in Excel with numbers in sequence and a formula next to it.
Don’t Create Numbered Lists Manually in Excel: Use SEQUENCE and COUNTA Instead

This simple formula will save you lots of time.

6
A laptop with the Microsoft Excel app.
6 Excel Keyboard Shortcuts I Wish I Knew Earlier

These shortcuts would have saved me so much time!

3
A hand with the Excel logo and a light bulb next to it, and an Excel spreadsheet in the background.
5 Microsoft Excel Hacks That Could Blow Your Mind

Impress your coworkers with these nifty tricks.

5
The Excel interface highlighting custom formatting, numbers around the screen, and the Excel logo on the left.
I Use Custom Number Formatting Instead of Conditional Formatting in Excel

There's more than one way to skin a cat.

2
A Microsoft Excel spreadsheet with a column and a row selected.
How to Use the CHOOSECOLS and CHOOSEROWS Functions in Excel to Extract Data

They're similar to the TAKE function—but they can do a lot more!

Apple Numbers logo above the Google Sheets logo with some spreadsheets around.
How to Use the AI Function in Google Sheets

Smarter Sheets, Simpler Work.

3
An Excel spreadsheet in the background with the Excel logo in front.
Everything You Need to Know About Excel Tables (And Why You Should Always Use Them)

This could totally change how you work in Excel.

2
Excel spreadsheet with a screenshot icon and the Excel logo beside it.
How to Turn a Screenshot Into Excel Data

You don't have to copy the data manually!

2
A spreadsheet with two columns being sorted, a calculator, and the Excel logo beside it.
How to Use the SORTBY Function in Excel

Dynamically reorder your data using one simple formula.

3
Illustration of an F4 key with the Excel logo.
Don’t Ignore the Power of F4 in Microsoft Excel

F4 is literally the key to excellence in Excel.

4
The Excel logo with a table in the background and 'PivotTables' and 'PIVOTBY' written next to it.
The PIVOTBY Function vs PivotTables: Which Should You Use in Excel?

Know the differences between these powerful spreadsheet tools.

An Excel table with a named range.
I Always Name Ranges in Excel, and You Should Too

Tidy up your Excel workbook.

A laptop with the Excel logo and an accessibility icon beside it.
How to Make Your Excel Spreadsheet Accessible to All

Prioritize inclusiveness when crafting your worksheets.

4
An Excel spreadsheet with the worksheet names highlighted and the Excel logo in the center.
Why You Should Always Rename Worksheets in Excel

Aid navigation and accessibility.

Two hands using a laptop with the Excel logo on the screen and some icons and charts around it.
5 Open-Source Alternatives to Microsoft Excel

If you don't rely on Microsoft Excel, why start? Try an alternative instead.

10
See More