Preparation of MIS as per business requirement
Smart fresher with Excel knowledge & understanding or Experience range of 1-2 years in advanced excel
Excel Certification preferred
Very Strong hands on experience working on multiple sheets
Able to consolidate & produce meaningful reports on daily / weekly/ monthly/quarterly basis for internal reviews & client sharing & billing purposes.
Exposure to Macros, preparing dashboards, presentations, graphs & analytical reports
Good Communication Skills and decision making abilities
Data management - Reports Structuring
Excellent Knowledge of MS Excel (Should be well versed with formulas like V-lookup, H-lookup, Pivot table, Concatenate, Trim, Countif, Coutifs, sumifs etc.)
Hands on with Excel- Formulas, Conditional Formatting, MS Office, Pivot Table, creating reports, VLOOKUP, IF Conditions etc..
MIS & Creating dashboards