Table.SelectRows: Table.SelectRows(Source, each [Sales] > 1000) : Filter rows in power query

Table.AddColumn: Table.AddColumn(Source, "Profit", each [Sales]-[Cost]) : Add calculated column

Table.RemoveColumns: Table.RemoveColumns(Source,{"Index"}) : Drop unwanted columns

Table.RenameColumns: Table.RenameColumns(Source,{{"old","new"}}) : Rename columns

Table.Sort: Table.Sort(Source,{{"Date",Order.Descending}}) : Sort rows

Table.Group: Table.Group(Source,{"Region"},{"Total", each List.Sum([Sales]), type number}) :
Group and aggregate

Table.ExpandTableColumn: Table.ExpandTableColumn(Nested,"Orders",{"Sales"}) : Expand nested
tables

Table.Pivot: Table.Pivot(Source, List.Distinct(Source[Year]), "Year","Sales", List.Sum) : Pivot
rows to columns

Table.Unpivot: Table.UnpivotOtherColumns(Source,{"ID"},"Attribute","Value") : Unpivot columns

Table.Combine: Table.Combine({Table1,Table2}) : Append tables

Table.Distinct: Table.Distinct(Source) : Remove duplicate rows

Table.FillDown: Table.FillDown(Source,{"Column1"}) : Fill nulls with above value

Table.ReplaceValue: Table.ReplaceValue(Source,null,0,Replacer.ReplaceValue,{"Qty"}) : Replace
values

List.Generate: List.Generate(()=>0, each _<10, each _+1) : Generate list programmatically

Excel.Workbook: Excel.Workbook(File.Contents(path)) : Import Excel sheets