To make full use of the INDIRECT function, you would benefit from first knowing how to create named references in Excel. The ampersand (&) operator is a great way to create a text string that can ...

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how.

By using advanced Excel functions, you can create a dynamic total row that seamlessly adapts to additions or deletions in your array.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.