Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever.

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

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.

Looking for a way to make your Excel spreadsheets read more clearly? Why not try freezing some of the rows and columns. Here’s how.

Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel ...

How to combine values into a single cell in .xls Excel files The newer features and functions that I’ll be using later in this article aren’t available in the earlier .xls format.

This how-to guide will let you know how to freeze cells in Excel, so you can see your headings no matter how big the file is.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.