How to lock cells in Microsoft Excel, so you need a password to change or erase data

You can lock cells in Excel by heading into the program's "Protection" tab. There, you can set a password, and protect your ...

How to divide numbers and cells in Microsoft Excel to make calculations and analyze data

It's easy to divide in Excel to make calculations and analyze data in a spreadsheet. Here's what you need to know to do it.
MUO on MSN

Once you understand SCAN in Excel, you’ll never build formulas the same way

The simplest way to think about SCAN is that it applies a custom calculation to each element in a range/array and returns every intermediate result it produces along the way. If that sounds abstract, ...

Kelly Rowland Explains Iconic Microsoft Excel Text from ‘Dilemma’ Video

Nearly 25 years after she and Nelly dropped their 'Dilemma' video, she still gets questions about a specific moment that has ...
MUO on MSN

Excel’s MAP function is genius

The MAP function is part of Excel's dynamic array functions and requires Excel 365 or Excel 2021 or later to work. If you're ...