Excel functions including Pivot table, Vlookup, Xlookup, Duplicate remove, ERP, and SAP.

• Pivot table: summarizes and analyzes data in a table

• Vlookup: searches for a value in a table and returns a corre...read more

Pivot table for: ALT+N+V short key. its uses for get unique data, grand sum, grant count, grand average etx.

vlook up for match the data from other data.

Hlook up for match the data with head coloun li...read more

We can present large data in short form to easily understand according to catogory wise

VLOOKUP we can find the large table value instantly with a criteria.

Duplicate remove is simple where we can remov...read more

Pivot table mainly work for organising data according to requirements. Vlookup is working for vertical lookup and loo

Yes I have good knowledge in MS Excel, Power point , Pivot table