Vlookup. Vlookup is the power tool every Excel user should know. ... PivotTables. ... PivotChart. ... Flash Fill. ... Quick Analysis. ... Power View. ... Conditional Formatting. ... Transposing columns into rows (and vice versa Advanced in MS Excel including PivotTables, VLOOKUP, INDEX/MATCH, and Data Tables