Job Description:

- Preparing Daily, Weekly & Monthly MIS sales reports.

- Handling sales records & data on MS Excel.

- MS-office , Preparing presentation, sales report, graphs and analytical reports.

- Good typing speed with accuracy. Power point presentation skill.

- Strong in following aspects:

Lookup: Index, Match, Offset, Indirect, Vlookup, Hlookup, Address, Choose

Date & Time: Datedif, Networkdays(.intl), Workday(.intl), Weeknum, Weekday, Eomonth Arithmetical: Round(up/down), Sumif(s)

Text: Text, Value, Char, Code, Substitute, Replace, Find, Left, Right, Mid, Exact

Logical: If, And, Or, Xnor,Not, True,False, Iferror,Ifna

Statistical: Min, Max, Small, Large, Count(a) Countif(s), Average(a), Averageif(s) etc.