Data Preparation

Users can narrow their view of the data that appears in a worksheet by setting complex filters using multiple operators.

For more information, see Complex Filters

Users can select non-equal operators in join conditions when mapping columns from two worksheets that are being merged.

For more information, see Combine Worksheets (Merge).

Users can optionally choose to view join suggestions when merging worksheets

For more information, see Combine Worksheets (Merge).

Users can sort a worksheet by multiple columns and select the sort order.

For more information, see Sort Multiple Columns