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.

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

The SWITCH function in Excel allows you to perform multiple checks on a value and return results based on conditions. Here are the details on how to use the SWITCH function in Excel. If you have spent ...

Follow the steps below to use the N function in Excel. There are two other methods to use the N function. Method one is to click the fx button on the top left of the Excel worksheet.

Wondering how to use COUNTIF in Excel? We’ve got you covered. Excel has many functions you can use in different scenarios. These functions can prove to be extremely useful in several situations, ...

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

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

Although this function may initially seem complex, especially when entering the correct parameters, it is easier to use than it appears. Below, we’ll guide you through the steps to effectively apply ...

Using the five COUNT functions in Microsoft Excel, you can count a number of items, total the blank cells, or see how many items meet your criteria. This tutorial looks at each function in detail. The ...

If you want to know how to return the highest value using the VLOOKUP function in Excel, you’ve landed on the right page. Let's say you have a sales dataset and you want to retrieve the highest value ...