For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...

Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a spill range so you can use the hashtag shortcut.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

Press F10, and small letters appear over each ribbon tab and quick access toolbar item. Alt+H takes you to the Home tab, ...

If Excel is not highlighting cells in the formula, place the cursor in the cell containing the formula and press fn+f2. This should highlight all the cell references.

Excel supports the use of hyperlinks and it is a very useful feature, allowing you to point out information from a website or file (E.g a .pdf file, a word document). This article will show you how to ...