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

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

This guide provides step-by-step instructions with examples how to extract a substring in Excel using various text functions.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

How to Identify One Word in a Cell in Excel. Text in a cell in Excel is called a text string. Excel provides a number of built-in functions enabling you to select and manipulate text strings in cells.

If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...

If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.

The Find and FindB functions count the number of characters of a text. We will explain how to use the Find and FindB functions 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.

Maybe you’re not interested in alternatives to Word and Excel, but bear in mind that these alternatives handle Microsoft file formats very well—not perfectly, but well enough in most cases.

You can use the VLOOKUP function in Microsoft Excel to efficiently find corresponding data for a specific value.

Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.