You may be well-accustomed to using cell references in Excel, but did you know you could go one step further and create your ...

When I enter an employee ID, Excel will automatically tell me the employee's name (using the VLOOKUP function), the total number of weeks of data we have (using the COUNTIF function), and the ...

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...

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 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 ...

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 ...

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 ...

This post explains how to use the new Excel TEXTSPLIT function. TEXTSPLIT() is a Text function in Excel. The purpose of this function is to split a given text string on the basis of one or more ...

The syntax for the UNIQUE function is =UNIQUE(array, [by_col], [exactly_once]). Note that the following content is based on Microsoft Excel 365 for PCs. Other versions of Excel may work differently.