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

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

2.) In excel there is no structure or syntax of formula but functions do have a syntax. Every function has its own pre-designed parameters basis through which a function executes results. A formula can never have pre-defined parameters.

3.) OK

5.) M formula language is use in power query.

6.)Home > Transform > Data Type