After you install the Description of the security update for Excel 2016: September 12, 2017 (KB4011050), the following Get & Transform features are updated in Microsoft Excel 2016:
Add Column from examples: More Date/Time transformations, Math transformations, and Index Column support.