Table.RemoveRows : Table.RemoveRows(Source,0,1) : Remove first N rows

Table.FillUp : Table.FillUp(Source,{"Col"}) : Fill nulls with below value

Table.Transposbe : Table.Transpose(Source) : Swap rows/columns

Text.EndsWith : Text.EndsWith([Col],"Ltd") : Check suffix in PQ

Text.StartsWith : Text.StartsWith([Col],"Inc") : Check prefix

Number.IntegerDivide : Number.IntegerDivide(15,4) : Return quotient

Number.Mod : Number.Mod(15,4) : Return remainder

List.Sum : List.Sum([Values]) : Sum list items

List.Sort : List.Sort([Values]) : Sort list

List.Contains : List.Contains([Values], "A") : Test membership