Build Faster Excel Workflows Using FILTER, IFS, XLOOKUP, and LET for Real-World Data

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with confidence.
MrExcel on MSNOpinion

Excel tutorial: Sort first and last names correctly

In this video, you’ll learn how to sort names by last name in Excel, even when first and last names are in the same cell. We ...
MrExcel on MSN

Excel: Generate the alphabet with one formula (upper and lowercase)

In this video, you’ll learn how to generate the entire alphabet in Excel using a single formula, including both uppercase and ...

The storyteller you didn’t know you were training

The art of storytelling will always be human. But it’s not unreasonable to imagine AI becoming storytellers in its own right.

I won the Microsoft Excel World Championship. Here's what every office worker should know about Excel.

Diarmuid Early won first place in the 2025 Microsoft Excel World Championship. He has some pointers for using Excel at work.

Questa launches a new privacy focused AI Assistant to get insights from business files without any AI Training on them

Questa releases a Privacy focused AI Analytics Assistant that first anonymizes all sensitive information from documents to prevent AI training on them. AI Privacy is not an abstract academic concept ...

Use Microsoft Excel data types to save unnecessary typing

If you’ve ever doing an assignment for work or study that requires you to display information about a country, you could ...