This cheat sheet gets you up to speed on the features that have been introduced or changed in Microsoft 365’s Excel for Windows desktop client over the past few years. (If you’re looking for ...

2. Simplify Table References Structured table references in Excel can make formulas harder to interpret, especially for those accustomed to traditional cell references like A1:B10.

DGET is a straightforward lookup function designed to retrieve a single value from a column in a table or database. It's ...

Excel is well known as a program that allows you to create complex tables of data. However, some people are less familiar ...

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

We show you how to copy a formula in Excel without changing cell references, using mixed references and simple techniques to keep your formulas intact when moving or auto-filling.

Locking cells in a Microsoft Excel spreadsheet is among the most commonly used functions. Here’s a guide on how to lock cells in Excel.

Microsoft Excel has numerous powerful data analysis functions, but sometimes you need to do something simple like merge some cells. Here's how.

References to cells are written with the letter of the column followed by the row number, for example B6 or H8. An important thing to learn is the difference between a relative reference and an ...