Learn how to unlock Excel’s hidden features with GROUPBY and create visually compelling, accurate reports like never before.

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...

Fix Excel’s alphabetical month sorting issue with simple tricks. Learn how to group months chronologically using XMATCH and CHOOSECOLS.

When working with a large data set, you would be more productive if you knew how to quickly find what you need. Luckily, ...

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...

There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions. Image: ...