Preparation of various Monthly MIS Report in Excel like State and Area wise Sales, Purchases.• Preparation Item ,Country ,Party, Quantity Wise Mis Report on Monthly basic.• Preparation Chart for comparison of production year wise every month.• Creating and updating agents’ productivity report in Dashboard and Share MIS Dashboard to the seniors. Advance Analysis & Reporting on Excel : V & H-Lookup, Dynamic (Data Validation, Pivot-Table), Advance Filter, Condition Formatting, Index & Match, Subtotal, Consolidation, Name Manager, What-If-Analysis-Data Table, Scenario Manager & Goal Seek, Sparkline & Slicer, Sorting, Offset, Mail-Merge, Net-Workdays, Sum-Product, Substitute, Date Function, Logical Operators & Functions etc