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's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

If you want to learn how to sort a bar chart without sorting data in Excel, then you’ve landed on the right page. In Excel, when handling worksheets filled with sales figures, it often becomes ...

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.

In this guide, we'll walk you through how to use the COUNTIF function in Excel so you can speed up the work.

The SORTBY function can be used with other functions in Excel to further refine the result. Specifically, I'll show you how to use SORTBY with FILTER to sort and filter the data in a new array at ...

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.

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

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

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