News

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...
DGET is a straightforward lookup function designed to retrieve a single value from a column in a table or database. It's ...
If you regularly work with data sets in Excel, you know how important it is to be able to quickly find the information you ...
Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.
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.
This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.
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.
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 Less Than or Equal to Function in Excel. Microsoft Excel has a powerful conditional IF function that allows you to change a cell's formula if a certain condition is met.
Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.
Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.