In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...

Understanding the Differences Between Tables and Arrays. To successfully integrate dynamic arrays within tables, it’s crucial to grasp the distinct characteristics and purposes of each feature: ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you ...

Excel's HLOOKUP (Horizontal Lookup) function can search for a value in the first row of a table and then return a value in the same column from a row you specify.

You can edit a drop-down list in Excel using a few different methods. It's easy to edit a drop-down list if it's based on an Excel table, as the table should update automatically with your edits.