Create an Excel table in two seconds In addition, notice that the filter feature is automatically applied, so sorting by a specific field is accomplished by a few clicks of the mouse. 6.

Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...

To create a table in Excel, go to the Insert tab on Excel’s Ribbon toolbar and select Table. The Create Table pane will pop up asking you to select the data you want to include in the table.