Management Information System Executive

As An MIS (Management Information System) Executive, are required to work with Data:

• Proficiency In Advance Excel Should Have Working Knowledge In The Following Functions:

1. Super Condition Formula

2. VLOOKUP With Reverse Lookup

3. Array Formula

4. Index - At Least 6 Level

5. Filter Formula

6. Macro With Cell Reference

7. Dcounta

8. Row / Column - Formula Customization

9. Workday.Intl – 2 Level Minimum

Working Knowledge In Google Forms And Sheets

Date extract from Text

Logical Statement with True / False Condition

Logical Condition with Text and Number

Logical Condition With text Case condition

Workday Formula

Filter with Index Calculation

Advance formula in Excel