Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting ...

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

The User Defined Function (UDF) AL7_Transpose2D offers an advanced and powerful solution for transposing matrices or ranges of cells into Excel, surpassing Application.Transpose in terms of robustness ...

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.

Excel running totals made easy with dynamic arrays. Explore advanced functions for accurate, flexible data handling and improved performance.

We show you how to rearrange columns in Excel using four different techniques. Each will ensure that your data will not be overwritten.

If you want to learn how to transpose in Excel, we've got you covered right here with four different methods.

The easiest way to transpose data horizontally in Excel is by using the Transpose function. Select the range of cells you want to transpose, copy it, then right-click on the cell where you want to ...

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.