strong knowledge about Microsoft excel and word. Font style,character style,background style,Alignment,merging,mirroring,etc.. Good knowledge about, Rows and columns,tables,hyperlink, V lookup is the power tool every Excel user should know. ... Pivot Tables. ... Pivot Chart. ... Flash Fill. ... Quick Analysis. ... Power View. ... Conditional Formatting. ... Transposing columns into rows (and vice versa)