The IF function in Excel is a powerful tool that allows you to perform logical tests and return different values based on the results of those tests. It's commonly used to make decisions and perform ...

Functions of Different Categories in Excel. To analyze your company's payroll expenditures, you might create an Excel spreadsheet and use some of the functions in the Financial or Math ...

The IF function is one of the most flexible functions in Microsoft Excel and has a range of uses that can be helpful in comparing data entries and isolating specific data points. The IF function can ...

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER () and TEXTBEFORE () in this tutorial.

How to Copy From Word to Excel. As two peas in the Microsoft Office Suite pod, Word and Excel share many similar functions, including nearly identical ribbons, tabs and menus.

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

The TRANSLATE function in Excel enables you to translate text into over 100 languages, covering a wide range of commonly spoken languages worldwide. This function is particularly useful for ...

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

In Excel, Modes can be arrays, numbers, names, or suggestions that contain numbers. The Mode function ignores values such as text, logical values, or empty cells in an array or reference argument.