Project 1 - Data Cleaning and Transformation using Pivot Table and Charts

1.=UNIQUE(array,[by_col],[exactly_once])

2.Syntax refers to the structure and order of a formula

3.ok

5.The Power Query M formula language, also known as M

6. Select the Date column, select Home > Transform > Data Type, and then select the Date option. You can convert other numeric types, such as percentage or currency. ...

To return the transformed data to the Excel worksheet, Select Home > Close & Load