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 ...

To get started, select any cell inside your data set, then choose Home > Styles > Format as Table (On a Mac: Tables > Table Styles). A ‘Format as Table’ menu will pop up. This will give you a ...

In Excel 2003, choose Style from the Format menu and skip to #3. Click New Cell Style at the bottom of the list. In the resulting dialog box, enter a name for the style, such as InputCell .

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight ...