I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's ...

Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you! Tables are new to Excel 2007 ...

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

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format, and ...