You may be well-accustomed to using cell references in Excel, but did you know you could go one step further and create your own cell references? This is where the INDIRECT function comes in handy.

Unlock the full potential of Excel's SUM function with advanced techniques for data analysis, conditional counting, and more.

A function is a built-in formula in Excel — basically, a shortcut for performing a calculation or other operation on cell data. There are nearly 500 Excel functions, and the list continues to ...

How to use the FILTER() dynamic array function in Excel Your email has been sent Filtering is a huge part of many Microsoft Excel sheets, and fortunately, there are many ways to do it. Microsoft ...

How to use the new TEXTSPLIT() function in Microsoft Excel Your email has been sent Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating or returning a ...

Don’t worry about which form to use. Excel selects the correct one based on which function_num you chose. Also, don’t worry about trying to remember all the options; Excel will provide drop-down lists ...

Using the IF function with absolute references forces the cell reference inside a formula to remain constant. Open an Excel worksheet and add data to two columns, where the first column has one ...