Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.